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!