• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

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.
0
soozh
Asked:
soozh
1 Solution
 
mlmccCommented:
CR 2008 added a capability to include calculated fields in a cross tab.  If upgrading is an option you might try that.

You can also try changing the total summary to an Average

mlmcc
CrossTabAverageR1.rpt
0
 
musalmanERP ConsultantCommented:
try building the avg field in sql server procedure (If using),,,
Many Outputs that r difficult to build on report level may achieve using procedures ...


-------------
musalman
0
 
soozhAuthor Commented:
brilliant!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now