Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Bronze

Custom historical report template with multiple dataset

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

1 REPLY
Super Bronze

Custom historical report template with multiple dataset

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
326
Views
0
Helpful
1
Replies