Grand Totals in a cross-tab

  • Thread starter Thread starter Ted
  • Start date Start date
T

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,
 
Ted said:
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?
Click to expand...

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

=Sum([FieldName])
 
Back
Top