VisualRep is a query and reporting tool for developers and end users alike. It is TWO products in ONE:
It offers a broad range of features, including access to the most popular databases such as Oracle, SQL Server 2005, Visual FoxPro, and MS Access. VisualRep reads all data dictionary metadata directly from the specified Database, such as tables, relations, fields' name, fields' formats and captions. You can generate a report with the following outputs:
PDF, HTML, Word, Excel, XML, Text and Dbf file. For the PDF file there is no need to install the Adobe Acrobat. It could be the report writer of your choice. It is in expensive user friendly report writer.
A 95% time savings may be realized because complex reports can be created simply by selecting the tables and fields in a Wizard. In a few minutes you will be able to run a variety of reports with a minimum learning curve.
Imagine you have 400 pages in a report and you need to find a category some where in the report, all it takes one click and you are there.
Selecting tables, such as Clients and Order, will automatically create the relation between the tables. VisualRep will inherit the database referential integrity and will create the SQL statement on the fly based on the tables and fields selection.
VisualRep's powerful Wizards will guide you step by step through creating a report or a query. There are three distinct functions :
Each function is handled by its own Wizard.
Report writer for any client server, MS Access and Visual FoxPro.
Developers can incorporate VisualRep into a Visual FoxPro application by calling the report via VisualRep with only one line of code. The developer could either expose the VisualRep interface to the user or provide its own.
It offers the developer and user both ease of use and flexibility. Much of the manual setup required by other reporting tools is done automatically by VisualRep. Many setup and runtime features of VisualRep are missing in other reporting tools and this product is the answer for that.
VisualRep is a project driven product. It is possible to create as many projects as needed. Each project can have as many data sets as needed Each data set can simultaneously access multiple Databases such as Access, SQL Server, etc.
If you program in Visual FoxPro then VisualRep has the answer for you. It has a build in framework that can provide different services such as calling report from any where in your application without the need to expose VisualRep to the end user. Simply by passing the report name to VisualRep it will run the report while working in the background.
If new tables were added within a database engine, say MS SQL 2005, VisualRep will show all available tables that were entered within MS - SQL 2005. Thus, it is considered as those tables where added into the VisualRep Data Dictionary. This update is done automatically, no need to define the data dictionary again in VisualRep. Consequently if a table is removed from a database engine, VisualRep will no longer show it as available table within its list.
After the fields and tables are selected, and the query is saved the report is automatically generated. You can tell VisualRep the way the report is automatically generated by checking the "Enable multiple lines" or Checking the "Fit To Page" feature which will generate the report with the minimum number of rows by reducing the font size. You can also generate the report and specify the number of rows needed for the report. There are many more features that are covered in the extensive help file (4.5MB) which will show you step by step how to work with VisualRep. You can download the help file at: /VRep/VRep_Help.Zip
The built in Parameter Form enables the user to specify parameters for a query, just before report execution. Parameters provide the ultimate in flexibility when running queries. Unlimited parameters can be defined. Any parameter can be used in, a Query, Report or both. Any parameter added to a Query or Report will be available in the Parameter Form.
Enables the user to create, edit, and implement parameters, whether they are used in a Query or Report. Parameter values can be assigned in a grid or a drop down list.
Maintains a history of each set of parameter values that are specified when the report is executed. Any set of parameters can be re-selected for the next report execution.
VisualRep has a full blown E-Mail engine including an address book to store all E-Mails for later use. It can have the following attachments: HTML, Word, XML, Text, Excel, PDF and dbf file. All of the above outputs could be E-Mailed as a bulk E-Mail or just several of them. Powerful Expression Builder Enables the user to create calculated field expression, and reuse those expressions in any project.
Enables the user to create calculated field expression, and reuse those expressions in any project.
It is possible to define the number of rows for the detail band of reports. VisualRep will reduce the font size by up to 6 points if needed. It has the capability to re-arrange fields vertically if no room exists in one row within the report. In this case VisualRep creates as many rows of fields as needed or will attempt to fit all of the fields within the number of rows selected by the user. If the field is too long it will be automatically wrapped to the next line.
Can be directed to a Printer, Microsoft Word file, Microsoft Excel file, PDF file, HTML file, Text file, and DBF file. It has a built in E-Mail engine and the Report can be E-Mailed to an individual or group in any of these formats. A query could also be directed to an XML stream and can be sent via E-Mail. Can be Called from Anywhere. For Visual FoxPro programmers, VisualRep can provide services such as calling reports from anywhere in your application without exposing the user to the VisualRep Dialogs, Forms and Wizards. The report can run by simply passing the report name (ID) to VisualRep programmatically. For example, it can be called directly from a "Report" button on a data entry form or a menu option.
For Visual FoxPro programmers, VisualRep can provide services such as calling reports from anywhere in your application without exposing the user to the VisualRep Dialogs, Forms and Wizards. The report can run by simply passing the report name (ID) to VisualRep programmatically. For example, it can be called directly from a "Report" button on a data entry form or a menu option.
In VisualRep you may select any aggregate functions just by clicking the Sum button. For instance, an Amount field may have the SUM() function wrapped around it to sum up the expenditures against a grouped account number. Other aggregate functions are provided as well such as Min(), Max(), Avg() and Count(). No code is needed in order to use these functions.
The security feature in VisualRep can be turned off or on for the VPM framework within the configuration form. Any feature in the configuration form can be also manipulated programmatically.
With multilingual VisualRep, your reports and queries can run in more than one language with no programming required by you. Clearly, VisualRep is now the premier query and reporting tool for Visual FoxPro and clients servers.
Enables the user to create a Data Source Name for a particular database such as: MS-Access, MS-SQL, Oracle. etc..It is a step by step Wizard and the user does not need an administrator to set up a connection in Operating System (OS).