Group Sort Expert or Specified Group Help plz!

[sara07]

Hello, I am trying to sort my group TOUR by this:

There are some tour names with the text called 'Extension'
For example: Hawaii Extensions. And other tour names would be without word Extension.

How can I get all of my groups without the word Extension to show up first in sorted ascending order and then groups with text Extension to show on the BOTTOM of the report after "Non extension words". I cant figure this out! I tried to right click on group and change group and then specified group - created a specified group name - where tour is like Extension and tour is not like extension. But with this it eliminates some data.
It is not working. please help

 

[dgillz]

Create a formula:

If instr({YourField},"extensions")>0 then "ZZZ"&{YourField} else {YourField}.

Group by this field rather that the current field you are using. This will get all the extensions at the bottom, but will unfortunately show the "ZZZ" in the group name.

If this is a problem, customize the group name field with a formula:

If left({@YourFormula},3)= "ZZZ") then mid({@YourFormula},4) else {@YourFormula}


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

You could create a formula:

if instr({table.name},"Extension") > 0 then 2 else 1

Group on this and suppress the group header. Insert a second group on {table.name} to get the order ascending within groups.

-LB