April 10, 2012 at 3:25 pm
I have a report defined with 4 parameters (SQL 2005). If zero rows are returned I want the report to return "No Data Found" or something similiar. If a row is returned I don't want the report to display, instead I want it to automatically export in a csv format to a designated location. Is this possible?
April 11, 2012 at 7:11 am
You can use the NoRowsMessage property for your message. I don't think you can build a report that will automatically export to a format when run from the report manager. However, you can create a subscription that will automatically dump to a csv file.
April 11, 2012 at 12:20 pm
Thanks for the reply. A subscription is not an option in this case because I need the report run on demand with various user parameters.
April 11, 2012 at 12:58 pm
Then the only other possibility I can think of is to construct a URL somehow with the appropriate parameters with the render format set to your desired output.
If the parameters are specific to the user and do not vary from day to day you can just give them a fixed URL that they can bookmark to run the report when they want.
If the parameters vary on a daily basis you will probably need an ASP.Net or maybe a windows application (.Net of some other sort) to build the URL you want on demand.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply