ssrs

Question

 i need fix number of records in a report....

by doing this i have done grouping.....it s fine .working.

but my columns having interactive sorting....

this time sorting is done by group level....but i need entire records from 1 st value to last value....can u plz any one

Answer 1

Hi srinu

This can only b possible if u avoid grouping, if u want the records to be sorted in order.

Answer 2

Hi Srinu,
I am not clear if I got the exactly requirement. Maybe we can add a column to sort the record in the query, and then use this field to fix the number, I have tested it on my test environment, the query looks like:
select *,rank() over(order by columnname)as rank from tablename order by columnname

The report looks like below.

If I have anything misunderstood, please point it out and elaborate the requirement, so that we can make further analysis.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support