Post reply

Suppressing printing if no data

  • March 24, 2008 at 2:15 am

    #188377

    hi, Please tell me that with SQL Reporting there is some way to suppress printing if no data returned? So if did not want reports to print when an order is cancelled you would just make stored proc return nothing in that scenario and nothing would print?

    So if the data set doesnt return ny value , then RDL should not print blank page.

    Does anybody faced this, any help willbe highly appreciated.

    Thanks

    Meghna

  • March 25, 2008 at 5:50 am

    #793403

    Is the issue you don't want the page to appear or you don't want text contained in a header to print? A page will always appear when generating the report. There is a text property on the Report where you can add a message if no data is returned.

  • March 25, 2008 at 11:26 pm

    #793856

    How to do that? Can you please tell me?If for example , my data set returns no data then there will be blank page diplaying with header which will be also be printing , how to avoid printing blank page in that case?

    can you pleease guide me?

    Thanks

  • March 27, 2008 at 7:21 am

    #794573

    To display a message in the report, set the NoRows property with whatever text you want displayed.

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

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