471,066 Members | 1,332 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

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.
Ronald Reagan Parkway
County Line Road
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
0 1893

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.