467,907 Members | 1,624 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

Report Totals require "Force New Page"

Here is something really bizarre that is happening...let me see if I
can describe it.

I have a report which has two locations on it. Primary Location and
Secondary Location. I have both locations grouped. For example:
Primary Location (group header 1) is a city.
Secondary Location (group header 2) is a Street Address.
Avon
Ronald Reagan Parkway
Greenwood
County Line Road
Indianapolis
Senate Boulevard
Kessler Bouldevard
Clearvista Drive

I have invisible text boxes in both headers, which I have set to =1
and a running sum over all.
I have invisible footers which reference the name of the text box with
the running sum.
All is working very well with that.

In the report footer, I have a text box that says:
="Total Primary Locations: " & [Text46] (which references the text box
in the footer)
I also have one like this for the secondary location.

So my text box should read:

Total Primary Locations: 3
Total Secondary Locations: 5

Here's what actually happens:

If I use Force New Page on the Report Footer, the totals are correct.

If I don't, the totals say

Total Primary Locations: 1
Total Secondary Locations: 1

But I really want both totals to fit on the first page if they can,
without having to force a new page.

Has anyone encountered this before? It seems to be a bug having to do
with the format count. Is there a workaround for this?
Jul 17 '08 #1
  • viewed: 1697
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Next | last post: by
2 posts views Thread by paulquinlan100 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.