Skip to content

Action

When using a Report Action, the Action argument describes how the Report Action is shown to the user and the behavior it has on the report.

After defining the Action you want to perform, you may want to define the Report Actions Result Style

Available Action Styles

Normal

When you choose the Action style, “Normal”, the Report Action will display no extra user interface and will execute on every single calculation of the report.

Button

When you chose the Action style “Button”, your users will see a standard button in the cell containing the Report Action and the Report Action will only execute when the user presses the button.

Text

The label you want to show on your button. This text will not inherit the formatting from the cell it lives in.

Valid values: Free text

Enabled

Whether or not you want this button to be enabled.

Info

You may want your button to start disabled and then become enabled given some circumstance. To do this, you a cell reference in this location “=A3” for example, so that when A3 changes from false to true because of the other logic you have in your report, the button will become enabled.

Valid values: True/False

Confirmation Text

A message that you want to display to the users when they press the button, before it performs any other actions. This message will display in a dialog box to the users with an “OK” and “Cancel” button.

  • “OK” will continue the action
  • “Cancel” will stop the action

Valid values: Free text

Pre-Calculate

Whether or not you want your report to calculate when you press the button before it actually executes the set action.

Valid values: True/False

Post-Calculate

Whether or not you want your report to calculate after it has returned the result of the action.

Valid values: True/False

Image

When you chose the Action style “Image”, your users will see the image your specify the cell containing the Report Action and the Report Action will only execute when the user clicks on the image.

ImageUrl

The URL of the image that you want to display in this cell.

Valid values: A URL

Enabled

Whether or not you want this image to be enabled for clicking.

Info

You may want your image to start disabled and then become enabled given some circumstance. To do this, you a cell reference in this location “=A3” for example, so that when A3 changes from false to true because of the other logic you have in your report, the image will become enabled for clicking on.

Valid values: True/False

Confirmation Text

A message that you want to display to the users when they press the button, before it performs any other actions. This message will display in a dialog box to the users with an “OK” and “Cancel” button.

  • “OK” will continue the action
  • “Cancel” will stop the action

Valid values: Free text

Pre-Calculate

Whether or not you want your report to calculate when you press the button before it actually executes the set action.

Valid values: True/False

Post-Calculate

Whether or not you want your report to calculate after it has returned the result of the action.

Valid values: True/False

Image and Text

When you chose the Action style “Image and Text”, your users will see the image your specify as the background of the cell containing the Report Action with the text you specify laid over the top. The Report Action will only execute when the user clicks on the image.

Text

The text you want to show on top of your image. This text will inherit the formatting from the cell it lives in.

Valid values: Free text

ImageUrl

The URL of the image that you want to display in this cell.

Valid values: A URL

Enabled

Whether or not you want this image to be enabled for clicking.

Info

You may want your image to start disabled and then become enabled given some circumstance. To do this, you a cell reference in this location “=A3” for example, so that when A3 changes from false to true because of the other logic you have in your report, the image will become enabled for clicking on.

Valid values: True/False

Confirmation Text

A message that you want to display to the users when they press the button, before it performs any other actions. This message will display in a dialog box to the users with an “OK” and “Cancel” button.

  • “OK” will continue the action
  • “Cancel” will stop the action

Valid values: Free text

Pre-Calculate

Whether or not you want your report to calculate when you press the button before it actually executes the set action.

Valid values: True/False

Post-Calculate

Whether or not you want your report to calculate after it has returned the result of the action.

Valid values: True/False