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,
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'
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
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.