web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :

Display selected parameters on SSRS report in D365FO

Chaitanya Golla Profile Picture Chaitanya Golla 17,225

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 is left as-is.

In this post, we will see how to display the selected parameters on the report. For demo purpose, will display the report parameters start date, end date and Id on the report.

Step 1: In the project solution, open the report and edit the design to view the report designer window. 

Step 2: In the page header section of the report add a textbox, align it underneath the company info textbox. Right click on it, select the expression and provide the expression value.

Expression: ="Id value: "+Parameters!SSRSReportDP_Id.Value

Step 3: In the page header section of the report add a textbox, align it underneath the Id textbox(created earlier). Right click on it, select the expression and provide the expression value.

.Expression: ="Start date: "+Parameters!SSRSReportDP_StartDate.Value

Step 4:  In the page header section of the report add a textbox, align it underneath the  Startdate textbox(created earlier). Right click on it, select the expression and provide the expression value.

Expression: ="End date: "+Parameters!SSRSReportDP_EndDate.Value

Step 5: Built the solution, deployed the report and generated it to see the selected parameters values on the report.

Report Design

Report Output

Regards,

Chaitanya Golla

Comments

*This post is locked for comments