Print No Data Set Band for Empty Dataset

CamelCase picture CamelCase · Dec 18, 2013 · Viewed 15k times · Source

I have a report which has a dataset. I want to print No Data Band whenever the query in the dataset returns 0 records (empty dataset).

I have set the "When No Data" to "No Data Section". But it doesn't seem to be working.

Any Suggestions?

Answer

Sharad picture Sharad · Dec 18, 2013

In order to print No data band whenever the query in the dataset returns 0 records(empty dataset) follow these steps:-

  1. Go to Report Inspector and add No Data band in the report
  2. Put static text, such as No Data Found
  3. Right-click the report to open the report property section
  4. Set When No Data property to No Data Section

After adding No data band whenever query will return 0 record "No Data" band will display the static text.