Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS question/option Expand / Collapse
Author
Message
Posted Thursday, November 21, 2013 1:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 21, 2014 11:47 AM
Points: 10, Visits: 36
Afternoon.

I'm currently working on a data retirement initiative within my organization. We are retiring the data from 200ish application to a data repository. One of the things we're working on is a way for the users of these apps to be able to still view this historical data. 1 person could possibly need to view multiple sets of data.

I had started creating a SSRS that lists all applications a person can see and then had the idea of setting a dynamic subreport( as you know and I didn't know, this can't be done!!).

So, my question is, is SSRS an option for the front end? Or, do I need to build an ASP.NET front end with a report viewer control? Seems like this might be the best route.

Thoughts, suggestions!?

Thanks in advance
John
Post #1516577
Posted Thursday, November 21, 2013 2:39 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:21 AM
Points: 1,234, Visits: 1,271
My first thought would be how often and how many people need to view the historical data? If one person might view it twice a year, I'd go the simplest route to present the data (SSRS would work fine). Any factor might be how important/critical is this data? For example, will you receive a fine if you can't prove/show the historical data to auditors or government regulators?

Just a couple thoughts,
Rob
Post #1516591
Posted Thursday, November 21, 2013 2:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 21, 2014 11:47 AM
Points: 10, Visits: 36
Thanks for the reply.

I think it will be viewed quite often by many users. Is Ssrs even an option for a front end? I'm thinking not as a user will want to see all reports they are legible for. That's why I'm thinking an asp.net front end with a report viewer control that display ps whichever report(application) they are wanting to see.

Post #1516594
Posted Friday, November 22, 2013 8:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:21 AM
Points: 1,234, Visits: 1,271
Take a look at the Report Manager interface. You can create folders for organization; setup security so users can only run their reports. I think it will do what you want without having to create a custom front end.

Rob
Post #1516810
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse