Search This Blog

Issue with SSRS Reports type charts Months as Horizontal axis in SSRS

Issue with SSRS Reports type charts Months as Horizontal axis in SSRS

Yesterday while creating a report i found a issue like In my Report i was displaying the Sales pr month
The horizontal axis was showing months name and vertical axis bar as sales per month
while testing the Report i faced a issue.
The Report was not showing all months Name it was showing Months Names every other.

Below is the ScreenShot how Month was coming into Reports. 
If you look into the above screenshot  it is not showing all months Names it is showing bars for each month but not displaying months Name below.

In order to fix this issue.

Go to Design Mode of your Report.

Go to Horizontal Properties--By  Right clicking on Month Names in Design Mode

You will get the below Image.

You will See Interval option in the Image which is by default as Auto change it to 1 and it will fix down the issue.
Preview the Report.

As you will see in the above screenshot all months name are coming .

3 comments: