如何在不渲染的情况下将SSRS报告直接导出到csv(How to export SSRS report directly to csv without rendering)

如何在不渲染的情况下将SSRS报告直接导出到csv(How to export SSRS report directly to csv without rendering)

我有非常大的rdl报告，大约50列和500,000行。 报告后面的SQL过程只是普通的select * from table。 执行只需几秒钟。 但是，当我想在SSRS中呈现该报告时，它需要很长时间。

最终用户只想在csv中导出该报告。 他不需要SSRS来呈现报告。 有没有办法将报告的默认呈现模式设置为csv。 然后，当用户运行它时，报告会自动要求他保存在.csv中，而不进行渲染？

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?

最满意答案

最简单的方法是使用URL Access，指定&rs:command=render&rs:format=csv

另一种方法是使用API​​ - 我想这取决于你最满意的。

请参阅https://msdn.microsoft.com/en-us/library/ms152835.aspx

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.

See https://msdn.microsoft.com/en-us/library/ms152835.aspx