Reputation: 399
I'm creating a report where I want to send a parameter for the number of records to display (I do not want to select the number of records in SQL)
I have created a parameter field (?topN) and set the group to use this value which in design mode works well however when I try to set this parameter in vb.net code it does not work. The field which also displays the value shows the parameter correctly though. Any ideas?
Thanks
Upvotes: 1
Views: 1735
Reputation: 26262
If you are grouping, you could use the TOP-N feature of group sorting.
Upvotes: 0
Reputation: 539
Try this in the Section Expert, in the Suppress code option:
Recordnumber > ?@topN
Upvotes: 1