Using Crystal Reports Developer 11.0.0.1282
I'm looking for a function or formula so that a formula field can tell what group or section it is in.
For example, if I have a report that is grouped by Country -> Region -> City
When I drill down, I have the next level's data, then the previous levels total, i.e.:
(DrillDownGroupLevel 1)
Country1
Region1 Total FieldX
Region2 Total FieldX
Region3 Total FieldX
Country1 CountryTotals
then drill down on Region1, and get
(DrillDownGroupLevel 2)
Region1
City1 Value
City2 Value
City3 Value
Region1 Total FieldX
What I want is function or formula to put in FieldX so that FieldX knows that it is in the Region group/section. DrillDownGroupLevel doesn't work because FieldX stays in the Region group section whether I'm in DrillDownGroupLevel 1 or 2.
Something that will return "Group Footer 4" or "Group Header 2" or something would be perfect, I just can't find it.
Note: The built in "GroupNumber" function doesn't work for my needs, as it just counts up the # of groups that have been encountered