Grouped Report With Repeat Set To Yes - Microsoft Access / VBA

Melissa

I have a grouped report that starts a new page at each group. All the field
labels for the report are in the group header because there is a subreport
in the top part of the report that needs to grow (The subreport can't grow
in the page header!). Each page holds 21 records. I need the labels on each
page so I set the Repeat property of the group header to Yes. When a group
has 42 records, I get two pages of records with the labels at the top. This
is good! However, because Repeat is set to Yes, I get a third page with the
labels at the top but no records for that group. What do I need to do to
have the report not create the third page for that group but rather display
the next group on the third page?

Thanks!

Melissa

Nov 13 '05 #1

Subscribe Reply

2668

Marshall Barton

Melissa wrote:

I have a grouped report that starts a new page at each group. All the field
labels for the report are in the group header because there is a subreport
in the top part of the report that needs to grow (The subreport can't grow
in the page header!). Each page holds 21 records. I need the labels on each
page so I set the Repeat property of the group header to Yes. When a group
has 42 records, I get two pages of records with the labels at the top. This
is good! However, because Repeat is set to Yes, I get a third page with the
labels at the top but no records for that group. What do I need to do to
have the report not create the third page for that group but rather display
the next group on the third page?

That third page happens because there is actually some part
of the group to display. It's probably just a little blank
area at the bottom of the last (detail?, group footer?)
section in the group. Locate and remove the unused space.

--
Marsh
MVP [MS Access]

Nov 13 '05 #2

Melissa

Marshall,

Thank you for responding! You sent me in the correct direction to solving
the problem. I have a subreport in the group footer. The subreport has no
records in this situation. The can shrink property of the subreport control
was set to Yes but the can shrink property of the group footer was set to
No. This was what was causing the third page with the labels at the top but
no records for that group. I set the can shrink property of the group footer
to Yes and the report works correctly now. Thanks again!

Melissa
"Marshall Barton" <ma*********@wo wway.com> wrote in message
news:ka******** *************** *********@4ax.c om...

Melissa wrote:
I have a grouped report that starts a new page at each group. All the fieldlabels for the report are in the group header because there is a subreportin the top part of the report that needs to grow (The subreport can't growin the page header!). Each page holds 21 records. I need the labels on eachpage so I set the Repeat property of the group header to Yes. When a grouphas 42 records, I get two pages of records with the labels at the top. Thisis good! However, because Repeat is set to Yes, I get a third page with thelabels at the top but no records for that group. What do I need to do to
have the report not create the third page for that group but rather displaythe next group on the third page?

That third page happens because there is actually some part
of the group to display. It's probably just a little blank
area at the bottom of the last (detail?, group footer?)
section in the group. Locate and remove the unused space.

--
Marsh
MVP [MS Access]

Nov 13 '05 #3

Similar topics

2360

Grouped Report With Subreport

by: Melissa | last post by:

Can anyone help me with this --- I have a grouped report with a subreport in the group footer and the report starts a new page for each group. The subreport is based on a query which has criteria in one of the fields. I have a function in a standard module where the value of the function is part of the criteria. For each group, I need to run the function and have the query requery so the subreport prints the correct records. Where do I...

Microsoft Access / VBA

3319

Dcount report prints correct data but prints once for each record it checks.

by: Mike Conklin | last post by:

This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a parameter query which is the recordsource for the report. The parameter is <=. The query returns the correct amounts upto the date entered (no need for "between" dates here). There are 8 textboxes with dcounts; 2 other boxes Sum some of these

Microsoft Access / VBA

1711

Finding data using multiple fields in grouped reports

by: Randy | last post by:

I have trying to figure out the above topic. Can someone help me with this? I need for staff to be able to go to a dialog box or a form and then be able to enter data in mutliple fields and then pull up a report. I have tried parameter queries but it does not seem to work in a grouped report. I put text boxes on the report but that did not work either using a query and the text box. Please something simple as possible as I am new...

Microsoft Access / VBA

1668

Crystal Report Loads Inconsistently

by: Corbin | last post by:

I've been going in circles on this for a week. Please help: I'm running a web app with ASP.NET 1.1 and Crystal Reports for .NET. The app has three reports, two of which are reliable both on my development machine and on my client's production server. The third report is reliable on my development machine, but not on the production server. I can think of nothing different about this third report that would cause it to be so fragile. ...

ASP.NET

1825

SQL for Report

by: ApexData | last post by:

Hello I'm having a problem creating a sql statement that works for me. I have 1-Table. I have 3-Fields in this table that are bound checkboxes (Boolean) Apple/Cherry/Grape. Any of which may or may not be checked. How do I generate a SQL statement that will do the following in one report ?

Microsoft Access / VBA

5742

parse or format data from memo field onto Access report

by: RMC | last post by:

Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo field as: location1 1/1/2005 1/1/2006

Microsoft Access / VBA

4147

Missing data on a grouped/sorted report

by: anubis2k7 | last post by:

Hi, I am having a problem with dynamically sorting/grouping data in my report at runtime. My problem is that when the report is run using sorting/grouping I am missing data. Specifically, my situation is that I have a query that contains results from 2 tables that have a one to many relationship to each other (ex. 1=Contact, M=Contact Incident, 1 Contact can have multiple Contact Incidents). This query is the dataset for my report. I...

Microsoft Access / VBA

3059

Grouped Report - Count Subgroup Where...

by: nospam | last post by:

I have a report to count some statistics of case data. 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 matters at a law firm. The point is to create this report to group on the attorney. Then for each attorney count the cases where the status (CStatus is the field) is "Open", where the status is "Closed", sum the size of the media...

Microsoft Access / VBA

1402

Grouped report without data

by: regrat | last post by:

Good Morning, I'm making a report with grouped data with access 2003. Unfortunately, Access print in this report groups with empty data to fulfill all level. It's possible not to print groups level which haven't data? Thanks

Microsoft Access / VBA

9596

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9186

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7649

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6876

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5544

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5678

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4327

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3847

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3008

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General