Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can I total a value in a textbox? Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 1:14 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 267, Visits: 424
Hi

I have a matix report which by person by day of month display a value depnding on a condition

something like
1 2 3 .... 31 total
Jim Smith a b 2 <-is textbox9 is a formual to total

etc..

I want to get the sum the total for all clients
cant I somehow sum textbox9 the formula for the total

Thanks in Advance
Joe
Post #1494329
Posted Friday, September 13, 2013 6:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
I am not clear on exactly what you are trying to do but have you tried using ReportItems to gather your values for the total?
Post #1494565
Posted Friday, September 13, 2013 7:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 267, Visits: 424
Thanks for getting back

I tried ..=sum(reportitems!Textbox9.Value)

but getting the error Aggregate functions can be used only on report items contained in page headers and footers

Post #1494577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse