Like what you see? Have a play with our trial version.

Versions Compared

Old Version 3

changes.mady.by.user Yellowfin

Saved on

compared with

New Version 4

changes.mady.by.user Yellowfin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents

Overview

Styleclass
ClasstopLink

top

To write freehand SQL reports you will need to be granted specific user access. SQL reports require knowledge of ‘Structured Query Language’ and a sound knowledge of the data source that you wish to query.

...

Create a Freehand SQL Report

Styleclass
ClasstopLink

top

In select the SQL version all filters and conditions will have to be contained within the SQL. Type in your SQL statement into the text box provided.

...

  1. The inclusion of user prompt or source filter in your SQL reports is done by adding a {?} parameter.
    For example: select * from client where country = {?}
    If inserting a source filter with multiple possible input parameters use: select * from client where country in ({?}) (Note the additional Brackets)
  2. Clicking on “Validate” will inform you if the SQL syntax is valid, as well as the number of parameters present.

 

horizontalrule
Styleclass
ClasstopLink

top