CODEWITHSUNDEEP
reportingservices-2005
NealWalters
NealWalters

Reputation: 18227

SSRS - How to show date on Horizontal Axis

I want to put the date on the X (Horizontal-Axis). Simple count of sales by day.

Current chart: enter image description here

I see how to turn off the legend. Might also be good to make bars the same color. But I don't see what else to do to get the date. I did try the labels tab, and put in an expression "=Fields!WebOrderDate.Value", but that didn't change anything.

Here are my current settings: enter image description here

My SQL: 

select CONVERT(date, WebOrderDateTime) as WebOrderDate, 
 Count(*) as Count 
from VendorTrackingViewRpt 
where PONum is not null and WebOrderDateTime is not null 
group by CONVERT(date, WebOrderDateTime)
order by CONVERT(date, WebOrderDateTime)

Upvotes: 0

Views: 131

Answers (1)

UNOPARATOR
UNOPARATOR

Reputation: 706

I don't have SSRS available to me right now, but I think you should put the WebOrderDateTime under Category Groups instead of Series Groups.

Upvotes: 1

Related Questions