Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2009-09-08 : 03:27:26
|
| Hi,I have a graph with dates on the x axis.I need to know how i can group them by month.I am on SQL Reporting Services 2005.Thanks in advance |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-08 : 08:13:10
|
| 1sabine8,I had similar question a couple weeks ago and got this snipet for help. Create a calculated field in your SQL like the following and use that for the graphing. The code creates a YYYY/MM from a datetime field.CONVERT(varchar(7), t1.Sales_Date, 111) AS [Date Bucket]Hope this helps.John"The smoke monster is just the Others doing barbecue" |
 |
|
|
|
|
|
Group dates by month in graph