What is the best way to combine different Tables in a report, in such a way as to mimic the multiple bodies, trans-headers, and trans-footers of older versions?

(0) Share

Report

Posted on by Community Member

I am working on creating a report that prints details about a current Salesperson. It is supposed to go through Sales Order, Sales Invoices, and Sales Cr. Memos and display a summary for each document as a transheader, the lines for the document as a body, and then a total amount for the document as a transfooter. I understand that these features do not exist in RDLC, but I am using the terminology available to me ;)

I assume I must prepopulate all the information in each DataItem before passing it to the RDLC in a final Integer DataItem.

I have two different ideas, one of which involves creating my own custom table designed specifically for being a temporary table that I can design and populate as desired. The other idea would have me creating a temp table for each of the resources (one for Sales Lines,one for Sales Invoice lines, lone of Sales Cr. Memo lines), and use a variable that would tell which kind of line it was and to conditionally show (or hide) information within the layout.

Is their a recommended method? A standard?

All suggestions and comments are welcome. Thanks for your time!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

I don't think there is a recommended or standard it depends on the developer skill and design. My recommendation for your scenario is to use the following design pattern

https://community.dynamics.com/nav/w/designpatterns/119.temporary-dataset-report

You can also develop without following above approach as mentioned there are several ways you can build a solution.

community.dynamics.com/.../119.temporary-dataset-report

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,625 Super User 2025 Season 2 on at

Like (0)

Report

Hey ztodtenhagen

IF you are just concerned of the Transheader and Transfooter then I believe below link is going to help you. You dont have to do that much of stuff what you are planning now.

blogs.msdn.microsoft.com/.../transfooter-and-transheader-functionality-in-rdlcssrs-reports-revisited

Code.SetRunningTotal is the key to achieve so you need to pass the params very carefully.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

In addition to previously mentioned, refer to initial blogs.msdn.microsoft.com/.../transfooter-and-transheader-functionality-in-rdlcssrs-reports

Also, you can generate not a report but an Excel file instead; perhaps you can think of this as an easy alternative for some reports.

Was this reply helpful? Yes No