hi ........i have a query related to MS reporting services

HI to all of you. I am a new member of this group and this is my first mail in this group.I am working in MS Reporting services.And i am new in this job.

 

I have a problem.

There is a table which has many columns.

and i have to give selection to client that he can select any top 10,25,500,1000, sales  by departmentment

there are more than 10 department and he want to see top ten seelings in each department.

How i can do it.

without using top 10 syntax iin query.

i dont have to use top 10 sales from table syntax.

so please help me.

Regards

Dinesh Tiwari