TOP/N sort Group Expert

[johnism]

Is there any way to set the ( where n is" " ) part to a formula or parameter? I understand you can hard code it here , but I need that to be able to change it by a parameter. Meaning if one time the user wants it for to return 5 and the next time 50( they can just change the parameter value , with out having crystal )? Or is there away to create a formula to do this?

 

[dgillz]

Crystal cannot do this with a parameter.

A workaround is to make your top N and select "ALL" to rank groups, then use a parameter to conditionally suppress group numbers greater than your parameter. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[johnism]

I understand the all part , could you expand more on the rest ( example maybe ). thanks
John

 

[dgillz]

Create your parameter field, and make it a number data type.

Then from the design window, right click the Section(s) you would like to suppress when the group number is greater than your paramter field, and select format section. To the right of the suppress checkbox is a button labeled "X-2" for conditional suppression. Click that button and enter a formula:

GroupNumber > {?Parameter}

Let me know if you have any questions. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[johnism]

thanks you have been very help full.