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.

Search