TOP N Parameters

[lisa626]

Crystal XI - Business Objects XI R 2

I have a report that has multiple parameters, I want to add a parameter so that a person can tell it to pull the top # or all of a certain group, what would be the easiest way to do this???

 

[lbass]

Set up a number parameter {?topN} and in the prompt text, instruct the user to enter 0 to see all groups, or to enter the number of top groups he/she would like displayed. Then go to report->group sort->topN->where N is->x+2 and enter:

if {?topN} <> 0 then
{?topN} else
10000

-LB

 

[lisa626]

Ok, have the parameter created...
Under report->group sort->topN->where N = 10000, where do I put the formula

if {?topN} <> 0 then
{?topN} else
10000

does that go at the group I want to sort on or where????

 

[lbass]

This goes right IN the group sort screen. After you select topN, a space appears below--leave that as is, and instead go into the x+2 button next to it and enter the formula there. The formula overrides whatever is in the box.

-LB

 

[lisa626]

It won't let me leave it blank, it wants a number greater than 1.

 

[lbass]

What won't be left blank? If you mean the box next to the x+2 put a number in it--it doesn't matter, since the formula will override it.

You always must enter something at a parameter prompt--at least in XI.

-LB

 

[lisa626]

ALSO, my fault, forgot to add that I have 2 subreports on this report that also need to show top n, would I do the same thing for the sub reports as I did for the main.

SORRY, I thought I was adding to the original.

 

[lbass]

Once you have created the parameters in the subs and set up the topNs in each, you can link the parameter from the main report to the parameter in each of the subs by using the dropdown in the lower left of the subreport linking screen to select {?topN}, not the default {?pm-?topN}.

-LB