Query Builder

Build Relations Automatically

Automatically builds table relations based on your application data dictionary. No need to build a new data dictionary. VisualRep is using the referential integrity built in your application. The user can review the SQL statement for the query in any phase of its creation. This SQL statement can be saved into a text file.

Flexible Filter Creation

It has a filter wizard built in either, in 2 different areas as a WHERE clause or within the JOINS condition, thus improve performance of the Query execution when used with JOINS.

Build Relation by Drag and Drop

VisualRep also provides the capability to create a manual relations by drag and drop the child table on top of the parent table. Easy selection of the type of the relation to be created. There are four types of relations to combine the tables which are described below.

  1. Only matching records.
  2. All rows from left table.
  3. All rows from right table.
  4. All rows from both tables (right and left).

Queries within VisualRep are the data source for all reports and labels. More than one report may belong to a single query, but the query result set needs to be generated before a report or label is created. The query contains the SQL statement created by the query creation wizard. All tables, fields, relations and filters are defined within the query. VisualRep uses this information when the report is generated.

Optimize Query Performance

VisualRep enables the user to run an optimized query per report. That means if for a particular report it is needed only 3 tables then you can select the only tables you need for this query.

Automatic Update

If new tables were added within a database engine, VisualRep will show all available tables that were entered. This update is done automatically with no need to define the data dictionary again in VisualRep. Also, if a table is removed from a database engine, VisualRep will remove it from the available table list.

Powerful Parameter Form

It enables different parameters selection prior to the report execution.

The parameters concept is very important within the VisualRep general architecture. It provides additional flexibility in order to produce reports with different conditions. A parameter is a variable that can be passed into the query before the execution. The report will display the results of the query, while the query produces the data source for the report. VisualRep provides the capability to create unlimited number of parameters.