Custom historical report template with multiple dataset

[chrismanuh]

I have a requirement for a report which will consist of data from CSQ, Agents, and other metrics all displayed on one report.  Using crystal report as a stand alone reporting tool, i can use subreports to implement this requirements with different datasets for each subreport.  Based on what I've read from the cisco historical report tool guide, there can be only one SQL command per report so it seems a report with multiple datasets isn't supported.  Is this the case? if so, are there any workarounds?

Thanks

[Aaron Harrison]

Hi

Yes, you have to run one SP with HRC reports.

With clever programming you should be able to produce an SP which returns data from multiple parts of the system in a single dataset. No doubt there will be some limitations to what's possible with that approach, but calling the various sub-procedures for the CSQs, Agents etc, putting the results in temp tables, and then putting it all together sounds feasible!

Aaron