Is it possible to group a report based on expressions in unbound text boxes?
I have dynamic report based on a crosstab query. Since the date ranges can change, the report control source is assigned via VBA as are the column labels and textbox control sources.
EE ID AVG FTE Month 1 Month 2 Month 3 etc.... Status
999 1.0 1.0 1.0 1.0 FT
555 .64 .73 .46 .73 PT
AVG FTE is a calculated unbound textbox averaging the months across the row
STATUS is a calculated unbound textbox: if AVG FTE <1, PT, FT
I would like to group the report on Status. However, I am unable to refer to this unbound txtbox the expressions.
Can anyone offer any suggestions?
Thank you!
I have dynamic report based on a crosstab query. Since the date ranges can change, the report control source is assigned via VBA as are the column labels and textbox control sources.
EE ID AVG FTE Month 1 Month 2 Month 3 etc.... Status
999 1.0 1.0 1.0 1.0 FT
555 .64 .73 .46 .73 PT
AVG FTE is a calculated unbound textbox averaging the months across the row
STATUS is a calculated unbound textbox: if AVG FTE <1, PT, FT
I would like to group the report on Status. However, I am unable to refer to this unbound txtbox the expressions.
Can anyone offer any suggestions?
Thank you!
