I was playing around with various ways to launch SQL Reporting Services reports and came across a good tip. If you work with SRS then you'll likely know you can launch a report by simply accessing the Uri to the report. For example, to launch/display a report called MyReport (at the root of the report server) you would launch the following in a browser:
BTW, you can also omit the “rs:Command=Render” at the end since that will be the default behavior anyway. But something cool you can also do (and this is the tip part I wanted to share) is that there are also other RS format types available that you can specify to export the report directly. If you wanted to export the same report automatically to Excel you would use the following Uri to the report:
That is pretty cool. If you wanted to export the report to a CSV file (or other formats too) you can specify that as well, and even indicate the delimiter too. For example, to export to CSV and use a Tab (ascii 9) as the delimiter you would use the following:
You can use any of the following: HTMLOWC, MHTML, PDF, IMAGE (for a Tiff file), CSV, and XML.