>Good day everyone,
>I need some help with the syntax for a report please.
>The end of my report has a few calculated fields of the sum of each field of the report. I would like to then sum those fields together for a grand total on the same end page but I am unsure as to how I need to go about it.
>I get an "Syntax Error" when I try the following code as the expression for field on the report:
>SUM(table.field1,table.field2,table.field3)
>I have the "Calculate field" set to SUM at "End of Report".
>
>Thank you!
>Max
You will have to create a variable in your report, called GrandTotal. In this variable you should put Field1+Field2+Field3 in the expression and check SUM on Calculation. Put this variable in the field expression at the summary section of your report.
Also don't use Table prefix, otherwise you can run this report only for specific table.
If it's not broken, fix it until it is.
My Blog