expressions?
Hi
Me again!
I am now trying to add up values in different fields, for each row, like a calculated field. I have tried adding an object with:
sum([qryP1b."MARK"]+[qryp1a."MARK"]+[qryTotals."CAST"]
at the end of the row in the master data band but what I see in my report is: sum(3+4+2) where the numbers are the values from the fields.
what do I need to do in order to get 9?
Thanks again for the help
Pete
Me again!
I am now trying to add up values in different fields, for each row, like a calculated field. I have tried adding an object with:
sum([qryP1b."MARK"]+[qryp1a."MARK"]+[qryTotals."CAST"]
at the end of the row in the master data band but what I see in my report is: sum(3+4+2) where the numbers are the values from the fields.
what do I need to do in order to get 9?
Thanks again for the help
Pete
Comments
dont use sum function it is used for adding values in footers of rows above, and is usually used with extended syntax
[Sum([v or dfldnme],bandname,1)]
band name is the name of the databand as shown in object inspector.
1 is optional if used it picks up non visible values.
just add [] around the whole expression
qryP1b."MARK"] + [qryp1a."MARK"] + [qryTotals."CAST"
BTW if you are trying to get rowtotals in a memo located on a cross footer intersecting a mdband you may have to use Sum function like the basic crossdemo
[Sum([Cell])]