Problem with Totals

rbuser

I would like to know the total number of detail lines printed on my
reports.

I put a DBCalc to cnt the keyvalues in a summary band and this works
fine.

Well it worked fine until I started using columns. With columns, the
summary prints on a separate page. The reason I used columns was to
fit my report onto fewer pages.

How can I get the total to print at the end of the last column but in
the column?

As as alternative, I put the DBCalc in my heading and set LookAhead.
This works when there is only one page. However, if there is more than
one page, the value is the cumulative total for the pages printed to
that point.

How can I get the total into the heading of all pages?

Thanks.

nicocizik

Hi,

Please use your full name when posting to these newsgroups.

1. You should be able to place a DBCalc inside the column footer in order
to display the total count of details inside the actual column.

2. Be sure your report is set to TwoPass for lookahead values to properly
calculate.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hello:

I would like two solutions. The first would be to put the total only
in the last column of the report.

Your suggestion of Putting a DBCalc inside the column footer puts the
total in every column on every page. I only want the total to appear
in the last column on the last page. Yes, the report is set for two
pass.

The second solution I would like is to put the total on the top of
every page. When I set LookAhead, I get the correct total for the
page and the value is cumulative so that I have the value I need on
the last page. However, what I want is the same "final" total on
every page.

Thanks, Sidney

On Mon, 30 Apr 2007 07:41:23 -0600, "Nico Cizik \(Digital Metaphors\)"

nicocizik

Hi Sidney,

1. Try placing a single group around the entire report. The group footer
should only print at the end of the last column in the report.

2. The lookahead feature for the DBCalc component is working as designed.
Placing a lookahead DBCalc in the page header of a report will look ahead
and calculate the total for that page. One option would be to place a
lookahead DBCalc in the Title band and a lookahead TppVariable in the page
header band with it's value set to the value of the DBCalc. This gave me
the grand total on all pages.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com