Grand totals in reports
in [Reports]
|
Prev: Grouping
Next: Incorrect printout of report
From: Jerry Anderson on 2 Jul 2008 16:57 I have a report, which correctly displays the total of the items in it. This report has a subreport, which also correctly totals the items. How do I get a grand total of both the main and sub reports to print?
From: Allen Browne on 2 Jul 2008 23:14 This is a 2-step process: a) Get the subreport totals back onto the main report. See: Bring the total from a subreport onto a main report at: http://allenbrowne.com/casu-18.html b) Use a running sum to collect the totals throughout the report. Set the Running Sum property of this text box to Over All. You probably want to set Visible to No, so you don't see the accumulating total on the main report. Now in the Report Footer section, add a text box to show the accumulated total. Its Control Source will be: =[txt1] where txt1 represents the name of the hidden text box that accumulates the totals. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jerry Anderson" <JerryAnderson(a)discussions.microsoft.com> wrote in message news:03EE0FDE-1F9D-4202-A895-4F286257148D(a)microsoft.com... >I have a report, which correctly displays the total of the items in it. > This report has a subreport, which also correctly totals the items. > How do I get a grand total of both the main and sub reports to print?
From: Robbie Doo on 10 Jul 2008 10:45 Allen, I followed your advice but all I'm getting are 0's for the totals. My control source is something like this on the main form's Report Footer section: =subreport.report.text16 Any other suggestions? "Allen Browne" wrote: > This is a 2-step process: > > a) Get the subreport totals back onto the main report. See: > Bring the total from a subreport onto a main report > at: > http://allenbrowne.com/casu-18.html > > b) Use a running sum to collect the totals throughout the report. > Set the Running Sum property of this text box to Over All. > You probably want to set Visible to No, so you don't see the accumulating > total on the main report. > > Now in the Report Footer section, add a text box to show the accumulated > total. Its Control Source will be: > =[txt1] > where txt1 represents the name of the hidden text box that accumulates the > totals. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > "Jerry Anderson" <JerryAnderson(a)discussions.microsoft.com> wrote in message > news:03EE0FDE-1F9D-4202-A895-4F286257148D(a)microsoft.com... > >I have a report, which correctly displays the total of the items in it. > > This report has a subreport, which also correctly totals the items. > > How do I get a grand total of both the main and sub reports to print? > >
From: Allen Browne on 10 Jul 2008 11:01 Looks like you have not used the HasData and Nz() suggested in the article. As stated, this is a 2-stage problem. First you need to get the totals returning correctly. You can then get the running sum working. One step at a time. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Robbie Doo" <RobbieDoo(a)discussions.microsoft.com> wrote in message news:AFCA8438-69A7-4D44-8A22-A55FEFCD41CB(a)microsoft.com... > Allen, I followed your advice but all I'm getting are 0's for the totals. > My control source is something like this on the main form's Report Footer > section: > > =subreport.report.text16 > > Any other suggestions? > > "Allen Browne" wrote: > >> This is a 2-step process: >> >> a) Get the subreport totals back onto the main report. See: >> Bring the total from a subreport onto a main report >> at: >> http://allenbrowne.com/casu-18.html >> >> b) Use a running sum to collect the totals throughout the report. >> Set the Running Sum property of this text box to Over All. >> You probably want to set Visible to No, so you don't see the accumulating >> total on the main report. >> >> Now in the Report Footer section, add a text box to show the accumulated >> total. Its Control Source will be: >> =[txt1] >> where txt1 represents the name of the hidden text box that accumulates >> the >> totals. >> >> "Jerry Anderson" <JerryAnderson(a)discussions.microsoft.com> wrote in >> message >> news:03EE0FDE-1F9D-4202-A895-4F286257148D(a)microsoft.com... >> >I have a report, which correctly displays the total of the items in it. >> > This report has a subreport, which also correctly totals the items. >> > How do I get a grand total of both the main and sub reports to print?
From: Robbie Doo on 10 Jul 2008 11:13
I think the problem is my master/child linkage between the Main and Sub Reports. When I change the linkage the report gets distorted. I just don't know how to resolve the linkage problem without messing up my report. "Allen Browne" wrote: > Looks like you have not used the HasData and Nz() suggested in the article. > > As stated, this is a 2-stage problem. First you need to get the totals > returning correctly. You can then get the running sum working. One step at a > time. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > "Robbie Doo" <RobbieDoo(a)discussions.microsoft.com> wrote in message > news:AFCA8438-69A7-4D44-8A22-A55FEFCD41CB(a)microsoft.com... > > Allen, I followed your advice but all I'm getting are 0's for the totals. > > My control source is something like this on the main form's Report Footer > > section: > > > > =subreport.report.text16 > > > > Any other suggestions? > > > > "Allen Browne" wrote: > > > >> This is a 2-step process: > >> > >> a) Get the subreport totals back onto the main report. See: > >> Bring the total from a subreport onto a main report > >> at: > >> http://allenbrowne.com/casu-18.html > >> > >> b) Use a running sum to collect the totals throughout the report. > >> Set the Running Sum property of this text box to Over All. > >> You probably want to set Visible to No, so you don't see the accumulating > >> total on the main report. > >> > >> Now in the Report Footer section, add a text box to show the accumulated > >> total. Its Control Source will be: > >> =[txt1] > >> where txt1 represents the name of the hidden text box that accumulates > >> the > >> totals. > >> > >> "Jerry Anderson" <JerryAnderson(a)discussions.microsoft.com> wrote in > >> message > >> news:03EE0FDE-1F9D-4202-A895-4F286257148D(a)microsoft.com... > >> >I have a report, which correctly displays the total of the items in it. > >> > This report has a subreport, which also correctly totals the items. > >> > How do I get a grand total of both the main and sub reports to print? > > |