Displaying total value on SSRS report in D365FO

Hi,

Hi,

Please refer to my earlier post to view the report SSRSPrecisionDesign related classes, tables and menu Item.

https://community.dynamics.com/365/financeandoperations/b/daxology/posts/creating-a-simple-report-in-d365fo

Custom Tables: SampleTable and SampleTrans

Note:  Please generate the labels accordingly, for demo purpose static text was left as-is.

In this post, we will see how to display total value on report.

Step 1: In the Visual Studio solution, select the required report and click on "edit using designer" option to open the report designer window.

Step 2: Added a new row the Tablix, in the first text box entered the text Total and in the last text box entered the expression such that summation happens on the Amount column.

Step 3: For the total amount textbox, set the format property value to 'n'

Step 4: Built the solution, deployed the report and generated the report to see the total value.

Report Design

Report output

Regards,

Chaitanya Golla