subreports

[#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
*****************************************

 

[burg]

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

 

[#1spongebobfan via AccessMonster.com]

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
*****************************************

 

[Duane Hookom]

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
--

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.

 

[#1spongebobfan via AccessMonster.com]

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
*****************************************

 

[#1spongebobfan via AccessMonster.com]

Some how I got it to work! Not sure how. I changed a few properties and don't have a Link Child Fields. THANK YOU!!!

*****************************************
* 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=3bd3c7f6b13a4709b7d0dcd09d80b3c8
*****************************************

 

[Duane Hookom]

It sounds like you need to remove the Link Master/Child property values.

--
Duane Hookom
MS Access MVP
--

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.