Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to do navicat reports, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

The Navicat report creation tool turns raw data into useful information. If the data is stored in a MySQL, Oracle, PostgreSQL, SQLite, SQL Server or MariaDB database, it can be converted to different custom reports, such as invoices, sales statistics, order reports, point of sale, form letters, mailing labels, etc. Report Builder helps users and organizations run more smoothly and efficiently.

Navicat report creation tool

0

Report creation tools are included in Navicat Enterprise Edition and Navicat Premium to convert raw data from MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, or SQLite databases into easy-to-understand and valuable information. Without extra effort, you can easily create various reports, or you can set up a schedule for automatic delivery of reports. Work with Report Viewer to allow multiple users to access the report anytime, anywhere. In addition, support for importing existing data makes it easy to create reports from data sources such as MS Excel, MS Access, text files (Text File), XML, Paradox, Dbase, Lotus 123 and ODBC.

Navicat has three main steps to create a report:

1. Connect data to the report

The data tab allows you to view creation data, provide data to the report, and create a data view through the query Wizard or query designer. Use these two visualization tools to select the data to view the desired tables, fields, create search criteria, sort, and so on.

The query wizard visually creates and edits basic data through a step-by-step wizard.

You can enter more calculations and guidelines into query designer to create complex reports (such as search reports), and the SQL tab displays SQL statements that get data from the database.

two。 Design report layout

The Design tab is the main stage of designing and organizing the report layout. It contains the report wizard and some sample reports, which can quickly create the layout of the whole report, which is the best way to generate a simple report.

Design your own layout, simply drag and drop data from the data tree, and use toolbars to add different components.

3. Preview and export reports

Preview tab: preview and output preview report. If you create a search report, you can run the search to filter the data.

After confirming the report output, the user can print or export the report in PDF, MS Excel, and so on. If used with the Navicat scheduling feature, you can set up automatic report printing and transfer the exported file to a specified e-mail message.

4. Shared report

Navicat Report Viewer can browse reports designed by the Navicat report creation tool and share reports with users who install Navicat Report Viewer. Connect to the server and place the report file (.rtm) in the database subfolder in the report location, which greatly increases the flexibility of viewing the report.

License: the Navicat report creation tool is a feature in the Windows platform Navicat Enterprise Edition or Navicat Premium. Each Navicat Enterprise or Navicat Premium license comes with a license for Report Viewer to share reports among users.

Provide database management solutions for individuals and global organizations. At present, it has more than 130000 users. Navicat provides database management and report creation for personal website developers and small and medium-sized enterprises.

Thank you for reading this article carefully. I hope the article "how to make navicat report" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.