Resizing a report object with the Recalculate Report action

You can use variables 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.
  3. In separate cells, enter Bigger and Smaller.
  4. Right-click Bigger and select Define Action.
  5. Select Recalculate report as the action type.
  6. Select Hyperlink as the mode.
  7. Double-click <New 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.
    See Copying actions.
  11. Highlight the rows occupied by the chart.
  12. Select Format > Rows.
  13. Select rvChartHeight in the Variable field.
Parent topic: Actions