>I have a query result that I've put into a report, the data is from a stored procedure on SQL Server. The report is grouped on meetingnumber. The group header contains the static information, and the detail has one field that repeats if necessary for each record that has that meetingnumber. Each group represents a "case" and a case may have one or more "Procedures". I'm trying to figure out how to print totals at the the bottom of the report that display that information. I'm not sure where/how to capture the values.
>
>Thanks for any guidance.
With report variables, combined with calculation options, you can get both totals, and record count. Which part are you missing?
By the way, it is best to combine data into a single cursor, before running the report. Perhaps you already did this part.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)