Crosstab Summary Function

[reitter]

Once again I'm turning to all of you experts. I'm trying to add a crosstab report in a group footer.

I'm trying to use a cross tab to show what a patient's intake and output were for each time they were taken. It looks like


Time1 Time2 Time3 Totals
Intake 5 5 5

IV Intake 10 15 20

Totals

My problem is that there is 1 number for each time. I don't want to summarize the numbers inside the table, but I do want to add them for the TOTALS.

The only way I could get this to pull the correct data is to change my summary operation to "AVG" since there is only 1 number to average it is returning the correct number. But this causes the TOTALS to average.


Me next question is the Pysicians will want to see the difference between the Intake and Output. I didn't see a difference function in the crosstab expert. Is there another way to do this?



Any Ideas?

 

[synapsevampire]

Please post Crystal version, Database used, example data and expected output.

A simile of something which doesn't work isn't much of a spec.

-k

 

[reitter]

I'm using Crystal 9 from a SQL 7 data respository, this is what my data looks like:

Time1 Time2 Time3 Totals
Intake 5 5 5 5

IV Intake 10 15 20 15

Totals 7 10 12

My totals are showing up as 'avg' since that is the function. If I choose 'sum' the cross tab is multiplying the data by 10????


Thanks, Kim