0
votes

I am new to SSRS world. I want to show the Horizontal axis label field as per below:

In my report I will pass a parameter called Year. In the repot it will show a line in Y-axis (it is limit field) and Date field is in the X-axis. I want to show total (12 + 1)=13 label like 1st date of every month (e.g. 1-jan-, 1-Feb) and last date of the selected year (31 -Dec).

Can anyone please help me regarding that?

1
Try to amplify your question, it is not clearGil Peretz
For the Horizontal axis the label interval is 1 and interval type is 'Months'. So there will be 12 labels (1-Jan-2012,1-Feb-2012) in the x-axis. But I want to add one extra label in it at the end of the Axis (like 31-Dec-2012). Can anyone help me?Rana_kgec

1 Answers

3
votes

Try to change the axis type to scalar, then set the following fields:

  • Minimum - 1

  • Maximum - 13

  • Interval - 1

  • Interval Type - Numbers