soozh
asked on
Cross tab average in Crystal Reports XI.
I am writing a report using Crystal Reports XI.
In it i have a cross tab showing patients(row) and dates(cols) and the result of a test for the specific patient/date in the table.
I would like to show the Average of the values in each column. i.e. the average test result for all the patients on a given date.
Any idea how i can do this? All i can find at the moment is a way of showing the the totals.
I have already calculated the average in the report by grouping on the date.
In it i have a cross tab showing patients(row) and dates(cols) and the result of a test for the specific patient/date in the table.
I would like to show the Average of the values in each column. i.e. the average test result for all the patients on a given date.
Any idea how i can do this? All i can find at the moment is a way of showing the the totals.
I have already calculated the average in the report by grouping on the date.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
brilliant!
Many Outputs that r difficult to build on report level may achieve using procedures ...
-------------
musalman