Similar Reports

• Eliza

  SSC Eights!

  Points: 967

  More actions

  March 10, 2013 at 2:02 pm

  #290612

  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

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  March 11, 2013 at 9:23 am

  #1595619

  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

• eric.muller

  SSCommitted

  Points: 1998

  More actions

  March 11, 2013 at 1:11 pm

  #1595709

  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[/url], but Googling should find plenty of examples.

  Cheers,

  Eric