Sort order different than the grouping 2

[govinr2002]

Hi, is there a way in crystal reports XI to have a sort order on a column that is not in any of the groupings

For ex: the report is grouped by 2 columns field1 and field2, but I want the report to be sorted by another column field3. is this doable or is there any workaround ?
any help is greatly appreciated.

 

[lbass]

Groups always take precedence over fields for sorting. That means you either have to iinsert a group on field3 and then make that group your group #1, or you have to insert a summary on field3 at the Group #1 level and then do a group sort on the summary. It would help if you provided samples of your fields.

-LB

 

[govinr2002]

Thanks lbass for your reply. Here is the description of the fields. Field1 and Field2 are the names of manager and salesmen , in the report I'm trying to get the number of orders secured for the manager, salesman combination for all the months and so I'm grouping by manager, salesman.
The report also has to print the order totals for the manager. so far so good.
field3 is a unique sequence number assigned to the manager, salesman combination, the report needs to be sorted by field3.

If I have the groupings as field3, field1, and field2 then when I print the totals for the manager(field2) then the totals appear after every record because field3 is a sequence number. hope I'm making sense !

 

[Madawc]

If you want the records grouped one way but the totals grouped another way, a Crosstab in the report footer might be the answer.

When Crosstabs won't work, a mock-crosstab can be used. But I'd have thought your case should be fine for a standard crosstab.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[GJParker]

Add a minimum summary at the manager (group 1) level for Field 3.

Then in the group sort expert you can use this summary to order Group 1 as you require.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lbass]

Yes, try what Gary suggested, which was also the second suggestion in my first post. Should work.

-LB

 

[govinr2002]

worked like a charm !!! Thanks lbass and Gary

 

[govinr2002]

As a follow-up to my above question, I have the manager's name and the salesman name in the group footer along with the monthly totals

Ex:
Jan Feb Mar ....

Manager1 salesman1 10 20 30
Manager1 Salesman2 05 20 18
Manager1 Salesman3 09 08 12

Manager1 Totals 24 48 60

The manager1 totals are in group1(manager) footer and the first 3 lines displayed above are in the group2(salesman) footer. how can I suppress the duplicate manager name, basically I want the report to look like this..

Jan Feb Mar ....

Manager1 salesman1 10 20 30
Salesman2 05 20 18
Salesman3 09 08 12

Manager1 Totals 24 48 60

Thanks

 

[lbass]

If you are suppressing your detail section, you could place the Manager 1 field in the group header for Group #1 and then in the section expert, format it to underlay following sections.

-LB

 

[govinr2002]

LB, the detail section is suppressed but if I place the Manager1 field in the group1 header and "underlay following sections " I get just the summary rows, am I missing something here ?

 

[lbass]

I don't know what you mean. You should see your group #2 summaries with the group #1 field to the left of the first summary row, and then the group #1 summaries at the bottom.

-LB