Hi,

I am looking for top N rows in a report for that I go to report > group Sort expert

I selected the Top N from the drop down and put a parameter in the formula which allows me to select any number of top rows, however I am looking for something like this the parameters should allows me to select particular number of top procedures or all procedures I am wondering how to do code it in my report ? Please help.

Thanks,

Hello Sastry,

Procedures isn't really stored procedures it is a field in a table which I am using to group by in my report.

I would like like to setup a parameter which gives an option to select Top N or All(all records for that query irrespective of top rows).I know how to setup TOP N but not sure how to pass ALL.

Sorry about the earlier confusion, I hope this explains better.

Thanks,