Similar Reports

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply