By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,661 Members | 1,319 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,661 IT Pros & Developers. It's quick & easy.

How to find grand total for subreport field

P: 66
In my Database 1 of the Report i need to find the grand total for a field which is inherited from the 1 of the subform..

Ex-The report field control source property is set to as

=[Copy of WIP Form]!Text1693

where Copy of WIP Form is a subform on the main Report..

I need to find/display the grand total for this field.

Can any one Plz help me as to how to find the grand total for such a field.
Aug 31 '10 #1
Share this Question
Share on Google+
4 Replies


Jerry Maiapu
100+
P: 259
Hi, try these two options:

A: Find the total within the subform first then display that in the report.

At the form footer of the subform, create a text box called txtgtotal and calculate the total:
Expand|Select|Wrap|Line Numbers
  1. =Sum(Text1693)
Now, in the Report simply access the GrandTotal :
Expand|Select|Wrap|Line Numbers
  1. =[Copy of WIP Form]!txtgtotal 
.................................................. .......


B: Or alternatively,in the report if the text box name of
Expand|Select|Wrap|Line Numbers
  1. =[Copy of WIP Form]!Text1693
is txtdisplay, then

In the Report footer
Expand|Select|Wrap|Line Numbers
  1. =Sum(txtdisplay)
Aug 31 '10 #2

P: 34
I'm sorry but I'm a little confused... Are you trying to total the totals on several different forms generated by a form in and of themselves?
Aug 31 '10 #3

P: 66
There is only 1 form Copy of WIP ,contains 1 field as "RM"..This form is inserted as subform in the Main Report..In this Report need to display the grand total..but the
Expand|Select|Wrap|Line Numbers
  1. Sum(txtdisplay) 
  2.  
gives an error..
Sep 1 '10 #4

P: 34
So all the numbers you need totaled are on the Report then. Could you give me the names of all the fields you are trying to total, and maybe a screen-shot of the report and form (if there is no sensitive info showing in the report/form)?
Sep 1 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.