CODEWITHSUNDEEP
sqlreporting-services
claudekennilol
claudekennilol

Reputation: 1069

How do I get a list of the reports available on any given reporting server?

I'm wanting to be able to input any given report server url and display a list of reports available on that server.

I found this question, and it's useful if I compile the project with a reference to a specific sql server (How do I get a list of the reports available on a reporting services instance). But (unless I'm just completely missing something which is possible) it doesn't show me how to do what I've stated above.

Upvotes: 4

Views: 39553

Answers (3)

Allan F
Allan F

Reputation: 2288

Same as answer above, with a use clause added at top (in case this helps anyone ..) :

Use ReportServer;
SELECT *
FROM dbo.Catalog
WHERE Type = 2
Order by Name

I noted that select * above contains a field called Content which might be an issue for an export of result to excel .. So I tried a lesser list of columns :

Use ReportServer;
SELECT 
  ItemID, 
  Path, 
  Name, 
  ParentID, 
  Type, 
  Description, 
  Hidden, 
  CreatedByID,
  CreationDate,
  ModifiedByID,
  ModifiedDate,
  Parameter
FROM dbo.Catalog
WHERE Type = 2
Order by Name

The first answer above didn't seem to work for me .. i.e. http://server/ReportServer
(replacing server with my reporting server name ..) I get message "The webpage cannot be found" ..
Maybe this answer is version or security settings specific ?

Upvotes: 3

suff trek
suff trek

Reputation: 39777

You can go to Web Service URL (note: not Report Manager URL). So if your main managing URL is http://server/Reports and Web Service URL is http://server/ReportServer - open the second one. It will give you raw listing of available items.

Note that this will include reports, datasources, folders etc.

Upvotes: 3

Lamak
Lamak

Reputation: 70638

You could query the ReportServer database of your reporting server.

SELECT *
FROM dbo.Catalog
WHERE Type = 2

Should give you a list of all of the reports.

Upvotes: 20

Related Questions