Joined: 13 May 2013
Location: United States
Online Status: Offline
Posts: 38
Topic: How to do Top N with a parm promt? Posted: 21 May 2013 at 2:58am
Good morning folks,
I have the need to be able to do a Top N group based on what what the user enters when prompted. For now using the Top N select expert I went with the default of Top 5. I also have created the parameter named "parmTopX" of type number. In order to wire this thing up I took a look at the record and group selection formula editors but I have no idea what to write. Can someone please help me?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 21 May 2013 at 4:09am
hmmm. I am not sure if it is in 8.5 I know it is in 10 and up.
look around a bit to see if you can find it.
It is only available for use if you group on a field and then insert a summary of a field at the group level. it must be one of the simple group summarizations field, nothing using while printing records or next/previous, etc.)
Joined: 13 May 2013
Location: United States
Online Status: Offline
Posts: 38
Posted: 21 May 2013 at 5:33am
Nope. My boss showed me a way after i squirmed for a couple of hours. I'll post it later for others with the same 8.5 limitations. Thanks for the help though, anyway.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
