display footer of subreport on main report
Experts,
I am very inexperienced with Access reporting. I am hoping you may be able to assist. I have created two reports and put them on a single main report. For now everthing presented okay. The second report has a footer which consists of 3 labels which are a "key" that explains the target numbers.
I'll elaborate.....
In Rpt #2, I just have the following lines:...
Diabetecs meeting HbA1c target 92%
Diabetecs not meeting LDL target 7%
But in the footer (**the Key)**, I have 3 static labels...
Target:
HbA1c targer: <= 7.0
LDL targer : <= 100
This footer doesn't display when I combine report # 1 with this report #2.
My work around was just put this footer on the main report. Which worked fine.
But....
We need to add a third sub-report to this report. So this will cause the data in the thrid reoprt to be in the middle of the second report and the footer.
The business owner wants what was considered the footer (those three descrptive labes to appear directly before the data in the thrid report displays.
I cant figure out how to do that? I am a novice to Access.. And this solution must be in Access to accomodate the Business owners.
ANy assistance would be greatly apprreciated.
I am very inexperienced with Access reporting. I am hoping you may be able to assist. I have created two reports and put them on a single main report. For now everthing presented okay. The second report has a footer which consists of 3 labels which are a "key" that explains the target numbers.
I'll elaborate.....
In Rpt #2, I just have the following lines:...
Diabetecs meeting HbA1c target 92%
Diabetecs not meeting LDL target 7%
But in the footer (**the Key)**, I have 3 static labels...
Target:
HbA1c targer: <= 7.0
LDL targer : <= 100
This footer doesn't display when I combine report # 1 with this report #2.
My work around was just put this footer on the main report. Which worked fine.
But....
We need to add a third sub-report to this report. So this will cause the data in the thrid reoprt to be in the middle of the second report and the footer.
The business owner wants what was considered the footer (those three descrptive labes to appear directly before the data in the thrid report displays.
I cant figure out how to do that? I am a novice to Access.. And this solution must be in Access to accomodate the Business owners.
ANy assistance would be greatly apprreciated.
In design mode of the report you want you want your information to be displayed ass a label (if you don't already have one). Let's say it is named lblMyLabel;
- bring up property sheet,
- click on the report footer (in design mode of course) in question.
- In property sheet select events.
- double click in the OnFormat event and click [...] button to the left of OnFormat event cell to access code window.
- Under Private Sub OnFormat() and before End Sub entter:
Me!lblMyLabel.Caption="Inf
After you doe this, we will capture the information you want got to this label. This step one of two steps.
Mike
- bring up property sheet,
- click on the report footer (in design mode of course) in question.
- In property sheet select events.
- double click in the OnFormat event and click [...] button to the left of OnFormat event cell to access code window.
- Under Private Sub OnFormat() and before End Sub entter:
Me!lblMyLabel.Caption="Inf
After you doe this, we will capture the information you want got to this label. This step one of two steps.
Mike
Can you post a sample of the DB you have so far, (with eghtebas' mods)?
...not sure I understand what else is needed
Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
(Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.
In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
JeffCoachman
...not sure I understand what else is needed
Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
(Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.
In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
JeffCoachman
Premium Content
You need an Expert Office subscription to comment.Start Free Trial