Grand Totals in a cross-tab

[Ted]

I have a report written from a cross-tab query and cannot
get it to total at the end of the report. It shows me
0.00. I have the fields positioned in the report footer
and set to running sum = over all. Is there something
unigue about doing this in a cross-tab?

In this report I have a group header that contains the
fields I want to display the total of the detail, but I am
not displaying any detail on the report. A sub-total
report, if you will. If I put the value field in the
detail section, it will calculate a running balance, but I
end up with a "total" amount after each record making the
report a lot longer than it has to be.

I can get grand totals on other reports, but this is my
first experience with a cross-tab based report.

Thanks,

 

[Rick Brandt]

I have a report written from a cross-tab query and cannot
get it to total at the end of the report. It shows me
0.00. I have the fields positioned in the report footer
and set to running sum = over all. Is there something
unigue about doing this in a cross-tab?

Running Sum is not really what you want to use there. In the report footer
use a TextBox with a ControlSource of...

=Sum([FieldName])