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

I do not really understand your question.

Edited by DBlank - 17 May 2010 at 6:45am

drilldowngrouplevel "works" even if you do are not using group suppression in the section expert. It simply is a value associated with the number of levels that you have drilled into the report.

it is zero until you drill into a group (even though it is not suppressed you can still drill into it). Think of drilldowngrouplevel more as report layers than groups.