n_srikanth4
asked on
Sort by short month name(Colum Name)in the Tablix
I want to sort by short month name (Jan , Feb.....Dec) in my Tablix .... I am able to sort in the stored procedure bind to the report dataset... But in the report , it won't work IN THE TABLIX..
Please provide me the expression to achieve this....... Please see the attached report which is not sorted by short month name and also the query results of the stored procedure
Query(Stored procedure) bind to the Data SET :
SELECT COUNT(INV_NUMBER) AS Invoices_Processed,
NWO_SHORT_CODE,
INV_BILLING_PERIOD_MONTH ,
CASE INV_BILLING_PERIOD_MONTH
WHEN 1 THEN 'Jan'
WHEN 2 THEN 'Feb'
WHEN 3 THEN 'Mar'
WHEN 4 THEN 'Apr'
WHEN 5 THEN 'May'
WHEN 6 THEN 'Jun'
WHEN 7 THEN 'Jul'
WHEN 8 THEN 'Aug'
WHEN 9 THEN 'Sep'
WHEN 10 THEN 'Oct'
WHEN 11 THEN 'Nov'
WHEN 12 THEN 'Dec'
ELSE 'Unknown'
END AS Billing_Month
FROM INVOICE INV INNER JOIN INVOICE_TYPE ITP ON INV.INV_TYPE_ID = ITP.INV_TYPE_ID
WHERE ITP.INV_CLASSIFICATION_COD E = 'TND' AND (NWO_SHORT_CODE IN (SELECT CODE FROM DNO))
AND INV_BILLING_PERIOD_MONTH BETWEEN @Billing_Month_From AND @Billing_Month_To
AND INV_BILLING_PERIOD_YEAR = @Billing_Period_Year
GROUP BY NWO_SHORT_CODE, INV_BILLING_PERIOD_MONTH ,INV_BILLING_PERIOD_YEAR, INV_CLASSIFICATION_CODE
ORDER BY INV_BILLING_PERIOD_MONTH ASC
Query-Results.txt
Report.docx
Please provide me the expression to achieve this....... Please see the attached report which is not sorted by short month name and also the query results of the stored procedure
Query(Stored procedure) bind to the Data SET :
SELECT COUNT(INV_NUMBER) AS Invoices_Processed,
NWO_SHORT_CODE,
INV_BILLING_PERIOD_MONTH ,
CASE INV_BILLING_PERIOD_MONTH
WHEN 1 THEN 'Jan'
WHEN 2 THEN 'Feb'
WHEN 3 THEN 'Mar'
WHEN 4 THEN 'Apr'
WHEN 5 THEN 'May'
WHEN 6 THEN 'Jun'
WHEN 7 THEN 'Jul'
WHEN 8 THEN 'Aug'
WHEN 9 THEN 'Sep'
WHEN 10 THEN 'Oct'
WHEN 11 THEN 'Nov'
WHEN 12 THEN 'Dec'
ELSE 'Unknown'
END AS Billing_Month
FROM INVOICE INV INNER JOIN INVOICE_TYPE ITP ON INV.INV_TYPE_ID = ITP.INV_TYPE_ID
WHERE ITP.INV_CLASSIFICATION_COD
AND INV_BILLING_PERIOD_MONTH BETWEEN @Billing_Month_From AND @Billing_Month_To
AND INV_BILLING_PERIOD_YEAR = @Billing_Period_Year
GROUP BY NWO_SHORT_CODE, INV_BILLING_PERIOD_MONTH ,INV_BILLING_PERIOD_YEAR, INV_CLASSIFICATION_CODE
ORDER BY INV_BILLING_PERIOD_MONTH ASC
Query-Results.txt
Report.docx
ASKER
What settings, i should provide???? please explain me how to sort by Month Name ... is it possible to sort the Column(Short Month name) in Tablix by using an expression?????
you have posted same question in title "Sort by short month name in the Tablix" i have tested it in reporting service 2008 Send Your Rpt file let me check what is problem at your end.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
same here i am metioning Table Data Region Sort expression.
ASKER
Mazher,
I will send you the report file tomorrow from office..
in the mean time , can you provide me the Table Data Region Sort expression to use ...
see link below for same question answered
https://www.experts-exchange.com/questions/24837157/Sort-by-short-month-name-in-the-Tablix.html?cid=1131&anchorAnswerId=25655503#a25655503
https://www.experts-exchange.com/questions/24837157/Sort-by-short-month-name-in-the-Tablix.html?cid=1131&anchorAnswerId=25655503#a25655503
ASKER
good
it does not care order by statement? if it does not care order by, then somehow it should provide a way to sort the records, check the settings...