subreports

  • Thread starter Thread starter #1spongebobfan via AccessMonster.com
  • Start date Start date
1

#1spongebobfan via AccessMonster.com

I have created two reports in my database that retrieve data based on a date range and complaint codes (1-6) on a form that opens when the main report is opened. The main report is "Critical Issues Details" and the second report is "Critical Issues Summary" that shows total complaints per complaint code, ie.: Billing = 6. My problem is I can't see all the data on the "Critical Issues Summary" when I make it a sub report, and am not sure which band to place the sub report into on the main report? I think this may be why I can't see all the data. I chose the date to be the childlinkfield. Would this be correct? Thanks so much in advance for your assistance.

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=6005018723494d698b351ae53e451d34
*****************************************
 
Hi,

Can't you create one query to run the report from and then use the access
wizard to make a report. When you make the report you can set a grouping
level. It will then show the critical issue detail on the left and the
critical issues summary on the right of that?

Sorry if i don't get what you mean.

Thanks
 
Not sure I know what you are saying. I want the sub report to be the summary of the entire detail report:

Billing 5
Benefits 4
Claim Quality 3

And I want the sub report to be at the end of the details report. I think I am making this harder than I need to but can't seem to put it together!?!?!? Thanks for your help.

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-reports/13597
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=7253b6591f14422f8a222fce8692ba86
*****************************************
 
You don't need to set a link master child unless you actually want to filter
the subreport based on a value in the main report. If you want only one
occurance of the subreport, place it in the report footer section.

--
Duane Hookom
MS Access MVP
--

#1spongebobfan via AccessMonster.com said:
Not sure I know what you are saying. I want the sub report to be the
Click to expand...
summary of the entire detail report:
Billing 5
Benefits 4
Claim Quality 3

And I want the sub report to be at the end of the details report. I think
Click to expand...
I am making this harder than I need to but can't seem to put it
together!?!?!? Thanks for your help.
 
When I view the report the subreport only shows summary information for the last grouping on the main report. It isn't catching all the summary information. Thanks.

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-reports/13597
*
* Report SPAM or ABUSE by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=10dd1be3d2c54c4d8a0429f0469a5e67
*****************************************
 
It sounds like you need to remove the Link Master/Child property values.

--
Duane Hookom
MS Access MVP
--

#1spongebobfan via AccessMonster.com said:
When I view the report the subreport only shows summary information for
Click to expand...
the last grouping on the main report. It isn't catching all the summary
information. Thanks.
 
Back
Top