summing a text box 2

[demoman]

I apologize in advance, but I cannot remember how to sum a text box. The text box is bound to a column located in a footer section. At the next footer, I want to sum them up

=sum([text1]) - but that does not work
=sum([text1].[value]) - does not work

appreciate the answer

 

[lupins46]

You have to sum the field/calculation that is in text1.
(If text1 contains Qty*Price then your sum control must have =Sum(qty*price))

 

[BobStubbs]

My usual way to do this is:

-- Create an unbound text box in the 'Detail' area of the report. Call this e.g. txtTotal
-- Set the Control Source property for this text box to be:

=[NumericField]

where this is the name of the field containing numeric data which you wish to sum.
-- Set the Running Sum property for this text box to be 'Over All'
-- Once you have tested your report, set the Visible property of this text box to 'False'

-- Now, create a second unbound text box in the page footer or report footer, as required. Call this e.g. txtDisplayTotal
-- Set the Control Source property for this text box to be:

=[txtTotal]

When you run the report, txtDisplayTotal will show you the 'sub total so far' if in the page footer, and the report grand total if in the report footer.

I hope that this helps.

Bob Stubbs

 

[demoman]

Thanks Gents! I basically did what Bob said - although the field is located in the first footer. I only want to count 1 for each break iteration, not each row in the detail. Appreciate the posts. Most of our reporting is now done in crystal, so i am forgetting some of the legacy stuff.