Skip to content

Result Style

When using a Report Action, the Result Style argument describes how the Report Actions result is given back to the user.

Except for the Return Style “Workbook”, all the other return styles assume that you are returning a single string of text.  This text can be as small or large as you need it to be and could be plain text, or HTML or a URL, but if you try and return a set of data to these Result Styles, only the first cell in the result set will be returned.

If you choose a Result Style of “Workbook” your Stored Procedure can return a set of data.  This data is fed into a new sheet in a workbook and served as a download to the user.

Available Result Styles

In Cell

When you choose the Result Style “InCell”, the result of the Report Action is returned into the cell that has the Report Action, replacing anything that was there, including the Report Action.

Other Cell

When you choose the Result Style “Other Cell”, the result of the Report Action is returned into the cell specified, replacing anything that was there.

Cell Address

The text representation of a Cell Address that you want to return your result to.

Example

If you want to return your result to A5, you would put A5 in the property, but if you are building the cell address in another cell, say B10, then you would put =B10 in the property and the Report Action will know to get the cell address from that cell.

Valid values: Valid Cell Address

Note

The result of this cell can not be used as a parameter to drive another formula. For example, if the report action returns a key from the stored procedure, it cannot be used as the Key parameter in a CGETSQL.

Workbook

When you choose the Result Style “Workbook”, the result of the Report Action is returned as an Excel Workbook to the user.

Sheet Name

The name you want to give the sheet that contains the data in the workbook created.

Valid values: Free text

Workbook Name

The name you want to give the workbook that the user is given as a download

Valid values: Free text

Prompt

When you choose the Result Style “Prompt”, the result of the Report Action is returned into a prompt of the type specified.

Prompt Type

The style of prompt that you want to give the users when your Report Action returns a result.

Valid values:

  • Dialog
  • Callout
  • Lightbox

Dialog Title

The title of the dialog displayed

Valid for type: Dialog

Valid values: Free text

Height

The number of pixels high you want your dialog

Valid for type: Dialog, Lightbox

Valid values: Number

Width

The number of pixels wide you want your dialog

Valid for type: Dialog, Lightbox

Valid values: Number

URL

When you choose the Result Style “Url”, the result of the Report Action is assumed to be a URL and returned into the window/frame/tab specified.

Url Display Style

The style of prompt that you want to give the users when your Report Action returns a result

Valid values:

  • NewWindow - The result will be displayed to users in a new browser window
  • Frame - The result will be displayed to users in the frame specified
  • Lightbox - The result will be displayed to users in a lightbox
  • NewTab - The result will be displayed to users in a new browser tab
  • Normal - The result will be displayed to users in the current browser tab/window

Frame Name

The name of the frame (usually built by using a CREPORTFRAME formula)

Valid for style: Frame

Valid values: Free text

Height

The number of pixels high you want your dialog

Valid for type: Lightbox

Valid values: Number

Width

The number of pixels wide you want your dialog

Valid for type: Lightbox

Valid values: Number

Back to top