Link to home
Start Free TrialLog in
Avatar of vbnetcoder
vbnetcoder

asked on

running a SSRS repot from a .net application

I need to do the following tasks from a .net application

1) populate a list with the names of all the reports on the server

2) when a user selects the report it will execute

Can anybody point me in the right direction on how to do this using VB.net
Avatar of Bob Learned
Bob Learned
Flag of United States of America image
I haven't ever needed to get a report list from a server, but there are queries that you can run to get that list:

Get Reporting Services Report List from Database
https://nathondalton.wordpress.com/2010/02/22/get-reporting-services-report-list-from-database/

Select   [Name],
               [Description],
               SubString([Path],1,Len([Path]) – (CharIndex(‘/’,Reverse([Path]))-1)) As [Path],
               Case
                        When [Hidden] = 1
                        Then  ‘Yes’
                        Else    ‘No’
               End As [Hidden]
From    [Catalog]
Where  [Type] = 2
Order By SubString([Path],1,Len([Path]) – (CharIndex(‘/’,Reverse([Path]))-1)),
               [Name]

Open in new window

Avatar of vbnetcoder
vbnetcoder

ASKER

If possible i want to do this with a web service call
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vbnetcoder
vbnetcoder

ASKER

ty