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 @ 2:00 PM
Points: 295, Visits: 488
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: Yesterday @ 9:41 AM
Points: 2,818, Visits: 2,552
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 @ 2:00 PM
Points: 295, Visits: 488
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