|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
|
