ssrs display text with no data
-
Hello everyone
I would like to modify my report ssrs way if there is no data to post a text field appears saying that there is no data to display during this period
thank you
-
In your dataset, check to see if your results are null, if so, return "No Data Available" or some such in one of your fields in the SELECT. So, for instance, run everything into a temp table rather than just pulling it back. Add an IF @@rowcount = 0 BEGIN SELECT 'No Data available' AS Serveur END
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses -
you can create textbox with desired text and make it visible only when there are 0 (zero) records in the dataset
visibility expression :
=iif(CountRows("YOURDATASET")>0,true,false) -
Add a new row at the end of the table outside of any groups
Add text and format the row
Change the row visibility to hide the row if the dataset contains rows
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply