Group sort

[rreddy01]

I have a report which is grouped by manager name, i dont want that to group in alphabetical order instead i want to start with letter B.

Thanks,
rreddy

 

[hilfy]

Create a formula that will pull the relevent data out of the manager name - something like this:

If left({manager name}, 1) > 'A' then 1 else 2

This formula will put all of the managers whose names start with 'A' at the end of the report.

Group by this and hide the group sections. Then group again by manager name to get the names in alphabetical order within the constraints of the outer group.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.