 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / May 2007Sub Report Totals
I have a report that when added to the main report as a sub report, I get one extra count in my total. So the report totals correctly by itself but when used as a sub report I get one extra count. It would help if you told us how the count was calculated. Is it a text box with a control source like: =Count(*)  SignatureDuane Hookom Microsoft Access MVP > I have a report that when added to the main report as a sub report, I get one > extra count in my total. So the report totals correctly by itself but when > used as a sub report I get one extra count. With in the details section of the report I have a number of text boxes that have Iif statements in them that are set to calculate the totals. Then in the footer section I reffer to those text boxes =[txtTotalDI] to display the totals. > It would help if you told us how the count was calculated. Is it a text box > with a control source like: [quoted text clipped - 3 lines] > > extra count in my total. So the report totals correctly by itself but when > > used as a sub report I get one extra count. I would use an expression that only references fields and calculations from the report's record source, not values of controls from other sections of the report. SignatureDuane Hookom Microsoft Access MVP > With in the details section of the report I have a number of text boxes that > have Iif statements in them that are set to calculate the totals. Then in the [quoted text clipped - 8 lines] > > > extra count in my total. So the report totals correctly by itself but when > > > used as a sub report I get one extra count. Well my Iff statements references the query that the report uses, to get it's totals. If that is what you mean. Again the report works fine until you put it in the main report. Then their is only one "total" that has one extra value. > I would use an expression that only references fields and calculations from > the report's record source, not values of controls from other sections of the [quoted text clipped - 12 lines] > > > > extra count in my total. So the report totals correctly by itself but when > > > > used as a sub report I get one extra count. Your IIf() statements in one section refer to fields but you also stated "Then in the footer section I reffer to those text boxes". I would search for a method that doesn't reference "controls" from other sections. SignatureDuane Hookom Microsoft Access MVP > Well my Iff statements references the query that the report uses, to get it's > totals. If that is what you mean. Again the report works fine until you put [quoted text clipped - 17 lines] > > > > > extra count in my total. So the report totals correctly by itself but when > > > > > used as a sub report I get one extra count. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.