We help IT Professionals succeed at work.

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

739 Views
Last Modified: 2010-04-21
We are developing a reporting infrastructure to go with our Property Management System. We have standardised on Reporting Services 2005 for the production of the reports, however we find the Report Manager application limited in its ability to be customised.

We don't want to create a webpage full of static links, it needs to be a dynamic list, following the structure of the folders in the Reporting Services server. It also needs to use the security system of the Reporting Services, as we have produced an Security Extension to controll accress to the folders and reports.

Has anyone every come across a tool or application that can do this?
Comment
Watch Question

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

Author

Commented:
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
 
BI Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
ValentinoVBI Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
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?

Author

Commented:
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
ValentinoVBI Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011

Commented:
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 :-)


Author

Commented:
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.

Author

Commented:
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
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.