Grow the width of a Reporting Services Chart as the data grows over time?

• rkelly58

  SSCrazy

  Points: 2151

  More actions

  November 4, 2015 at 3:18 am

  #304834

  Hi,

  Wondering if you guys can help?

  I've got a very basic chart in Reporting Services... The chart is by itself, i.e. not placed in a table or list.

  The chart is a column chart with x-axis of Date (each day) and y-axis is number of items.

  I'm not concerned with the y-axis as that will always been within a range, but I want the chart width to grow as each day passes, how do I do this?

  I have parameters where the user picks a start and end date, but it all looks squashed up if the user picked a couple of months.

  Can someone show me how to display the chart in scale and grow it depending on the date range selected and have the user scroll across using the slider?

  Is this possible?

  Thanks

• rkelly58

  SSCrazy

  Points: 2151

  More actions

  November 4, 2015 at 5:40 am

  #1837615

  Managed to get the width to adjust using this exp:

  =(1 + DateDiff("d",Parameters!StartDate.Value, Parameters!EndDate.Value) / 2) & " in"

  However I don't like it because the column bars also grow in size (height and width) if I pick a big date range.

  is there a way to extend the width of the chart, but keep the column sizes the same?