Davisro
asked on
Access Subreport obscuring main report in Print Preview
Experts...
I had an Access report that worked fine. I was asked to embed a sub report into the main report to include more information. In Access the Report/sub report looks fine, but when I view the report in Print Preview mode, I see a multi-page report where
-the main report header section displays fine, but the remainder of the main report is covered by the subreport on page 1
-in the remaining pages, the subreport is fixed and takes up all the real estate of the page, while the main report scrolls in only the top inch of the page. So
Page 1 = Header and subreport
Page 2 = 1st inch of main report at the top + fixed subreport
Page 3 = 2nd inch of main report at the top + fixed subreport
etc
The parent report can scroll, but only in the top inch that displays the header!
So what am I doing wrong? I know this must have something to do with my subreport being in the Page Footer section of the main report
I had an Access report that worked fine. I was asked to embed a sub report into the main report to include more information. In Access the Report/sub report looks fine, but when I view the report in Print Preview mode, I see a multi-page report where
-the main report header section displays fine, but the remainder of the main report is covered by the subreport on page 1
-in the remaining pages, the subreport is fixed and takes up all the real estate of the page, while the main report scrolls in only the top inch of the page. So
Page 1 = Header and subreport
Page 2 = 1st inch of main report at the top + fixed subreport
Page 3 = 2nd inch of main report at the top + fixed subreport
etc
The parent report can scroll, but only in the top inch that displays the header!
So what am I doing wrong? I know this must have something to do with my subreport being in the Page Footer section of the main report
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I got it to work by putting the report header information in the page header section.
ASKER
The report is a Project Manager Details report showing consultants that report to them, position numbers, dates of employment, project consultant is working on. The sub report has financial information relating to their consultants: PO Numbers, PO Funding, Hourly Rate, projected burn of PO funding
The report is generated when my user selects the manager name from a Summary report (showing all managers (left col) and a count of consultants (data) at different status' (top header)) and the On click event in the manager name field opens and filters this detail report...the Data Source is a query with all manager data
My latest attempt: I moved the sub report to the Group Footer (grouped by Manager Name)
Current Layout:
Report Header - Report Title, Manager Name, =Date(), and Cmd Button to trigger code to attach report to an email as a PDF attachement
Page Header - blank
Group Header (on Manager Name) - has labels for detail fields
Detail Section - query fields
Group Footer - Count of detail records, and subreport below that
Page Footer - blank
Report Footer - blank
This arrangement works better, but when the Main Report is long enough, it pushes the subreport to a second page, and second page has the subreport only with no report header. Still playing with it...
Why doesn't the report header show on both pages?