Sorting a Hierarchical Group in specific Order

[PD81]

This may be v simple but I am finding it hard to diplay.
My report displays the parent-child capabilities in Hierarchical order.
I need to change the sorting of 2nd group that is first child in specific order.
2nd group


1 =if {Capabilities_1.Name} like ""*(Set Up)"
2 =if {Capabilities_1.Name} like "*(Daily)"
3 =if {Capabilities_1.Name} like "*(Period End)


It should display the capabilities which has word "setup" as first then " daily" as 2nd in the list and anything which is ending with word "Period end" should be last.

ind 3rd and 4th group should display the child item of their parent.

I don't know how to put the above sort formula.
Please help me on this.

-cheers
Puneet

 

[IanWaterman]

YOu could create a sort formula

@sort

if {Capabilities_1.Name} like ""*(Set Up)" then 1 else
if {Capabilities_1.Name} like "*(Daily)" then 2 else
if {Capabilities_1.Name} like "*(Period End) then 3
else 4

Then sort on that formula

Remember Grouping takes precedence over sort so this will only take effect within your highest group number.

Ian