Espinoza84
Registered User.
- Local time
- Yesterday, 21:31
- Joined
- May 30, 2008
- Messages
- 55
Hi all, I am trying to design a report with various subreports, but having issues.
Can someone please look at the database I am attaching and help me fix my mistakes.
Ideally, the first subreport (SOCCER) should display once, and together. The 2nd subreport (FOOTBALL) should display once and together. SOCCER subrep coming first before the football subrep does not entirely matter (order does not matter).
At the moment, I do get the reports displaying separately but they seem to be duplicating or just printing out more records than it should.
I can fix the duplicating/extra-records by removing APPLICATION from my master query "Qry Manager_app_User" but if I do that, i lose the sorting by application. Thus, in the display of my report, it no longer is separated by subreports (application).
Also, I have no idea why I can not add as my link between master/child for each of my subreports "MAN_EMAIL; APPLICATION" for some reason whnever I add APPLICATION to my links between master/child nothing displays? I cant figure out why.
Also, my second subreport FOOTBALL, it is not displaying how i wish it to display, I would like for it to be in a 'list' format, meaning after part in the header displays (ONCE), underneath it should just list all the names not have to repeat the part in the header over and over for each person. Also, cant figure out how to fix this.
Im a bit of a rookie at report making so I am uploading my db, for someone to be kind enough to help me, thank you.
Can someone please look at the database I am attaching and help me fix my mistakes.
Ideally, the first subreport (SOCCER) should display once, and together. The 2nd subreport (FOOTBALL) should display once and together. SOCCER subrep coming first before the football subrep does not entirely matter (order does not matter).
At the moment, I do get the reports displaying separately but they seem to be duplicating or just printing out more records than it should.
I can fix the duplicating/extra-records by removing APPLICATION from my master query "Qry Manager_app_User" but if I do that, i lose the sorting by application. Thus, in the display of my report, it no longer is separated by subreports (application).
Also, I have no idea why I can not add as my link between master/child for each of my subreports "MAN_EMAIL; APPLICATION" for some reason whnever I add APPLICATION to my links between master/child nothing displays? I cant figure out why.
Also, my second subreport FOOTBALL, it is not displaying how i wish it to display, I would like for it to be in a 'list' format, meaning after part in the header displays (ONCE), underneath it should just list all the names not have to repeat the part in the header over and over for each person. Also, cant figure out how to fix this.
Im a bit of a rookie at report making so I am uploading my db, for someone to be kind enough to help me, thank you.
