Post reply

SSRS 2005 no data selected

  • February 27, 2010 at 11:38 am

    #386404

    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!

  • February 27, 2010 at 2:10 pm

    #1126149

    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]

  • February 27, 2010 at 4:02 pm

    #1126159

    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?

  • February 28, 2010 at 9:57 am

    #1126274

    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. 😉

  • March 1, 2010 at 6:42 am

    #1126430

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

  • March 5, 2010 at 10:57 am

    #1129329

    Yes i hope so...

    Thanks

    veeren

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

  • March 5, 2010 at 11:37 am

    #1129357

    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