Skip to main content
InSource Solutions

TN DR105 Performing an open query in Dream Reports with dynamic variables.

  1. Last updated
  2. Save as PDF

InSource_Logo_Transparent.png

Description

 

This article from InSource shows how to perform an open query in Dream Reports and utilize dynamic variables.

  • Author: Joseph Hefner
  • Published: 09/05/2017
  • Applies to: Dream Reports 4.7 and above

Details

Step 1) 

Create the dynamic variables that you wish to expose to the open query. In this example I have created a value for a start and end time in the report and I will update it based off of a tag at an absolute date and time.

Capture1.JPG

 

Capture2.JPG

 

Step 2) 

Add a SQL Query table and configure the direct query:

 

Capture3.JPG

 

* You will need to use single quotation marks around the dynamic variables as below and click the "Use query directly" checkbox.

Capture4.JPG