Sorting/Grouping 2

[jtracy]

I could really use some help.

My problem is that I have a report that is being grouped on a field called ClaimNum, but I do not want to sort on ClaimNum. I have several other fields I need to sort on. Can you please help me?

Jessi

 

[dgillz]

Jtracy-

If you want to group on ClaimNum, you are going to have to sort by it first. Otherwise, data associated with ClaimNum could be all over your report.

If you want to have secondary, tertiary, etc., etc. sorts on the data you can do this using the sort expert. Maybe you could provide some more details?

Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine
Cell/VM: 714-348-0964

 

[HowardHammerman]

In Crystal, grouping always comes before sorting. You might want to check out R&R Report Writer that does not have this requirement. You could group on another field, state for example, and then sort on claim number within state. When you create a group in Crystal, the program automatically creates a group header and a group footer section. You can suppress these sections if you don't need them, then your report will have the appearance of being sorted but not grouped.
Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Dan01]

How do you put a sort ahead of a group? Thanks, Dan.

 

[Dan01]

I have a group (text, length 6) that is incorrectly sorting. 200204, for example sorts in front of 200111. I'd like to presort the group to force it to behave as such, 200101, 200102, 200103, etc. Any suggestions? Thanks, Dan.

 

[HowardHammerman]

That is wierd. Maybe there is a space before the
number. Try this:

Create a formula field with the following expression:

TrimLeft ({table.field})

then use the sort icon to sort on that formual field.
Remove any other field in the sort window except your
group fields.

see if that works. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Ngolem]

I don't think you have described your problem very well.

Show us an example of how you want the report to look. If you don't want to sort by ClaimNum...why group on it at all??? Or are you redesigning an existing report for something else? Jim Broadbent