Display message "There is no data available" when SSRS report is empty in D365FO

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

Tables: SampleTable and SampleTrans

In this post, we will see how to set a message stating "There is no data available" if report doesn't render data for the values specified for report parameters.

Step 1:  In the report project, open the report and edit the Report design to open the report designer.

Step 2: For the Tablix, set the property NoRowsMessage value to "There is no data available". Note: Please generate the label instead of leaving it as static text, for demo purpose left the text as is.

Step 3: Select the data row of the Tablix, select AdvancedMode under the column Groups on the bottom. Set the property HideIfNoRows to True. 

Step 4: Build the solution, deployed and generated the report which yields no data.

 Report Output.

Regards,

Chaitanya Golla