SQL server 2005 Report Service

[Guest]

I am trying to use SQL Server 2005 Report Service to generate a grouped and
sorted report. But the order is customermized. For example, I need order them
by column rating. But the order is not alpha-numeric. It should be like 'AAA'

'AA' > 'A' > 'A1' > 'BBB' > 'B+' > 'B-' > 'B1' etc. How could I do that?

Thanks

 

[Paul Shapiro]

In the Rating table, add a column for numericRating and sort based on that.
If you don't already have a Rating table, you should probably create one and
enforce referential integrity to wherever you're storing the ratings.
Paul Shapiro

"DataGridView add row dynamically"