We would like to be able to pass a variable to a report to use it in the where clause. (4333879)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

We would like to be able to pass a variable to a report to use it in the where clause.
Description

We would like to be able to pass a variable to a report to use it in the where clause. Is that possible?
Resolution
Yes, that is possible. Let's see an example below:
1. Create a variable in the Toad Automation Script (tas) with the "Set Variable" system activity. Let's assume the name for the variable is "varInicial"
2. Add a "Toad Report" database activity and add the report that needs to be run
3. Click on "Edit Report"
      4.On the "Data" tab, enter the name of the variable with ": " like in the Screenshot below: