hi
i have a report created which shows institution,diagnosis,pat age and the count of each diagnosis.
At the bottom of each grouping i have institution has # of cases, average age and total of diagnosis.
I want to add an extra item in teh summary which would be a case count na dthenshow the average.
I would create another query to count the total cases but how do i put this back into my report?
thanks in advance
bunker
Drag in a Singleton from the toolbox - you may need to unlock the structure to drop it into the group footing.
You can use the singleston or repeater for this
how do i bring in the total of the data totals prior to the filter being applyied?
Query associated with singleton,list,repeater or associate it with the page itself..