Printing of sub-report skips to second page.

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

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.
 
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
 
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
 
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
 
Back
Top