Forum Discussion
Solved
Repeat report section
Hello All,
I need some help in creating a report in certain way. Below is the relationship of the three tables (ignore the other lines). There is one risk and this risk is having 2 actions and 3 scores (the score gets updated every meeting for example)
As you can see the report below, it is repeating the risk actions block (highlighted in blue) two times and each time is showing the score block (highlighted in red).
What I want is to have the risk details block (highlighted in black) in the top without repeating and under it is the action block with all the actions for that risk and then under it is the score block (and every update on the score will be in the bottom).
This is the report design layout.
Forgive me for my bad English, and I hope my request is clear.
Thank you in advance!
Hi,
How about subreports (linked to the main report via the Risk_Id field) where you display the Response and Assessment records. This would allow you to control the placement and order in the report as desired.
Probably 1 subreport is enough, but you could also use subreports for both detail tables.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
- Not your current problem, but you should also ENFORCE the relations on the diagram.
Double-click a line, and in the dialog that comes up, check "Enforce Referential Integrity".
Only after that can you call your database a relational database, instead of a bag of data 🙂 Hi,
How about subreports (linked to the main report via the Risk_Id field) where you display the Response and Assessment records. This would allow you to control the placement and order in the report as desired.
Probably 1 subreport is enough, but you could also use subreports for both detail tables.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK
