Building Custom Reports from your Database
With Navicat Report Builder data in your databases can be transformed into various reports such as Invoices, Sales Statistics, Order Reports, Point of Sales, Form Letters, Mailing Labels, etc.
|
Navicat Report Builder
Navicat Report Builder is included in the Navicat Windows Enterprise
Edition and helps to deliver data in your MySQL, SQL Server, SQLite,
Oracle or PostgreSQL database in a presentable manner, turning it into
valuable information. Various kinds of Reports can be built easily
without any additional efforts. Schedulers can also be set to deliver
Reports automatically. Bundled with Report Viewer, it allows multiple
users to access your report anytime and at any location.Existing data can be imported and used for building Reports from various data sources such as MS Excel, MS Access, Text File, XML, Paradox, Dbase, Lotus 123, and ODBC.  |
|
Familiarize yourself with Navicat Report Builder:
 The Report Designer, pictured below contains three workspaces: Data, Design, and Preview.
When first displayed, the Report Designer defaults to the design
workspace where you will spend the majority of your report building
time.
|
 To build a Report, Basically, there are 3 basic steps: 1) Link your Report to your data 2) Design the Layout for your Report 3) Preview and Export your Report |
|
Linking your Data to the Report
 The Data tab allows you to create dataviews which are used to supply data to your report. Dataviews can be created via the Query Wizard or Query Designer.
Both of these visual tools allow you to select necessary tables and
fields, create search criteria, sort orders, etc for dataviews.
|
Query Wizard provides a step-by-step guide that helps you to create the
basic dataview. Afterwards, you can use the Query Designer to modify
the dataview.
|
 You
can enter more calculations and criteria in the Query Designer to build
complex reports (e.g. search reports). The SQL tab shows the SQL
statement for retrieving the data from the database.
|
|
Designing the Layout of your Report
The Design tab is the main session for designing and organizing the
report layout. It contains a Report Wizard and some sample reports that
allow you to quickly create an entire report layout. This is great for
generating a simple report.
|
If you want to design your own layout, you can simply drag and drop the
data from the data tree and use the toolbar to add different
components.
|
|
Preview and Exporting your Report
 The Preview tab enables you to preview and navigate the report output. You can also perform a search to filter the data.
|
After confirming the report output, you can print/export the report to
PDF, MS Excel, etc file formats. Together with the Navicat Schedule
feature, you can set a schedule to print the report and send the
exported file to your email automatically.
|
|
Sharing of Reports among users
Navicat Report Viewer allows you to view reports designed by Navicat
Report Builder. You can share reports with someone who does not have
Navicat running on their computer but has Navicat Report Viewer
installed. It highly increases the flexibility and convenience for
viewing reports.
Simply create a connection to your server and place the report files
(.rtm) within the database subfolder under the Report Location. |
Licensing
Navicat Report Builder is a feature in Navicat Enterprise Edition on Windows platform. For every license of Navicat Enterprise Edition, a license of Report Viewer is bundled to allow sharing of reports between users.
Navicat provides database administration solutions to individuals and organizations worldwide. Over 50,000 users have become our happy customers.Geared for individual web developers, small businesses and enterprises, Navicat provides users with everything they need for today’s database administration and report generation demands.
Contact kami di 62-21-3907418 untuk detail kebutuhan Anda.
