dbForge Studio for MySQL offers the possibility of creating reports implemented in the well-known and user-friendly interface. With dbForge Studio, the routine of report creating is simplified to several clicks - that means you won’t have to spend a lot of time and efforts for report producing any more.
Data report is a formatted representation of data that can be displayed on a screen, printed or saved to a file. Reports allow getting the needed data from a database and representing it in a human-readable form, and also providing a lot of capabilities for data generalization and analyzing.
When printing tables and query results data is presented in nearly the same form as it is stored. So, it is often necessary to present it in the form of a report that has traditional appearance and is easy to read. Such reports include all information from a table or returned by a query, but also contain headers, are repaginated etc.
Of course, reports are used in bookkeeping. In fact, one can not imagine bookkeeping without reports. So, accountants usually need a report generator to automate the process of report creation and avoid any mistakes.
dbForge Studio provides easy-to-use and fast solution for this goal which includes fully-functional report designer, Data Report Wizard for creating different types of reports, and a lot of report examples.
Below is a list of the main features for report creation in dbForge Studio:
Binding Report to Data - it is possible to create a data source, fill it with data and supply it to a report.
Custom Query - you can upload an existing query or create a new one to use it in a report.
Relations Editor - a comprehensive relations editor allows you to create, change, and remove relations between tables and/or views, and queries.
Parameterized Queries - support for parameterized queries with the possibility to edit parameters in Parameter Editor. This editor allows you to add and remove parameters and edit their properties.
Easy Data Source List Population - data source list can be populated in many ways. To add a data source you can drag’n’drop tables or views from the Database Explorer, use the dialog window for adding tables and/or views, or create a custom query.
Mail Merge - it is possible to insert a data field name in brackets right into controls’ text, and these fields will be populated from the specified data source when a document is created.
Data Filtering - data can be filtered at several levels data adapter, data set or data view levels.
Data Grouping - report bands serve for implementing grouping, making the process easier and faster.
Set of Controls - a wide range of available controls allows to display various kinds of information in a report.
Chart Control - a special control for adding charts to your report.
Enhanced RichText Control - it’s possible to load data from *.txt and *.rtf files.
Large Number of Band Types - 10 different band types to display controls on any part of any page.
Master-Detail Reports - master-detail reports can be created quickly and easily by editing relations between data tables.
Data Source - drag fields from the Data Source window and drop them onto the designer area to create controls which will be automatically bound to an appropriate field. Drop necessary fields onto already created controls to bind them to the fields.
Document Outline - shows the report structure and is used to navigate within a report.
Data Report Toolbar - a toolbar with a set of buttons to operate text options and to call report designer windows, also contains a button to call Data Report Wizard.
Toolbox - the window holding controls available in dbForge Studio data reports.
Event Support - allows to create event handlers at the Report, Band and even Control levels.
Advanced Styles - styles provide the possibility to control the look of your report. Styles can be applied conditionally to reflect certain states. dbForge Studio provides a convenient Style Editor.
Summary Support - to create a summary for textbox or table cell set only two properties - Summary position and Summary type.
In-Place Editing - possibility to change the text properties of controls (label, RichText,TableCell) using in-place editing. To use in-place editing, just double-click the needed control.
Wide Range of Exporting Formats - possibility to export report documents to different formats like PDF, HTML, MHT, RTF, TXT, CSV, and MS Excel. Also a report can be exported to an image file types, like BMP, EMF, GIF, JPEG, PNG, TIFF, WMF.
Save and Load Report Definitions - possibility to save and load report definitions.
Scripting - possibility to use C#, Visual Basic .NET and JScript .NET scripts in reports.
Watermarks - a report can contain a collection of watermarks for all or specified report pages.
Search in Preview - the possibility to call a search dialog in the preview mode to search a report for specific text.
Bookmarks - support for bookmarks makes your report easier to navigate. This structure can also be exported along with the report to PDF, HTML and MHT file formats.
Report Wizard - easy to use, convenient, yet powerful wizard to reduce the time you spend on customizing report.
Measurement - support for imperial (inches) and metric (centimeters) units of measurement. Use the ReportUnit property to set the measuring system for your report.