ssrs display text with no data

  • abdalah.mehdoini

    Right there with Babe

    Points: 797

    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

    Sans titre

  • jonathan.crawford

    SSCertifiable

    Points: 6326

    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

  • Andrey

    Old Hand

    Points: 383

    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)
  • David Burrows

    SSC Guru

    Points: 64419

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply