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.
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.
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.
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.
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.
It enables different parameters selection prior to the report execution.