How VisualRep Works -
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.
|
- Only matching records
- All rows from left table
- All rows from right
table
- All rows from both
tables (right and left).
|
 |
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. |
 |
|
|
