Group sorting

[mnmdesigns]

Hi all,

I am using CR 10. I have two groups in my report.
Group 1: Office (field in the db)
Group 2: Status (formula)

Group 2 formula:
if isnull({field1})and
isnull({field2})and
not isnull({field3})then "Status 1"
if not isnull({field1})and
isnull({field2})and
not isnull({field3})then "Status 2"
else "No Status"
I want to sort my group 2 headers in a specific order.
Here is the desired order Status 2, Status 1, No Status
How can I do this within Crystal Report?

Thanks in advance.

 

[TheBlondOne]

If you right click on grou 2 and go to change group, in there you should see a sort order i.e ascending, descending.

If you drop the list down you should see specified grouping.

If you select that you can create the order of your groups sepcifically to how you want them.

HTH

 

[kskid]

Click on the Group 2 section on hte left of the report canvas and click on Change Group. From the Pop-up menu, just click on the drop down menu and select "specified order" and insert the order you want.

At least, that's how it works in CR 8.5 and CR 11 so it should be the same with CR 10.

-lw

 

[mnmdesigns]

I have tried your suggestion but it is still not showing in the proper(specified) sequence. I think the problem is that Group 1 (office) will not always have cases that have all the Statuses (Group 2).

Is there any thing else that I can try?

Thanks.