Link to home
Start Free TrialLog in
Avatar of n_srikanth4
n_srikanth4Flag for India

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_CODE = '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
Avatar of HainKurt
HainKurt
Flag of Canada image

"it won't  work IN THE TABLIX" --> do you know why?
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...
Avatar of n_srikanth4

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?????
Avatar of mazher
mazher

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
Avatar of HainKurt
HainKurt
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
same here i am metioning Table Data Region Sort expression.

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 ...
good