Using a Set Parameters action to resize a report object

You can use formulas to specify the height of rows, and the width of columns. In conjunction with a Recalculate report action, you can allow users to resize a chart, for example.

  1. Insert a chart into a report.
  2. Create a report variable called rvChartHeight and populate it with a whole number.
    A value of 100=1cm. The default height of rows is 0.476. To specify the default height as the value of the variable, specify 476.
  3. In separate cells, enter Bigger and Smaller.
  4. Right-click Bigger and select Define Action.
  5. Select Set parameters as the action type.
  6. Select Hyperlink as the mode.
  7. In the Parameters section, click Add parameter and select rvChartHeight from the Report variables list.
  8. Click the browse button in the Value field to open the Edit Value dialog.
  9. Specify this value: =VALUE(ReportVariables.rvChartHeight.Text)+100
  10. Copy the Bigger action to the Smaller cell and change +100 to -100.
  11. Select the row headers of the rows that are occupied by the chart.
  12. Select Format > Rows.
  13. Select the Formula check box and select the rvChartHeight report variable from the list.
In View mode, click Bigger and Smaller to change the size of the chart.