[RESOLVED] Crystal Group Name

[Foxy69]

In Crystal XI is there any way I can test what field a particular group is using.

If you imagine a sales order I have report that can print the details in one of 3 seqeuences, line number, part number or bin number. If the report is printed in Bin sequence I need to create a formula to print some text. (The grouping is driven by a VB.Net app).

i.e.

if group field 1 = {salesorder.bin} then "message text" else ""

Hope it makes sense!

[Foxy69]

Cracked it!

if GroupingLevel ({salesorder.bin})=1 then "Warehouse Copy" else ""

Groupinglevel returns the group level of the field supplied, in the other sequences it returns 0 as its not a group by field.