Home > Ax 2012, Dynamics Ax, Dynamics Ax Books > SSRS tip: No row message in Dynamics Ax SSRS 2012

SSRS tip: No row message in Dynamics Ax SSRS 2012

September 9, 2013 Leave a comment Go to comments

Some sections in your report may not have data but the header sections  might print. In these cases to make it informative for the user a “No data available” message might be helpful since the user is then assured that there is no data for that particular data section. This tip will guide you on how to setup “No data available”.

Select the Tablix/List/Matrix control where you want the message to be available and open the properties window, Find the property “NoRowsMessage”. This property can be filled in with text or for dynamic text using expressions. Type in something like “No data available”

2013-08-30_1553

When there is no data for that particular section SSRS automatically prints the text under “NoRowsMessage”

2013-08-30_1550
For more tips and learning about SSRS – AX 2012 order the book Dynamics AX 2012 Reporting Cookbook authored by me.

7720EN_MockupCover_Cookbook

Advertisements
  1. No comments yet.
  1. October 6, 2013 at 8:04 am
  2. October 4, 2013 at 7:49 am
  3. September 30, 2013 at 3:05 pm
  4. September 30, 2013 at 6:07 am
  5. September 30, 2013 at 6:01 am
  6. September 30, 2013 at 5:48 am
  7. September 25, 2013 at 7:50 am
  8. September 23, 2013 at 7:45 am
  9. September 23, 2013 at 7:45 am
  10. September 23, 2013 at 7:45 am
  11. September 21, 2013 at 6:30 pm
  12. September 18, 2013 at 7:46 am
  13. September 16, 2013 at 7:45 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: