Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS - How to create height dynamically for bar charts Expand / Collapse
Posted Thursday, August 1, 2013 2:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 13, 2013 2:03 PM
Points: 5, Visits: 85

I have earlier calculated the height for all my bar charts dynamically by specifying the Maximum value for the y axis in the Maximum properties.
For example, =MAX(Parameters!AvgValue.Value) * 2.0

This has been working for me and it will increase the height based on the maximum value displayed in the graph.

On the Y-axis I am counting the days, let call it CountOfDays.

Categories axis: Date for example YearMonth.

Values consists of all AverageValues for each month/year.

Now to the problem that has occured for me. I have changed some of these graphs to be a stacked bar chart. I have categories in each bar, for example
status 1, status 2, status 3 and so on. I added a new attribute, called Status, to the dimension in order to make this possible.

The expression doesnt work now and I have used different kinds of expression.

Does anybody know how I can solve this or which type of expression I can use?

The expression does only work when I take away Status from the dimension and from the dataset.

Thanks for all help!
Post #1479829
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse