473,405 Members | 2,310 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,405 software developers and data experts.

Report Losing Group Count

37 32bit
I have a report that loses it's group count. In the Group Header there are two TextBoxes, "txtMfg" which is bound to and shows the names of manufactures in the table named "tMfg", the second TextBox named "txtMfgCount1" counts the number of times "txtMfg' changes in the (Mfg Group), and it's property settings are "=1" in it's Control Source and the Running Sum set to "Over All". I have also set Running Sum to "Over Group" and got the same results.

In the Report Footer I have a TextBox "txtMCount1" with it's Control Source at "=[txtMfgCount1]" which shows the number of times "txtMfg" has changed in the Report.

When the Report is opened in Report View, the Report Footer, "txtMCount1" shows a number of "8" which is the right number.

The problem is when I go to Print Preview the textbox "txtMCount1" shows a number of "1" not the expected number of "8".

Has anyone ever had this happen, if so how did you fix it.
Sep 11 '22 #1
7 12832
NeoPa
32,556 Expert Mod 16PB
What happens if you print the report to the printer? I would hope it matches the Print Preview, but if it matches the Report view then you should be ok.
Sep 11 '22 #2
Curious27
37 32bit
Hi NeoPa

Report View shows "8" (Correct Answer)
Print Preview shows "1"
Print shows "1".
Sep 12 '22 #3
NeoPa
32,556 Expert Mod 16PB
:-(

Do you use the Detail Section at all? If not then you can redesign such that each group is a single detail record and then tally more reliably.

Good & clear response by the way :-)
Sep 12 '22 #4
Curious27
37 32bit
Thank you.

I use the detail section to show all the related items to each Mfg .
Sep 12 '22 #5
Curious27
37 32bit
I just put a TextBox "txtTItem" in the Report Footer to count the Detail Section "txtItems" and it returns the correct value "23".

Report View "23"
Print Preview "23"
Print "23" (Hard Copy)

This extra TextBox does not affect the Group total as expected.
Sep 12 '22 #6
NeoPa
32,556 Expert Mod 16PB
I was afraid that might be the case :-(

I'm really not sure how I'd go about fixing this if I'm honest. You could possibly capture the OnPrint or OnFormat event procedures and manage your own count, but as print previews can go backwards as well as forward that means subtracting from your count as necessary as well as adding.

Not sure what to suggest as far as the fundamental design goes though. Sorry.
Sep 13 '22 #7
Curious27
37 32bit
Thank you for looking at it.

This problem occurred one other time about a year ago, I did go through some notes but didn't find anything.
I'll go through all these DB's from that pass and research them, it's here somewhere and when I find the fix I'll share it with you.

Thanks again...
Sep 13 '22 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Yasin | last post by:
Hi I have one reports which shows the Account wise daily transaction during the day.(pl's find below report layout format with column description) May or may not be each account have multiple...
3
by: David | last post by:
Hi, I have a report for which each record is a product. I have the fields: ProductName and GroupCode There may be several variants on each ProductName, BUT, with the same group code i.e.
1
by: John | last post by:
Hi I have a field that can have either A, B or C as its value. I need to write a query that will return the number of A's, B's & C's in the field X for a given criteria and then the total...
3
by: bluepiper | last post by:
I'm new with VB 6 Data report. I want to use it to create simple reports that can group by specified field. Ex. Fields: Doctor_Name Address Sched Laboratory Count(Laboratory) as LabCount
1
misscrf
by: misscrf | last post by:
have a report that I am trying to build and I can't figure out how to make Access group and sum/count information to give me a nice statistics report. Basically the database has case information for...
2
by: EORTIZ | last post by:
I have a report that is grouped by a field. I have looked for ways in which it would be possible to obtain an individual report for each group to export to PDF. Since if I have all groups in the...
1
by: eko99312 | last post by:
I made a report concept from a simple query that contain as follow SELECT ., .Reason FROM GROUP BY ., .Reason HAVING (((.)>= And (.)<=) AND ((.Reason) Is Not Null)); When I click the view...
1
by: babai28 | last post by:
Hi, I wish to hide the group tree of the crystal report viewer programatically. Intellisense denied any "DisplayGroupTree" property of the control! A little googling yielded the fact that in VS...
2
by: Jmundle | last post by:
I would like to use the Count if Expression for more than one value. =Count(IIf(="Active",0))this works for 1 value I also need to add another field Example: Count if Status = A or B or C and...
10
by: Gareth Jones | last post by:
I have a report based on the below query/table: Parent Record - Child Record - Ref Alarm A1 - Alarm A1 - 1 Alarm A1 - Alarm B2 - ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.