CR 10 Display the group with the highest summary (or top N)

[bether]

How can I instruct the report to display the groups that have the highest summary, taking from the parameter the number of groups that need to be displayed? Please note, that the details of the top N groups should also be displayed

 

[KeertanaCR]

Hi,

According to my understanding you want to do group sort using Top N(Highest N group Summaries), where N is the parameter selected by the user
for the number of groups to be displayed. If this is right try the following.

1>>Create a paramater NoOfGroups and select the type as Number.
2>> In the report> group sort Expert
a: select Top N in the drop down list for this group sort
b: click on X2 next to where N is and add
{?NoOfGroups}

Hope this hepls

Thank you

 

[bether]

Hi,

Thanks for your swift response. I looked, but there's no x+2 right next to where N is.

Any further help/suggestion will be greatly appreciated.

Thanks.

 

[KeertanaCR]

Hello

Did you see text box to enter value for N, just below where N is. the X+2 will be right next to this text box.

By the way the version i am looking at is Crystal XI R2.

I looked at ur other post too. so basically you have to add {?GroupCount} after clicking X+2

Thank you

 

[KeertanaCR]

I did not see that option in Crystal 9, no idea about Crystal 10

Thank you

 

[bether]

I appreciate your help.

I guess CR 10 doesn't support this conditional setting of top N.

Thanks!

 

[KeertanaCR]

Hi

you can't actually change the N value in Crystal 10 i guess, but you can make it looks like it's been
changed.

in your group header sections ,details sections
footer, place a
supression formula:
GroupNumber > {?groupcount}

Thank you

 

[bether]

Thank you for your willingness to help.

I've tried this already and tried it again now. This works and doesn't work for what I need.

What happens is, yes, it picks up the correct number of groupings, but the details under each grouping, for some reason is always returning only 1 row or detail. This is regardles if that group has multiple details under it. I'm not sure if I'm doing something wrong or it simply doesn't work.