News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) RDLC Expression- Addin...

Microsoft Dynamics NAV (Archived)

RDLC Expression- Adding Totals per page

(0) Share

Report

Report

Posted on by SSRS_Robert

145

Hello Everyone,

I need an expression to add a total per page in RDLC in the footer of the report. See screenshot.

So when users run RDLC report, the first page must show a total for order qty , ship qty and subtotal for the first page only.

When users go to the second page, the it must show the total for order qty, ship qty and subtotal for the second page only as in the screenshot below.

The data region that is being used is a table region, and on the footer textboxes are being used to add totals for order qty, ship qty and subtotal.

Let me know if there is any expression that can do that and how I would add it to the footer. I thank you all in advance for helping !!

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Rashed 3,765 on at

Like (0)

Report

RE: RDLC Expression- Adding Totals per page

Take a look at this blog.

http://blogs.msdn.com/b/nav/archive/2010/03/17/transfooter-and-transheader-functionality-in-rdlc-ssrs-reports.aspx
Verified answer

Mohana Yadav 59,139 Super User 2024 Season 2 on at

Like (0)

Report

RE: RDLC Expression- Adding Totals per page

Please check these blogs

blogs.msdn.com/.../transfooter-and-transheader-functionality-in-rdlc-ssrs-reports.aspx

blogs.msdn.com/.../transfooter-and-transheader-functionality-in-rdlc-ssrs-reports-revisited.aspx

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans