SSRS 2005:如何在报告中提供可供下载的 varbinary 数据?
SSRS 新手问题在这里...
我有一个表,其中一列是 varbinary(max) 数据。我想制作一份报告,使这些数据可以作为超链接下载,以便用户只需单击该项目即可获得二进制数据的文件下载对话框。在这种特殊情况下,二进制数据恰好是旧 pdf 文件的内容,但这并不重要。
我尝试四处搜索,但找不到任何有关如何执行此操作的指示。在我看来,这应该是可能的。 有多种方法可以在报表中显示图像 使用 varbinary 数据,因此应该能够在报告上下载任意二进制数据是有道理的,对吧?
SSRS newbie question here...
I have a table where one column is varbinary(max) data. I would like to make a report that makes this data available for download as a hyperlink so the user can just click on the item and get a file download dialog for the binary data. In this particular case, the binary data happens to be the content of old pdf files, but that shouldn't matter.
I tried searching around but I can't find any pointers on how to do this. It seems to me that it should be possible. There are ways to display images in a report using varbinary data, so it makes sense that one should be able to make arbitrary binary data downloadable on a report, right?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
不,据我所知这是不可能的。无论如何都看不到这样做。
我使用的解决方法是创建一个简单的 asp.net 页面,通过某个 URL 提供二进制内容。然后,我从 SSRS 报告中超链接到该页面,并在 URL 中提供了正确的变量。如果您必须担心 URL 黑客攻击或安全问题,那么对我来说效果很好,YMMV。
No, it is not possible as far as I can tell. Don't see anyway to do this.
The work-around that I used was to create a simple asp.net page to serve the binary content through some URL. I then hyperlinked to that page from the SSRS report giving the right variables in the URL. Works fine for me, YMMV if you have to worry about URL hacking or security issues.