Search This Blog

Wednesday 25 June 2014

SSRS Reports Range Bar Chart Show Start and End Date Only

Below are the steps to show the start and end date only in a range bar chart in SSRS reports.

First of all just select the Horizontal Axis of the chart as you can see this in the below image.










Now right click this horizontal axis and than select axis properties.

A new window will open select the first tab i.e Axis Options.As you can see this window in the below image.


As you can see in the above image in the minimum text box select the startdate and in the maximum text box select the end date and in the interval write the expression i.e

=datediff("d", Fields!PSASchedStart.Value, Fields!PSASchedEnd.Value)

after that click ok and than save the report.

After running the report you will see that you can only see the start and end dates in the range bar chart as you can see in the below image.









This was all related to the range bar chart showing the start and end date only.

Below is the link for more information

http://stackoverflow.com/questions/18004792/ssrs-chart-x-axis-show-start-and-end-date-only

If you have any issues feel free to comment on this.

Thanks

Muhammad Zahid.

No comments:

Post a Comment