September 14, 2011 at 5:07 am
I have created a chart in ssrs 2008 report.
The x-axis shows date i.e. 30 jun 2010, etc...
The dataset returns 18 records and each one has a field called mydate which I am using as the x-axis of the chart.
Question:
At present, the x-axis shows only 3 dates i.e. 30 jun 2010, 30 nov 2010 and 30 apr 2011
I would like the x-axis to show all the dates i.e. 18 dates since there are 18 records returned.
How is this done please?
Thanks
September 14, 2011 at 9:46 am
fmardani-786425 (9/14/2011)
I have created a chart in ssrs 2008 report.The x-axis shows date i.e. 30 jun 2010, etc...
The dataset returns 18 records and each one has a field called mydate which I am using as the x-axis of the chart.
Question:
At present, the x-axis shows only 3 dates i.e. 30 jun 2010, 30 nov 2010 and 30 apr 2011
I would like the x-axis to show all the dates i.e. 18 dates since there are 18 records returned.
How is this done please?
Thanks
Are you sure your dataset returns 18 unique dates, one for each record?
Values will typically not be excluded from the x-axis unless you are grouping/aggregating, or unless your plotted value field is null for those records.
September 14, 2011 at 10:17 am
yes, there are 18 different dates. One in each record for the mydate field.
September 14, 2011 at 10:21 am
fmardani-786425 (9/14/2011)
yes, there are 18 different dates. One in each record for the mydate field.
Verify that there are no data filters on the chart and that the data values are not null.
September 14, 2011 at 12:50 pm
In the chart axis properties set the LabelInterval property to 1. You'll need to do this from actual properties window(F4) and not from the axis context properties.
September 15, 2011 at 4:00 am
Solved. Thanks
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply