Constanta
Constanta

Reputation: 399

Set parameter for number of records to display in Crystal Reports XI

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

Answers (2)

craig
craig

Reputation: 26262

If you are grouping, you could use the TOP-N feature of group sorting.

Upvotes: 0

Mark SQLDev
Mark SQLDev

Reputation: 539

Try this in the Section Expert, in the Suppress code option:

Recordnumber > ?@topN

Upvotes: 1

Related Questions