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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|