Which control are you using in the SSRS report, a table or a matrix (tablix)? A matrix order the data on it's own to aggregate the data, here you have to define the sort order in the matrix control.
Rows should be Ascending order in SSRS
Hi SSRS team,
I need Row wise accending order I have try my query side but still didnt coming Ascding order
COMPANY_NAME column value only 3
Select * from F_COMPANY
WHERE FYEAR =@Year and FMONTH =@Month_Name
order by (CASE when COMPANY_NAME='Ab' THEN 1
WHEN COMPANY_NAME='Vot' THEN 2
WHEN COMPANY_NAME='Vote' THEN 3
ELSE 4 END) ASC
Please provide queries to create the relevant table(s) and insert some sample data.
According to the sample data, please describe what is the expected result which you want to get
Sign in to comment
Sort by: Most helpful
Hi @Shanvitha ，
I tested locally, there is noting wrong with the query.
With the SSRS report table, everything goes well.
The COMPANY_NAME column is ascending order.
Please make a double check of your data and settings.
It would be great if you could provide a minimal reproducible such as DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November