Translate

Wednesday, April 24, 2013

Membangun Report dari database



Building Custom Reports from your Database
If your data is stored in MySQL, SQL Server, SQLite, Oracle or PostgreSQL database and you need a tool to help you build custom reports and turn data into useful information then Navicat Report Builder is the best choice for you.

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.