473,394 Members | 1,840 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 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.
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
0 2076

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Konstantin Zakharenko | last post by:
Hello, Our QA team have running a lot of test scripts (for automated regression testing), they run them on the different databases (Oracle/MS SQL). Several of those tests are dependent on the...
3
by: Jeff | last post by:
I have 3 pages of data I need printed for each record, however, Access won't allow me to create a 3 page detail section. Is there any way around this limitation? Thanks in advance Jeff
7
by: mrwoopey | last post by:
I have a asp.net application that uses the crystal report viewer control. It displays all of my reports but all of a sudden it started giving me the following error on ONLY two reports: "Fail...
32
by: Next | last post by:
Hi folks, Years ago, it occurred to me that a lot of the trouble of writing web browsers is caused by the upside-down arrangement of things: Javascript code exists inside a document, when...
3
by: marklawford | last post by:
Connected to BD2 8.2 via JDBC, can we force an application off the database? We know we can use the snapshot functions to get a view over connected users, that works find through a standard SQL...
2
by: Monty | last post by:
Hello, I have a label control in my master page like this: <asp:Label ID=lblStatusMessage runat="server"></asp:Label> When I reference the control in my code-behind I get this error "Name...
33
by: STILL LEARNING | last post by:
I'm not sure if this can even be done, but what prompts the question is my desire to be able to create an "Uber Link" script/code of some sort, such that even if the html page contains nothing but...
2
by: paulquinlan100 | last post by:
Hi I'm using automation in excel to insert a lot of data into an Access DB. Its all working fine, apart from the fact that the data entry people occasionally put "n/a" in the cells instead of 0,...
0
by: Josetta | last post by:
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...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.