473,287 Members | 1,868 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,287 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 12823
NeoPa
32,554 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,554 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,554 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 - ...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.