SSRS and Report Manager to access separate files

Question

Good Day,

We use the report manager utility within SSRS to allow a user to access various reports. For all the reports created and hosted within the ReportServer database this is fine, however we have a list of separate reports, mainly .txt files, that the users need access to as well.

My Question: Is it possible to have a shared folder, containing all these text files, accessible via the report manager front end?

Hope someone can shed some light on my query....

Thanks in advance

Answer 1

I do not think so, but why not having a shared folder on file system to have an access for everyone needs those reports?

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Answer 2

Hello,

Report Manager provides an upload feature that we can add reports, models, and other files to a report server. These files are published to a report server as a resource. Resources can be any file type and type of file you upload determines how it is stored. Whether a resource can be viewed by report users depends on the viewing capabilities of the browser.

In your case, you can create a shared folder in Report Manager, and upload these text files to this folder. User who has permission to access to this folder, for example, User assigned to “Browser” role, can review this files.

For more information about resources in Report Manager, please see:
http://msdn.microsoft.com/en-us/library/ms159711(v=sql.100).aspx

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support