Logic Block Selection for SQL Reports

This article demonstrates how to retrieve SQL code from Logic Blocks to generate reports in SQL Designer.

Retrieving the SQL Code

1. Go to Workflow → Logic Blocks

2. Click on a Logic Block

3. Click on the Custom Heading Section

4. Click on the Clipboard Icon to copy the full SQL Code

Using the Selection Logic in SQL Reports 

1. Go to Reports → SQL Designer

2. Click on New

3. Locate SQL Section, paste the SQL Code into the editor

4. Make necessary modifications based on your specific requirements

5. Ensure all variables and selection logic placeholders (e.g., ${DateRange: DateRange}) are appropriately filled.

6. Click on Test to run the report and see the results based on the selected criteria and data fields.

Troubleshooting and Refining

1. If the report doesn't provide the desired output or encounters errors, review the SQL code for any potential issues or syntax errors.

2. Make necessary adjustments and repeat the testing process until the report functions as expected.

SQL Report Section

1. Enter Label: Provide a descriptive label for the SQL report.

2. Enter Identifier: Input an identifier for the report (optional).

3. Enter Description: Optionally, add a description for the report.

Output Format Section

1. Determine Output Format: Select the desired output format from the following options:

• HTML

• PDF

• CSV

• EXCEL

• TSV

• DELIMITED

• XML

• JSON

• FIXED_LENGTH

• PIVOT

Header Section

1. Add Header Image (optional): If desired, include an image for the report header.

2. Add Header (optional): Optionally, add a header text for the report.

Locate Footer Section

1. Add Footer (optional): If desired, include a footer text for the report.

2. Click the Save button with the specified settings for future use.