A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing of sub-report skips to second page.



 
 
Thread Tools Display Modes
  #1  
Old April 10th, 2010, 05:18 AM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Printing of sub-report skips to second page.

Hi,

I'm using Access via Office XP Pro on Windows 7.

I'm working on an invoice "form" report. It is comprised of a main report
and a sub-report. (I have the same issue on my work order "form" report.)

The main report's record source is tblWorkOrder table, grouped by work order
/invoice number (work order is same as invocie number) and is comprised of:
Work Order Header section
Detail section (sub-report is in this section)
Page Footer


The sub-report's record source is tblWorkOrderDet, grouped by work order /
invoice number, and is comprised of:
WorkOrderHeader section
Detail Line section
WorkOrder Footer section


Question:

If all of the details in the sub-report fit on the first page, everything
works great. If there are more details than will fit on the first page, ALL
of the details are printed on the second and subsequent pages leaving the
first page 3/4 empty.

The sub-reports's Work Oder Header, Detail, and Work Order Footer's "Keep
Together" properties are all set to "No". The report's detail section's
"Keep Tother" is also set to "No".

How do I get the details to start printing on the first page even if they
subsequently run over to the second and later pages.


--
Dennis
  #2  
Old April 10th, 2010, 02:17 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Printing of sub-report skips to second page.

Dennis wrote:
I'm using Access via Office XP Pro on Windows 7.

I'm working on an invoice "form" report. It is comprised of a main report
and a sub-report. (I have the same issue on my work order "form" report.)

The main report's record source is tblWorkOrder table, grouped by work order
/invoice number (work order is same as invocie number) and is comprised of:
Work Order Header section
Detail section (sub-report is in this section)
Page Footer

The sub-report's record source is tblWorkOrderDet, grouped by work order /
invoice number, and is comprised of:
WorkOrderHeader section
Detail Line section
WorkOrder Footer section

Question:

If all of the details in the sub-report fit on the first page, everything
works great. If there are more details than will fit on the first page, ALL
of the details are printed on the second and subsequent pages leaving the
first page 3/4 empty.

The sub-reports's Work Oder Header, Detail, and Work Order Footer's "Keep
Together" properties are all set to "No". The report's detail section's
"Keep Tother" is also set to "No".

How do I get the details to start printing on the first page even if they
subsequently run over to the second and later pages.



It sounds like you have a group in the main or sub report
with its KeepTogether property (in Sorting and Grouping) set
to Whole Group.

--
Marsh
MVP [MS Access]
  #3  
Old April 10th, 2010, 07:19 PM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Printing of sub-report skips to second page.


Marshall,

I checked the following:

Main form
Sort and Group - Keep Together is set to "No"
WorkOrder Header - Keep Together was set to "Yes". I chged it to "No".
Detail section - Keept together set to "No".



In sub-report
Sort and Group - Keep Together are set to "No".
Group Header - Keep Together is set to "No."
Detail section - Keept Together is set to "No".
WorkOrder Footer - Keep Together is set to "No"



Dennis
  #4  
Old April 10th, 2010, 08:50 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Printing of sub-report skips to second page.

Dennis wrote:
Main form
Sort and Group - Keep Together is set to "No"
WorkOrder Header - Keep Together was set to "Yes". I chged it to "No".
Detail section - Keept together set to "No".

In sub-report
Sort and Group - Keep Together are set to "No".
Group Header - Keep Together is set to "No."
Detail section - Keep Together is set to "No".
WorkOrder Footer - Keep Together is set to "No"


The section KeepTogether setting only affects each instance
of the section so that can not be the cause of what you are
seeing. OTOH, setting the group's property to Whole Group
can definitely produce that effect. This would be obvious
if you look at which group header section(s?) appear on the
second page.

Unless you have some VBA code (or a macro) doing something
odd or the report is corrupted, I am out of ideas as to what
else can cause it.

I do have to question why you have both the subreport and
the main report grouping on the same field. The
LinkMaster/Child settings should limit the suberport to the
WorkOrder field so there will only be one work order per
instance of the subreport.

--
Marsh
MVP [MS Access]
  #5  
Old April 11th, 2010, 02:20 AM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Printing of sub-report skips to second page.

Marshall,

Your comment: The section KeepTogether setting only affects each instance
of the section so that can not be the cause of what you are seeing. OTOH,
setting the group's property to Whole Group can definitely produce that
effect. This would be obvious if you look at which group header section(s?)
appear on the second page.

My response: The Work Order group's heading from the sub-report heading is
appearing on the second page. Where do I check for Whole Group? I looked at
the group header section for the Work Order on the sub-report and there is
nothing there under that name. I have the following values for Work Order
Group Header on the sub-report:

