Format Date Data for Accounting-Style “Year_Month#” Columns in Your SSRS Reports
So, you have a requirement to create a report on planned or actual cost data by month, by year, and your report requester would prefer that the column headings be formatted accounting-style, such as 2014_01, 2014_02, 2014_03, etc. No Problem! Place the following code into your SQL SELECT and GROUP BY statements, sum your cost Read more about Format Date Data for Accounting-Style “Year_Month#” Columns in Your SSRS Reports[…]