Top N, Group Sort & Parameter fields

38 Views

Post Author: training2go

CA Forum: Formula

Hello,

I'm using crystal for visual studio 2005. I am trying to create a parameter field that will let the user select the N in Top N for the report. For example, the user should be able to select any number between 1 and 100 for N. If they want to run the report for the top 10, 12 or 78, they should be able to. The problem, I'm having is that I don't know where to put the formula. I looked on the Group Sort Expert, but didn't see any way to add a forumla.

On a different report, I'm having the same problem with figuring out where to put the formula to allow the user to select Ascending or descending from a parameter field. I know how to write the formula, I just can't figure out what to attach it to. I looked on the Group Expert. The Group Sort Expert option for this report is dimmed out.

Any help would be greatly appreciated.

Thank you.