Skip to Content
0
Former Member
Dec 02, 2008 at 10:29 AM

Group Name based on text

25 Views

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?