Thread: 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
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min.
> 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. Take a look at LIMIT. http://www.postgresql.org/docs/8.1/interactive/queries-limit.html //Magnus