I am looking for an alternative to the Report Manager for displaying the list of available reports to end-users.

There is a stored procedure on the report server (ReportServer DB) which will return a list of all reports.
I have used it to create a report showing all reports in a folder and subfolders, and show the permissions and roles granted.

exec FindObjectsNonRecursive @Path=N'', @AuthType=1

exec FindObjectsRecursive @Path=N'', @AuthType=1

Thanks for this, with this I am sure I could make a suitable webpage.  But to be honest, I was hoping there would be some ready made alternatives available.

Also, I am not sure how I would get this webpage to use the security extensions we use to validate users and roles against the PMS security tables.

Thanks
 

Thanks for the reply, I had actually been to your blog, and posted a similar quetion there.  Thanks for the link to the RSExplorer sample.  

Have you tried this using a custom security extension? We need to use a custom security extension to obtain the user name, password and roles from the main application database. This is possible using the standard Report Manager, I was just wondering how this will work with a custom interface.  We would obviously still need the custoemr extension incase someone bypasses the nice new front end with a URL and goes straight for a report.

Ah, it's a small world isn't it :-)

I don't really have hands-on experience with that but I would think that it's possible.  Before your application connects to the SSRS web service it could connect to your main app DB and perform your custom checks.  Not sure if that is what you meant?

I think I will have to try a little trial and error, and maybe implement two security options, a hardcoded one in the new custom Report Manager, and then using the extension for anyone using a url to access a report directly. I am just afraid we might end up with two login boxes being presented, one for the custom Resort Manager, then one for the report itself.

Is is me, or is there not much mayerial on this sort of stuff on the net, or am I just being difficult and pushing the boundaries of this product?

Thanks

It's good to be difficult sometimes, that's how you learn :-)  Information may indeed be more limited than on other subjects but if you think about it it seems quite logical and has to do with the number of people working on these type of solutions: SQL Server > Reporting > Advanced reporting...  Not everyone uses SQL Server, nor Reporting and so on...

Back on topic: I have located another sample which may help you, called Security Extension.  It can be found here if the earlier mentioned samples are installed in the default folder: C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample\

Good luck implementing this, I believe that it's an interesting project :-)

I don't know why, I always worry about projects when there is not much info on the internet, it can mean it works first time, so no one needs to ask questions, or no one else is using this platform. :-~

The security extension is not a problem, have already produced a partially working version of that. The Login part is done, am now working on the lesser documented roles part.  I started with the example you mentioned, also some info at http://www.devx.com/dotnet/Article/26759/0/page/1.

Although I was looking for an "off the shelf" solution, I guess none are currently avaiable. So I will go and make one suitable for my needs, armed with the informaiton you have given me.  Thanks