Developer Forum

I need to create a special cross-tab report that allow row total for both
SUM and AVERAGE. This means that I have to have 2 columns at the end of each
row, 1 for total and 1 for average of the row.
Please let me know if this is possible, and if so, how can I get it work.

Thanks a million.

Bill

This option is available if you are using CR Version 9.0 or later, when you
add summary field in Cross-Tab expert, add it two times, and select 1st
field group option as
'Sum' and 2nd field as 'Average'.


Best Regards,

Luqman

Lugman;

This seemed to work, but I still have problem with the line up. What I need
is 2 columns labeled "AVG" And "TOTAL". The way CR works now is that it put
both avg & total in the same column. This may work if you have a single
value in the "Summarized Fields" box. I have 2 fields, so now it becomes 4
(I can supress the last 2) and the avg will occupy row 3 & 4 in the crosstab
report and makes the cell taller. I can't set it horizontal because then it
will make the cell wider!
The only solution is to be able to add a separate column for Average.

Thanks for all the help

Bill

What version of Crystal report are you using ?

Best Regards,

Luqman

Luqman;
I'm using CR10.

Thanks

Bill