如何在 SSRS 中导出没有标题的 csv
是否有任何方法可以关闭仅一个 SSRS 报告的 CSV 导出标题?
Is there any way of turning off the header for a CSV export on just one SSRS report?
我正在使用 Report Builder 3 并从报告中删除了标题,但是在导出到 CSV 时它们又回来了.我找不到可以关闭它们的地方.
I'm using Report Builder 3 and I deleted the headers from the report, but when exporting to CSV they're back. I can't find anywhere to turn them off.
我看过这个问题 但它似乎涵盖了服务器上的所有报告,我只需要关闭几个标题即可.
I've seen this question but it seems to cover all reports on the server, I only need to turn the headers off for a couple.
开箱即用的数据驱动订阅无法做任何事情.可能可以编写自定义订阅扩展来执行此操作.您也无法直接从 Report Builder 导出,除非您做了一些聪明的事情,例如添加一个看起来像按钮的独立文本框,然后将一个操作与其关联,从而创建一个 URL,以便您使用 URL Access 打开/呈现报告.您可以在此处查看一些信息:http://msdn.microsoft.com/en-us/library/ms155046.aspx.
You can't do anything with the data driven subscription out of the box. It might be possible to write a custom subscription extension to do it. You also cannot do anything about exporting directly from Report Builder, unless you did something clever like add a freestanding textbox that looks like a button and then associate an action with it that creates a URL for you to open/render a report using URL Access. You can see some information here: http://msdn.microsoft.com/en-us/library/ms155046.aspx.
使用 URL Access,您可以传入 CSV 设备信息,在您的情况下 NoHeader=true 根据 http://msdn.microsoft.com/en-us/library/ms155365.aspx
With URL Access you can pass in the CSV device info, in your case NoHeader=true as per http://msdn.microsoft.com/en-us/library/ms155365.aspx