I have very large rdl report, about 50 columns and 500,000 rows. The SQL procedure that lies behind the report is just ordinary select * from table. It takes just a few seconds to execute. However, when I want to render that report in SSRS, it takes too long.
The end user wants just to export that report in csv. He doesn't need SSRS to render the report. Is there a way to set up default render mode of the report to csv. Then, when the user runs it, the report will automatically ask him to save in .csv, without rendering?
Easiest is to use URL Access, specifying &rs:Command=render&rs:Format=csv
Another method is to use the API - I guess it depends on what you are most comfortable with.