Menu
I've just started working with SSRS and so far I've been able to show reports in my Winforms app using the ReportViewer, by hard-coding the report path. I would like get a list of reports from SSRS so I can display them and let the user select which one they want to see.
Is there a way to request the list of reports from SSRS? Thanks.
246
SSRS reports are stored in the ReportServer database that contains all report details.
The report server database is a SQL Server database that stores the following content: Items managed by a report server (reports and linked reports, shared data sources, report models, folders, resources) and all of the properties and security settings that are associated with those items.
Simply go to the Reporting Services server, move to the folder you want the report added and click the "Upload File" button and upload the RDL file you just saved. Make sure your data source is correct and you should then be able to run the report on the new server.
Yes, absolutely - Report Services has two well established web service interfaces.
Check out this page here: Report Server Web Service and the links off it for more info, or see the Reporting Services Developer's Guide for some background and conceptual info.
Here's the definition of the ReportingService2005 class in all its details, specifically there's a ListChildren web call which enumerates all items in a given report folder. That will return all reports (and possibly data sources)
Hope that helps a bit!
68
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
