I have an SSRS report that contains a number of charts.
Where a chart hits a certain amount of results it will resize dynamically using the below code:
=(1 + Count( Fields!groupedColumnName.Value, "MyDataset") / 2) & ” in”
The problem is that although the charts are resizing the body does not.
Current size parameters for the body of the report are set to A4 (Portrait):
Height: 29.7cm; Width: 21cm;
Is there a way to set these values dynamically? It doesnt look like I can enter an expression.
The answer to this question turned out to be quite simple.
There is a report property named InteractiveSize that allows you to set the size of the report when its rendered (not printed).
You simply set either the Width or Height value to '0' depending on your need.