SSRS 2008R2: How we can hide X-axis label in line chart?

0
votes

I am new in SSRS world.

I have set the X-axis label interval '1' and Interval Type 'day'. It is working properly. Now I want to hide the all label Except the 1st, 15th,31th Date of every month. Is it possible to set the expression in hide properties for X-axis?

Can anyone help me regarding that?

1
ssrs-2008

1 Answers

1
votes

EDIT #2 Open the Category Group properties - there you will have the option to define expression to the labal. Then use the following expression:

Switch(Day(Fields!SAMPLE_DATE.Value) = 31 , "31", Day(Fields!SAMPLE_DATE.Value)> 1 AND Day(Fields!SAMPLE_DATE.Value) < 14 , " ", Day(Fields!SAMPLE_DATE.Value) = 15 , "15", Day(Fields!SAMPLE_DATE.Value) > 15 AND Day(Fields!SAMPLE_DATE.Value) < 30, " ", Day(Fields!SAMPLE_DATE.Value) = 30 , "30")