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

Similar Reports Expand / Collapse
Author
Message
Posted Sunday, March 10, 2013 2:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, July 5, 2014 1:33 PM
Points: 33, Visits: 81
Hi,

We have many reports running that are very similar. Usually 1 column difference for example

Sales by Product
Sales by Month
Sales by Country

We don't have a data warehouse but is there any way we can use SQL to combined these three datasets efficiently but perhaps through parameters only run the chosen report?

I thought about union everything together but I think this might be inefficient and was hoping someone would have a better idea.

Many thanks
Eliza
Post #1429018
Posted Monday, March 11, 2013 9:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, July 27, 2014 8:47 PM
Points: 316, Visits: 1,483
Eliza:

I hate to say it, but you need to provide a little bit more information. When you say the reports differ only slightly, does that suggest that all three reports basically contain the same information (i.e., each report basically contains the same data) but merely displayed slightly differently?

Thanks,
Pete



Post #1429342
Posted Monday, March 11, 2013 1:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:43 PM
Points: 262, Visits: 775
I think you want to do some research on something called "dynamic grouping", it will let you use the same dataset and group based on a user-selected parameter.

One good page is here, but Googling should find plenty of examples.

Cheers,
Eric
Post #1429453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse