Showing No Data Available in SSRS Chart.
Hi , I have a report where in there is chart available. The property NoDataMessage has been set to 'No Data Available'. But the message does not appear even if there is no data for the chart. Can any one please let me know if there is anything more to perform?Happy to help! Please mark the post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
May 3rd, 2011 1:32pm

Hi, You can use below mentioned workaround 1) Use count() to count dataset rows and set visibility of chart based on this. 2) Use textbox to display NO ROW MESSAGE and set visibility of this textbox with expession when there is no row in dataset.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2011 2:19pm

Hi Chintak, Thanks for the reply. Issue is , there is a report which is being migrated to other datasource which has the chart area which uses a dataset. The former report shows the message no data message while the latter report does not show it for the same chart area only the dataset is modified. The dataset does not return any results and I checked it. Just wanted to know if there is some report level property to make the message available when there is no data. Thanks for taking time.Happy to help! Please mark the post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
May 4th, 2011 5:25am

Hi Deepak_MSBI, Please take the following steps, and see if it works for you. 1. Select the chart from the Properties Window drop-down list. 2. Expand the Chart node. 3. Expand the NoDataMessage node. 4. Type in (Caption): No Data Available. 5. Select “False” from the (Hidden) drop-down list. After complete these steps, when there is no data, there will show “No Data Available” instead of chart. If you have any question, please feel free to ask. Thanks, Eileen
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 4:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics