Top N or Bottom N filter based on a parameter

i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ?

---

j. way

there many ways set report accomplish this. e.g

asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query

if (parameter value = "top")

select top n ......

else if (parameter value = "bottom")

select top n ......order <ordered column name> desc (again there other ways of doing too)

else

(whatever business logic needs go here, if @ all)

if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above.

hope gets on right track.

cheers!

-muqadder.

SQL Server  >  SQL Server Reporting Services, Power View