Group Header: Yes
Group Footer: Yes
Group On: Each value
Group Interval: 1
Keep Together: No.


Your comment: Unless you have some VBA code (or a macro) doing something
odd or the report is corrupted, I am out of ideas as to what else can cause
it.

Response: I have code to format the customer name and address, suppress the
page footing if only 1 page long, and extracting the value in the OpenArgs.
I dont' do anything with those values yet. That is my next step.

Your comment: I do have to question why you have both the subreport and
the main report grouping on the same field. The LinkMaster/Child settings
should limit the suberport to the WorkOrder field so there will only be one
work order per instance of the subreport.

Response: The LinkMaster / Child setting does limit the sub-report to just
transactions for the work order / invoice. What was happen is I would not
get an invoice column heading / page heading on the second physical page
(first page of sub-report) of the invoice form.

I posted a question asking how to get the column headings to print and I was
told that page heading and page footings do not print in sub-reports. The
way around this was to group on Work Order in the sub-report and have the
Group Heading print on each page by setting the Group Heading property
,Repeat Section set to yes. I did this and it worked.



Dennis
  #6  
Old April 11th, 2010, 09:50 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Printing of sub-report skips to second page.

Dennis wrote:
Your comment: The section KeepTogether setting only affects each instance
of the section so that can not be the cause of what you are seeing. OTOH,
setting the group's property to Whole Group can definitely produce that
effect. This would be obvious if you look at which group header section(s?)
appear on the second page.

My response: The Work Order group's heading from the sub-report heading is
appearing on the second page. Where do I check for Whole Group? I looked at
the group header section for the Work Order on the sub-report and there is
nothing there under that name. I have the following values for Work Order
Group Header on the sub-report:

Group Header: Yes
Group Footer: Yes
Group On: Each value
Group Interval: 1
Keep Together: No.


This is the KeepTogether that I thought would be set to
Whole Group. (They are the group's settings, not the group
header section's settings).


Your comment: Unless you have some VBA code (or a macro) doing something
odd or the report is corrupted, I am out of ideas as to what else can cause
it.

Response: I have code to format the customer name and address, suppress the
page footing if only 1 page long, and extracting the value in the OpenArgs.
I dont' do anything with those values yet.


The kind of thing I was contemplating is a page break
control being made visible or something that fools around
with the ForceNewPage property.


Your comment: I do have to question why you have both the subreport and
the main report grouping on the same field. The LinkMaster/Child settings
should limit the suberport to the WorkOrder field so there will only be one
work order per instance of the subreport.

Response: The LinkMaster / Child setting does limit the sub-report to just
transactions for the work order / invoice. What was happen is I would not
get an invoice column heading / page heading on the second physical page
(first page of sub-report) of the invoice form.

I posted a question asking how to get the column headings to print and I was
told that page heading and page footings do not print in sub-reports. The
way around this was to group on Work Order in the sub-report and have the
Group Heading print on each page by setting the Group Heading property
,Repeat Section set to yes.


Yes, using RepeatSection will do that. I would use the
expresion =1 instead of the linking field, but there's no
reason why in your case it should do anything different.

--
Marsh
MVP [MS Access]
  #7  
Old April 12th, 2010, 03:36 AM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Printing of sub-report skips to second page.

Marshall,

What do you mean by :

My comment: I posted a question asking how to get the column headings to
print and I was told that page heading and page footings do not print in
sub-reports. The way around this was to group on Work Order in the
sub-report and have the Group Heading print on each page by setting the Group
Heading property Repeat Section set to yes.

Your response: Yes, using RepeatSection will do that. I would use the
expresion =1 instead of the linking field, but there's no reason why in your
case it should do anything different.


My question: What do you mean by "I would use the expression =1 instead of
the linking field"



Dennis
  #8  
Old April 12th, 2010, 03:32 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default Printing of sub-report skips to second page.

Dennis wrote:
What do you mean by :

My comment: I posted a question asking how to get the column headings to
print and I was told that page heading and page footings do not print in
sub-reports. The way around this was to group on Work Order in the
sub-report and have the Group Heading print on each page by setting the Group
Heading property Repeat Section set to yes.

Your response: Yes, using RepeatSection will do that. I would use the
expresion =1 instead of the linking field, but there's no reason why in your
case it should do anything different.

My question: What do you mean by "I would use the expression =1 instead of
the linking field"



In Sorting and Grouping, the place where you specify the
grouping field also allows you to use an expression. I
suggested the trivial expression =1, but it can be any
constant expression, eg. ="Dummy page header"

--
Marsh
MVP [MS Access]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.