Saturday, December 08, 2012 8:41 AM
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
Saturday, December 08, 2012 9:21 AM
This can only b possible if u avoid grouping, if u want the records to be sorted in order.
- Proposed As Answer by Anjum Aara Tuesday, December 11, 2012 7:43 AM
Monday, December 10, 2012 8:25 AMModerator
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.
TechNet Community Support