Executing Reports on a Button Press or Command

You can execute reports using a button by writing a 1 to the @@Execute tag for the report.

Add a Write Value pick action to your display. For the data source, browse under My Computer > Reports > your report > @@Execute. For the OnUpValue, put a 1.

Pick Action to Execute Report

If your report has any parameters you will need to supply them in the tag path. String values may be enclosed in double quotation marks, but this is not required.  An example of an @@Execute tag containing parameters is:

rwx:Order Details Report/@@Execute<@param1=ALFKI>

NOTE: If you have configured your parameters to have separate display values, you must use the non-display value in the tag path. For example, for the example Order Details Report, you must use the CustomerID (like “ALFKI”) not the ContactName (like “Maria Anders”).

Pushing that button in runtime will tell the ReportWorX64 Server to execute that report.  

You can use the @@Execute button to trigger a report from anywhere that can write a value, including Workflow, BridgeWorX64, and anything that can execute a Write Value command.

NOTE: The Run Report Command was designed to run 32-bit ReportWorX reports. It will not work for ReportWorX64 reports. Use the Write Value Command and the @@Execute tag for the report.

Using @@Execute and Other Report State Tags

The @@Execute tag can be used with the rest of a tag to execute a report and check on its status. Along with the @@Execute tag, each report contains additional helpful tags that allow you to see the state of the report and tell when it has run.

These include:

• @@Cancel – Cancels the currently running report

• ExecutedTicks – This value increments when a report has completed. This tag may reset if ReportWorX64 or FrameWorX is restarted.  The actual value is usually not important, but you can tell that a report has completed by watching for this value to change.

• LastExecuted – The time when the report was last triggered in local time.

• LastExecutedError – If the last report failed, this will show the error of the last report.

• LastExecutedInterval – Shows how long it took to generate the last report.

• LastExecutedState – A number that represents the state of the last triggered report. The states are:

• • -1: Unknown

  • 0: Completed

  • 1: Queued

  • 2: Running

  • 3: Failed

  • 4: Ignored

• LastExecutedUTC – The time when the report was last triggered in UTC time.

See Also:

Reports

Excel Add-In

Displaying/Mapping Parameters in Excel Sheet

Quick Edit Data Source