Front end interface for these reports 2

[pk400i]

We are in the process of writing or converting some reports for a company that provides services for their clients, and wants to post these reports to a company web site, and have their customers, login and get their reports. This would include a security layer within each company as well.

I am new to this type of interface and was looking for any advice on the best practice and approach, in keeping with the SSRS environment that we are to be using.

TIA,
Ralph

 

[RiverGuy]

Your most customizable approach would be to use the ReportViewer control in an ASP.Net application. See the information here:

http://msdn.microsoft.com/en-us/library/ms251771.aspx

As far as utilizing the Reporting Services instance itself, usually these applications are designed for within the enterprise, so database permissions and active directory permissions to the different sections of the Reporting Services instance will suffice. However, it seems like you're going for a custom security model, and I'm not sure what the best approach would be there. Are you going to be using active directory logins to the site or are you going to be providing your own list of logins? I can't say that I've seen forms based authentication used for the Report Manager itself, but that's not to say no one here has.

However, if you use the Report Viewer control in conjunction with reports locals to your application, you should be able to create a forms authentication based application utilizing your own, custom security model. In addition, if you keep the reports local to your application, you won't need to support the client's Reporting Services instance--you'll only need to support your application.

 

[xlbo]

There is also a login control for ASP .NET - you can use that to authenticate then a lookup table based on the lgon userid to determine what reports are visible and parameters to be passed to them (also based on logon id)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[bburnell]

I use the one built in for VS 2008. With that interface I can download the reports directly from the server, so if it gets updated there, it is also updated in my program(s). I agree with RG and Geoff though. ASP.net is usually the best way to go. It's just nice to know you have other options.
Brett

--------------------------
Web/.net Programmer & DBA
Central PA

 

[pk400i]

WHich one is this for VS 2008? is there something like that for 2005? What is it called?

 

[bburnell]

I loaded up an app. in 2008. It's called "Microsoft Report Viewer." It is under "Toolbox" --> "Reporting" (right above the Crystal Reports add-ons). I looked in VS 2005 and saw it listed there as well. I had to look under "Toolbox" --> "Data" for it. I'm not sure if I added this on, it came with it naturally, or if SQL 2005/2008 added it on, but I definitely have it in both. The viewer for asp.net can be downloaded (but I think that's just for clients though).
Brett

--------------------------
Web/.net Programmer & DBA
Central PA

 

[bburnell]

Check out these links:
*

http://www.microsoft.com/downloads/...ac-758d-45c8-b637-dd7726e61367&displaylang=en

*

http://www.microsoft.com/downloads/...3C-3B3F-4377-9AE1-26321F99FDF0&displaylang=en

*

http://msdn.microsoft.com/en-us/library/ms251671(VS.80).aspx

*

http://www.microsoft.com/downloads/...46-61E5-4D9E-BB5F-416D75A1B9EF&displaylang=en

--------------------------
Web/.net Programmer & DBA
Central PA