Group Sort Expert does not always work ... why? 1

[nhtennispro]

I am trying to do a Top Ten report with totals of just the 10 records not the entire recordset.

However when I attempt to do it the GROUP SORT EXPERT does not become enabled.

When I look at some of my other reports that has the GROUP SORT EXPERT enabled. When I deleted the group, then reinserted it the GROUP SORT EXPERT did not become enabled.

What are the requirement to have the GROUP SORT EXPERT enabled?

Thanks

 

[lbass]

You must have inserted a summary at the group level.

-LB

 

[nhtennispro]

Actually no. On the report that I have a GROUP SORT EXPERT enabled I have summaries on a number of fields. When I delete the group (and the summarized fields) and reinsert the group the GROUP SORT EXPERT is then disabled.

 

[lbass]

Maybe you didn't understand my response? The group sort expert is ONLY enabled when you insert a summary at a group level.

The summaries must be inserted summaries, not formulas. And yes, if you delete the group and the summarized field, the group sort expert would be disabled as it only works when there are inserted summaries in the report.

-LB

 

[nhtennispro]

You are right on both counts. Adding a summary field allowed the button to become enabled.

Thanks

 

[nhtennispro]

Perhaps this is covered elsewhere, but what I also found is that

A) Create a summarized field to enable Group Sort Expert
B) Use the Group Sort Expert to create a top 10 list
C) Delete the field in step A and the Group Sort Expert stays enabled.