March 10, 2013 at 2:02 pm
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
March 11, 2013 at 9:23 am
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
March 11, 2013 at 1:11 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply