已发布的RDL文件位于何处?

时间:2021-11-10 00:21:53

When publishing a reporting services report. Where does the actual .RDL file sit on the server?

发布报告服务报告时。实际的.RDL文件在服务器上的位置是什么?

I can redownload the .RDL file via browsing through the report manager? But where is this file situated on the reporting services server?

我可以通过浏览报表管理器重新下载.RDL文件吗?但是这个文件位于报告服务服务器上的哪个位置?

Thanks

4 个解决方案

#1


It is not a file on the server. It stored as a BLOB in the ReportServer database.

它不是服务器上的文件。它作为BLOB存储在ReportServer数据库中。

(In the Catalog table to be precise on SSRS 2005)

(在目录表中准确地说是SSRS 2005)

Extended Answer

#2


This page shows how to retrieve this using T-SQL

此页面显示如何使用T-SQL检索它

http://mscrmuk.blogspot.com/2009/05/reading-rdl-definitions-directly-from.html

Jeff

Update: here's the relevant query, in case that blog post disappears in the future:

更新:这是相关查询,以防博客文章在将来消失:

select convert(varchar(max), convert(varbinary(max), content))
from catalog
where content is not null

#3


Following query specifically provide the report's blob

以下查询专门提供报告的blob

 SELECT Name, convert (varchar(max), convert (varbinary(max),[Content])) AS ReportRDL
 FROM [dbo].[Catalog] where TYPE =2

#4


One way to achieve this is open the report in Report Builder. Then click on file -> save as, then save it in the desired location.

实现此目的的一种方法是在报表生成器中打开报表。然后单击文件 - >另存为,然后将其保存在所需位置。

Another way, When you open the report URL in the Internet Explorer,on hovering the report you'll see a drop down and there is an option to download the report.

另一种方法是,当您在Internet Explorer中打开报告URL时,在悬停报告时,您会看到下拉列表,并且可以选择下载报告。

Hope this helps.

希望这可以帮助。

#1


It is not a file on the server. It stored as a BLOB in the ReportServer database.

它不是服务器上的文件。它作为BLOB存储在ReportServer数据库中。

(In the Catalog table to be precise on SSRS 2005)

(在目录表中准确地说是SSRS 2005)

Extended Answer

#2


This page shows how to retrieve this using T-SQL

此页面显示如何使用T-SQL检索它

http://mscrmuk.blogspot.com/2009/05/reading-rdl-definitions-directly-from.html

Jeff

Update: here's the relevant query, in case that blog post disappears in the future:

更新:这是相关查询,以防博客文章在将来消失:

select convert(varchar(max), convert(varbinary(max), content))
from catalog
where content is not null

#3


Following query specifically provide the report's blob

以下查询专门提供报告的blob

 SELECT Name, convert (varchar(max), convert (varbinary(max),[Content])) AS ReportRDL
 FROM [dbo].[Catalog] where TYPE =2

#4


One way to achieve this is open the report in Report Builder. Then click on file -> save as, then save it in the desired location.

实现此目的的一种方法是在报表生成器中打开报表。然后单击文件 - >另存为,然后将其保存在所需位置。

Another way, When you open the report URL in the Internet Explorer,on hovering the report you'll see a drop down and there is an option to download the report.

另一种方法是,当您在Internet Explorer中打开报告URL时,在悬停报告时,您会看到下拉列表,并且可以选择下载报告。

Hope this helps.

希望这可以帮助。