SSRS 2005 no data selected

  • In sql server report 2005 (SSRS 2005), I will be generating some reports that may not have any data selected at times. This can you can tell me how can you display a message like 'The report is not generated since no records' were selected for this report. Can you tell me how to solve this problem either with sql and/or a sql server report 2005? If not no is selected, what will sql server report display? Would it display anything at all!

  • wendy elizabeth

    Would it be too difficult for you to create a report that will NOT return any data and test what the report will show or do? And then ask you question?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • The report that would display no data is an error report. I am expecting most of the time that no data would be in the report. Thus, I expect the report to have no data.

    Thus how can I display a message stating 'No errors' are located?

  • Hi,

    I think i am not sure in SSRS 2005 !

    In SSRS 2008-CLick on

    tablix properties-

    NorowsMessegae-

    "U r own message"

    Thanks

    Veeren.:-)

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • For SSRS 2005, you will need to add your message to the "NoRows" property of the table or matrix.

  • Yes i hope so...

    Thanks

    veeren

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • Thanks! This helped alot!

Viewing 7 posts - 1 through 6 (of 6 total)

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