I do various reporting for our products for various managers.
I have designed a report for one of them with unit sales, $ sales,
variances, etc for this year vs last year. Now he wants to be able
to specify a quarter and get the report based on that quarter.
The fields from our tables have names like tjan, tfeb, tmar, ....
and a calculated field in the database tttl (the total).
Where I was placing the tttl field in the report I designed
calculated fields in the report like:
q1tynum defined as Tjan+Tfeb+Tmar (1 for each quarter)
then I defined another calculated field to determine which calculated
field to display:
wqtynum defined as case(Var->Quarter=1,Calc->Q1tynum,
Var->Quarter=2,Calc->Q2tynum,
Var->Quarter=3,Calc->Q3tynum,
Var->Quarter=4,Calc->Q4tynum)
where var->quarter (global) is determined on the calling form.
All is well so far,the correct quantities print in the detail section, but when I take that wqtynum field and place it in a group footer and specify "total" I get an error message at report print time:
"invalid summary field expression".
Am I trying to "nest" too many calculations for Alpha to handle? Is the order in
which Alpha evaluates calculated fields causing my problem? Would I be better off
placing the "q#tynum" fields and their group totals in conditional objects on the
report and choose the object to display based on the var->quarter?
Any suggestions?
I have designed a report for one of them with unit sales, $ sales,
variances, etc for this year vs last year. Now he wants to be able
to specify a quarter and get the report based on that quarter.
The fields from our tables have names like tjan, tfeb, tmar, ....
and a calculated field in the database tttl (the total).
Where I was placing the tttl field in the report I designed
calculated fields in the report like:
q1tynum defined as Tjan+Tfeb+Tmar (1 for each quarter)
then I defined another calculated field to determine which calculated
field to display:
wqtynum defined as case(Var->Quarter=1,Calc->Q1tynum,
Var->Quarter=2,Calc->Q2tynum,
Var->Quarter=3,Calc->Q3tynum,
Var->Quarter=4,Calc->Q4tynum)
where var->quarter (global) is determined on the calling form.
All is well so far,the correct quantities print in the detail section, but when I take that wqtynum field and place it in a group footer and specify "total" I get an error message at report print time:
"invalid summary field expression".
Am I trying to "nest" too many calculations for Alpha to handle? Is the order in
which Alpha evaluates calculated fields causing my problem? Would I be better off
placing the "q#tynum" fields and their group totals in conditional objects on the
report and choose the object to display based on the var->quarter?
Any suggestions?
Comment