I am trying to develop a report which has groupings on it. However, the groups are based on text that i am defining ie. not coming from a database.
ie
"Group 1"
Calculations
"Group 2"
More calculations
etc
However, creating the "Group 1" 's etc as a formula are not presented to me as a Group Name.
I have found a way round it by using sub reports but this seems over the top as each set of calculations only varies by 1 field!
I also tried something like
If GroupNumber =1 Then "Group 1" Else "Group 2"
Anyone any ideas?