reporting services - VisualStudio 2010 - How do you display only YEAR in a chart? -

reporting services - VisualStudio 2010 - How do you display only YEAR in a chart? -

this code used in dataset. result shown in image. plan display year without month, day or time. feasible?

select t.name territoryname, p.lastname salesperson, c.cardtype paytype, s.orderdate, s.totaldue sales s bring together person p on s.salespersonid=p.businessentityid bring together creditcard c on c.creditcardid=s.creditcardid bring together territoryt on t.territoryid=s.territoryid

there number of ways accomplish this. easiest, calculate year value straight in dataset, , utilize field in chart. simple matter of adding next code select part of dataset:

select ... s.orderdate, year(s.orderdate) [orderyear], -- new field s.totaldue ...

alternatively, can create look same thing, either calculated field in dataset, or straight in chart category field.

visual-studio-2010 reporting-services