The Farber Consulting Group, Inc.
Marlboro, NJ 07746, USA
Phone: 732-536-4765
VisualRep
Visual Report Engine Pro
Get the VisualRep Benefits document (PDF)
Saves Time
Creates Relations on the fly
Wizard Driven
Easy to Integrate
Project Driven
Built in Framework
Automatic Update
Automatic Report Generation
Powerful Parameters’
Form
Parameter Management Facility
Audit Trail Capability
E-Mail your report the
way you want it
Powerful Expression Builder
Fit To Page Capability
Output Type
Can
Be Called from Anywhere
Use Aggregate Functions
Fully Configurable
Data Source Name(DSN) Wizard
Multi Lingual capability
Learning Tool
The VisualRep is a query and reporting tool for developers and end users alike. It is TWO products in ONE:
- Framework for developers allowing them to easily run Queries and Reports.
- A stand alone application which can be run by the end user from the computer desktop, or within an application.
It offers a broad range of features, including access to the most popular databases such as Oracle, SQL Server, Visual FoxPro, and MS Access. VisualRep reads all data dictionary metadata directly from the specified Database, such as tables, relations, fields name, field 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.
Saves Time
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.
Creates Relations on the fly
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.
Wizard Driven
VisualRep’s
powerful Wizards will guide you step by step through creating a report or
a query. There are three distinct functions :
- Report Set Creation
- Query Builder
- Report Generator.
Each function is handled by its own Wizard.
Easy to
Integrate
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.
Ease of Use
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.
Project Driven
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.
Built in Framework
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.
Automatic Update
If new tables were added within a
database engine, say MS SQL 7, VisualRep will show all available tables
that were entered within MS – SQL7. 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.
Automatic
Report Generation
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:
http://www.dfarber.com/VRep/VRep_Help.CHM
Powerful Parameters’ Form
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.
Parameter Management
Facility
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.
Audit Trail Capability
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.
E-Mail your report the way you want it.
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 attachemenst: 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.
Fit To Page
Capability
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.
Output Type
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.
Use Aggregate Functions
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.
Fully
Configurable
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.
Data Source Name(DSN) Wizard
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 so a
user doesn’t need an administrator to set up a connection in
Operating System (OS).
What Multilingual in
VisualRep Means To You
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.
- Application users can change languages on the fly.
- Each application user can run reports and queries in her own language.
- VisualRep even handles languages written from right to left (Hebrew, Arabic, etc.).
- VisualRep handles double-byte languages.
- Free Portuguese, Romanian and Spanish translations are included for standard text provided by VisualRep. Additional free language translations will be provided later. You can, of course, enter your own translations for any language and any text.
- Changing a language in your application will automatically change the language used for VisualRep reports and queries. You can easily implement this functionality in in any application that is using VisualRep.
- Multilingual Manager: VisualRep's new Multilingual Manager is a user-friendly interface that allows you to easily set up and manage the languages your reports and queries will use. To include a new language, for your own application.
- No additional cost to you
Learning Tool
A user
will learn how the SQL script is created and how reports are handled with
each data source. The SQL Statement can be reviewed at any time
while running the table and field selection Wizard