ssrs display text with no data

  • abdalah.mehdoini

    SSC Eights!

    Points: 871

    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


    Points: 6551

    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

    Right there with Babe

    Points: 723

    you can create textbox with desired text and make it visible only when there are 0 (zero) records in the dataset


    visibility expression :

  • David Burrows

    SSC Guru

    Points: 64695

    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.

Viewing 4 posts - 1 through 4 (of 4 total)

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