I have a report that has a main report and 2 subreports. The main report's one and only group is sorted by specified order. Each of the subreport's groups are sorted in ascending order. However, when the report runs, the subreports group headings are not in ascending order. I don't know what order they're in but it's not correct and I need to get it fixed. Is there some way of achieving this?

I am using Crystal XI (ver. 11.5.12.1838)

Thanks,

Mike

No. But it occurred to me that the field that I'm grouping on is a string and when I displayed the actual code (I was only showing the Description of it), it was indeed in Ascending order for a string.

But, if the codes are numeric, I need them to be in numeric order. The user has the ability to choose any of 40 different code groups some of which will be numeric and some that would be alpha numeric or straight alpha. So I thought about how I could test whether it is a numeric code or an alpha numeric one.

To do that, I created a formula that reads:

If NumericText({CrystalData.Group1})
Then
Val({CrystalData.Group1})
Else
{CrystalData.Group1}

When I test it though it errors on the last line saying "A number is required here." I need it to group no matter what the data type is.

Thanks!