CN111178023A - Visual self-defined report design system - Google Patents
Visual self-defined report design system Download PDFInfo
- Publication number
- CN111178023A CN111178023A CN201911398416.2A CN201911398416A CN111178023A CN 111178023 A CN111178023 A CN 111178023A CN 201911398416 A CN201911398416 A CN 201911398416A CN 111178023 A CN111178023 A CN 111178023A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- report
- layer
- design
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A visual self-defined report design system comprises a data physical layer, a working directory configuration layer, a logic data layer, a design processing layer, a chart combination layer and a report display layer; the data physical layer comprises a database, a WEB server, a program module, a text module and a data table library; the working directory configuration layer comprises a manufacturing environment module and a design module; the logical data layer comprises a report data set and a data binding module; the design processing layer comprises a parameter design module, a data filtering module, a style setting module, a condition display module and an operation design module; the chart binding layer comprises a chart type module and a chart data module; the report display layer comprises a report display layer, a form input module and a printing output layer. The invention fully meets the requirements of report design and report development under the platforms of HTML5/WinForm/ASP.
Description
Technical Field
The invention relates to the field of self-defined report design, in particular to a visual self-defined report design system.
Background
In the development of the management information system, the design of the report forms is indispensable and sometimes even a key factor for determining the success or failure of the application information system. Because one of the greatest benefits of people using the management information system for daily business processing is that various business reports and statistical reports can be generated quickly, the manual data processing is often a heavy workload and sometimes even a quite complicated task.
In the development practice of enterprise-level management information systems, the opportunities that the business logic of the main body is found to be changed greatly are not too much, because the user generally knows the daily business logic of the user, however, the requirements of the user on the query and the report are changed frequently. Under the condition of a long project development period, the fact that events which cannot meet the requirements and cannot be disputed during project delivery are frequently found according to query or report requirements determined in the initial period of project delivery. From the perspective of a developer, the requirement changes, and even the workload of report programming is often very huge and energy-consuming, especially when the system development is performed by using an integrated report development environment, the change of one report often needs to recompile the whole application system, and even repackage and reissue the whole application system. From the perspective of users, along with the continuous change of transaction environment, even if the main service is not changed, it is quite common to add some query items in the query and statistical report, and this flexibility should be provided by our information system, which forces people to find a report control that can be independent from the application system.
The prior art group has the following disadvantages:
1. in the prior art, data query statistics and SQL optimization bring about very large performance loss and resistance, a service system cannot see the data volume when the data volume is not large, once a data service table is large to a certain degree, a performance bottleneck occurs, and the complex entity relationship, service mode and design mode of the system cannot be supported from the perspective of functional characteristics;
2. the integrated report plug-in is tightly combined with a used platform, and due to the change of one report, the whole application system may need to be edited again, or even the whole application system needs to be packaged again and released again.
3. The control-type report plug-in visualization aspect is not necessarily provided, and even if provided, the design environment needs to be started additionally and the design result is provided to the application program in a template form for access. Such templates must be specified in advance for deposit into a particular access path, and once the template file name path changes, the application may therefore be in error.
4. The OLE type must install corresponding editing software, and the general program allows low efficiency, that is, the output report generally needs to provide a template file for it, thereby affecting the robustness of the application program.
5. The service data is too large, and the performance bottleneck occurs in the logic complex situation.
Disclosure of Invention
Objects of the invention
In order to solve the technical problems in the background art, the invention provides a visual self-defined report design system.
(II) technical scheme
The invention provides a visual self-defined report design system, which comprises a data physical layer, a working directory configuration layer, a logic data layer, a design processing layer, a chart combination layer and a report display layer, wherein the data physical layer is used for storing a data item;
the data physical layer comprises a database, a WEB server, a program module, a text module and a data table library; the working directory configuration layer comprises a manufacturing environment module and a design module; the data physical layer is in data transfer connection with the working directory configuration layer and is used for establishing a system working environment;
the logical data layer comprises a report data set and a data binding module; the design processing layer comprises a parameter design module, a data filtering module, a style setting module, a condition display module and an operation design module; the working directory configuration layer is in data transmission connection with the report data set, the report data set is in data transmission connection with the data binding module, and the data binding module is in data transmission connection with the design processing layer;
the chart binding layer comprises a chart type module and a chart data module; the chart combining layer is in transmission connection with the data of the design processing layer and is used for classifying and counting the data sent by the design processing layer;
the report display layer is in data connection with the chart combination layer; the report display layer comprises a report display layer, a form input module and a printing output layer; the report display layer is used for displaying reports; the form input module is used for inputting and transmitting data; and the printing output layer is used for printing the data.
Preferably, the system operation comprises the steps of:
s1, creating a self-defined report template, wherein the report name is used for identifying the template, the template code is defined, and data is dynamically injected after a data source is specified;
s2, SQL analysis: the data types are divided into two types, namely a database table and dynamic SOL; the database table is used as a data source, the data source is selected as a platform data source, the database table corresponding to the data column is selected, the database table is analyzed, and a field list after the database table is analyzed; the dynamic SQL is used as a main key as a query condition, a value is obtained from a parameter id in the request, and the obtaining method is in a format of "$ { id }"; the dynamic SQL takes id as a parameter, and the system automatically analyzes a parameter area and a field area and queries the parameter area; the system is used for defining query parameters, query cases and supporting deletion and addition;
s3, online configuration generation report template:
selecting a data source and a template style: generating a form format, wherein the main data source is not empty; and (3) encoding: including the y-axis text: corresponding to y-axis text, x-axis data: and querying SQL: comprises an SQL query statement; wherein, the label of 'operatestame }' in the sql statement is used for enhancing the query and is finally replaced by 'operatestame ═ value of corresponding query condition on the page' }; and (4) expanding JS: js is used for controlling whether page detail data are displayed and summarized or not, the method is indicated as a fixed writing method, and the return value is a column name needing to be summarized; field name: the field name corresponding to the sql query result is a tag name and is used as a query condition; field text: corresponding to the detailed data column name; sorting: the field display order; the field type: the date is used as a search condition, and the search box has a date control; and (3) query mode: single condition queries and range queries; label name: data of the same label name can be displayed in one label; if only one or both of the labels are empty, the label will not be displayed in the chart.
Preferably, in S2, the operator deletes unnecessary fields and adds text notes to the fields.
Preferably, in S3, the unit data on the x-axis includes a field name and an array object; the data set is composed of a plurality of unit data, and the format of the data set is as follows:
[‘xdata1’,‘xdata2’,‘xdata3’]。
the invention comprises the following steps: the method can comprehensively meet the requirements of report design and report development under the platforms such as HTML5/WinForm/ASP.
Drawings
FIG. 1 is an overall schematic diagram of a visual custom report design system according to the present invention.
FIG. 2 is a detailed schematic diagram of a visual custom report design system according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings in conjunction with the following detailed description. It should be understood that the description is intended to be exemplary only, and is not intended to limit the scope of the present invention. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present invention.
As shown in fig. 1-2, the visual custom report design system provided by the present invention includes a data physical layer, a working directory configuration layer, a logical data layer, a design processing layer, a chart binding layer, and a report presentation layer;
the data physical layer comprises a database, a WEB server, a program module, a text module and a data table library; the working directory configuration layer comprises a manufacturing environment module and a design module; the data physical layer is in data transfer connection with the working directory configuration layer and is used for establishing a system working environment;
the logical data layer comprises a report data set and a data binding module; the design processing layer comprises a parameter design module, a data filtering module, a style setting module, a condition display module and an operation design module; the working directory configuration layer is in data transmission connection with the report data set, the report data set is in data transmission connection with the data binding module, and the data binding module is in data transmission connection with the design processing layer;
the chart binding layer comprises a chart type module and a chart data module; the chart combining layer is in transmission connection with the data of the design processing layer and is used for classifying and counting the data sent by the design processing layer;
the report display layer is in data connection with the chart combination layer; the report display layer comprises a report display layer, a form input module and a printing output layer; the report display layer is used for displaying reports; the form input module is used for inputting and transmitting data; and the printing output layer is used for printing the data.
In an alternative embodiment, the system operation includes the steps of:
s1, creating a self-defined report template, wherein the report name is used for identifying the template, the template code is defined, and data is dynamically injected after a data source is specified;
s2, SQL analysis: the data types are divided into two types, namely a database table and dynamic SOL; the database table is used as a data source, the data source is selected as a platform data source, the database table corresponding to the data column is selected, the database table is analyzed, and a field list after the database table is analyzed; the dynamic SQL is used as a main key as a query condition, a value is obtained from a parameter id in the request, and the obtaining method is in a format of "$ { id }"; the dynamic SQL takes id as a parameter, and the system automatically analyzes a parameter area and a field area and queries the parameter area; the system is used for defining query parameters, query cases and supporting deletion and addition;
s3, online configuration generation report template:
selecting a data source and a template style: generating a form format, wherein the main data source is not empty; and (3) encoding: including the y-axis text: corresponding to y-axis text, x-axis data: and querying SQL: comprises an SQL query statement; wherein, the label of 'operatestame }' in the sql statement is used for enhancing the query and is finally replaced by 'operatestame ═ value of corresponding query condition on the page' }; and (4) expanding JS: js is used for controlling whether page detail data are displayed and summarized or not, the method is indicated as a fixed writing method, and the return value is a column name needing to be summarized; field name: the field name corresponding to the sql query result is a tag name and is used as a query condition; field text: corresponding to the detailed data column name; sorting: the field display order; the field type: the date is used as a search condition, and the search box has a date control; and (3) query mode: single condition queries and range queries; label name: data of the same label name can be displayed in one label; if only one or both of the labels are empty, the label will not be displayed in the chart.
In an alternative embodiment, at S2, the operator deletes the unwanted fields and adds a text note to the fields.
In an alternative embodiment, in S3, the unit data on the x-axis includes a field name and an array object; the data set is composed of a plurality of unit data, and the format of the data set is as follows:
[‘xdata1’,‘xdata2’,‘xdata3’]。
the invention fully meets the requirements of report design and report development under the platforms of HTML5/WinForm/ASP.
In the invention, a very simple and completely new report design mode is adopted, the ActiveReports report designer drags and drops the report control from the tool box to the design interface in a dragging mode, a single mouse can bind data, and the report running result is grasped in real time through a preview function. The method provides Web and desktop end report designers ActiveReports for users, allows embedding of a final user report designer in a desktop or Web application, enables users to create reports by themselves, and can modify existing report titles, controls and formulas.
In the invention, few ActiveReports which are perfectly integrated with the Visual Studio are adopted as the report tool for directly integrating the report designer into the Visual Studio, and the loading items of the report tool comprise a tool box and an attribute window, thereby providing familiar and intuitive report design experience for people in the most popular IDE. ActiveReports have a lightweight but powerful Web-side online report designer built in. Only a few lines of code are needed to easily embed the code into websites and applications, and design, create and modify reports in the B/S architecture. Besides a visual design interface, Activereports also support the report development by using codes, and the runtime behaviors of each component are changed through API (application programming interface), so that an event-based dynamic interactive report is realized. Report viewers based on JavaScript, HTML5, WinForm, asp.
The method and the device have rich data visualization modes, are used for showing and analyzing common visualization scenes in report solutions, and can help users understand business data in a visual and concise mode, so that decision basis is provided. The report control provides diversified data interactive analysis capability, can clearly analyze the business development trend, can operate report data in an interactive mode to perform deep and thorough business analysis, and supports multiple data interactive modes.
The invention supports various development platforms and terminals, and the report engine and the report template are irrelevant to the development platforms and the operation equipment, so that the report template can be directly used in the HTML \ HTML5\ WinForm \ ASP.NET \ WPF \ JSP \ PHP \ node.js platform without any modification. Meanwhile, the ActiveReports report viewer provides the capability of viewing reports in the browser and the mobile terminal device.
Meanwhile, the report engine and the report template are irrelevant to the development platform and the running equipment, so that the report template can be directly used in an HTML \ HTML5\ WinForm \ ASP.NET \ ASP.NETMVC \ WPF \ JSP \ PHP \ node.js platform without any modification, wherein the Activereports report viewer provides the capability of viewing the report in a browser and mobile terminal equipment.
The invention provides a plurality of tools for report design, such as VSDesigner, Visual Studio loading item, independent desktop end designer and online report designer. The report design tools can be embedded into an application system of your, and provide report design functions for your end user.
It should be noted that, by using the ActiveReports report designer, a user can easily design various types of reports such as Excel forms, Word documents, Chart charts, dashboards and the like, and data is presented to an end user in a rich and flexible visualization manner. Meanwhile, the Activereports report control provides strong report interactive analysis capabilities such as data screening, sorting, drilling, expression skipping and the like for the end user during operation, and report requirements of the user in different scenes can be met without modifying codes, so that development efficiency is improved, and project delivery is accelerated.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explaining the principles of the invention and are not to be construed as limiting the invention. Therefore, any modification, equivalent replacement, improvement and the like made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. Further, it is intended that the appended claims cover all such variations and modifications as fall within the scope and boundaries of the appended claims or the equivalents of such scope and boundaries.
Claims (4)
1. A visual self-defined report design system is characterized by comprising a data physical layer, a working directory configuration layer, a logic data layer, a design processing layer, a chart combination layer and a report display layer;
the data physical layer comprises a database, a WEB server, a program module, a text module and a data table library; the working directory configuration layer comprises a manufacturing environment module and a design module; the data physical layer is in data transfer connection with the working directory configuration layer and is used for establishing a system working environment;
the logical data layer comprises a report data set and a data binding module; the design processing layer comprises a parameter design module, a data filtering module, a style setting module, a condition display module and an operation design module; the working directory configuration layer is in data transmission connection with the report data set, the report data set is in data transmission connection with the data binding module, and the data binding module is in data transmission connection with the design processing layer;
the chart binding layer comprises a chart type module and a chart data module; the chart combining layer is in transmission connection with the data of the design processing layer and is used for classifying and counting the data sent by the design processing layer;
the report display layer is in data connection with the chart combination layer; the report display layer comprises a report display layer, a form input module and a printing output layer; the report display layer is used for displaying reports; the form input module is used for inputting and transmitting data; and the printing output layer is used for printing the data.
2. The visual custom report design system according to claim 1, characterized in that the system work comprises the following steps:
s1, creating a self-defined report template, wherein the report name is used for identifying the template, the template code is defined, and data is dynamically injected after a data source is specified;
s2, SQL analysis: the data types are divided into two types, namely a database table and dynamic SOL; the database table is used as a data source, the data source is selected as a platform data source, the database table corresponding to the data column is selected, the database table is analyzed, and a field list after the database table is analyzed; the dynamic SQL is used as a main key as a query condition, a value is obtained from a parameter id in the request, and the obtaining method is in a format of "$ { id }"; the dynamic SQL takes id as a parameter, and the system automatically analyzes a parameter area and a field area and queries the parameter area; the system is used for defining query parameters, query cases and supporting deletion and addition;
s3, online configuration generation report template:
selecting a data source and a template style: generating a form format, wherein the main data source is not empty; and (3) encoding: including the y-axis text: corresponding to y-axis text, x-axis data: and querying SQL: comprises an SQL query statement; wherein, the label of 'operatestame }' in the sql statement is used for enhancing the query and is finally replaced by 'operatestame ═ value of corresponding query condition on the page' }; and (4) expanding JS: js is used for controlling whether page detail data are displayed and summarized or not, the method is indicated as a fixed writing method, and the return value is a column name needing to be summarized; field name: the field name corresponding to the sql query result is a tag name and is used as a query condition; field text: corresponding to the detailed data column name; sorting: the field display order; the field type: the date is used as a search condition, and the search box has a date control; and (3) query mode: single condition queries and range queries; label name: data of the same label name can be displayed in one label; if only one or both of the labels are empty, the label will not be displayed in the chart.
3. The visual custom report design system according to claim 2, characterized in that in S2, the operator deletes the unnecessary fields and adds the text notes to the fields.
4. The visual custom report design system according to claim 2, wherein in S3, the unit data on the x-axis includes a field name and an array object;
the data set is composed of a plurality of unit data, and the format of the data set is as follows:
[‘xdata1’,‘xdata2’,‘xdata3’]。
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911398416.2A CN111178023A (en) | 2019-12-30 | 2019-12-30 | Visual self-defined report design system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911398416.2A CN111178023A (en) | 2019-12-30 | 2019-12-30 | Visual self-defined report design system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111178023A true CN111178023A (en) | 2020-05-19 |
Family
ID=70655889
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911398416.2A Pending CN111178023A (en) | 2019-12-30 | 2019-12-30 | Visual self-defined report design system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111178023A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111625219A (en) * | 2020-05-22 | 2020-09-04 | 杭州指令集智能科技有限公司 | BO component processing method, device and equipment |
| CN111723129A (en) * | 2020-06-24 | 2020-09-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
| CN111881192A (en) * | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN111930811A (en) * | 2020-10-09 | 2020-11-13 | 绿漫科技有限公司 | Lightweight dynamic data statistical system based on MyBatis |
| CN112232041A (en) * | 2020-07-31 | 2021-01-15 | 青岛百洋智能科技股份有限公司 | Automatic chart generation system and method |
| CN112540991A (en) * | 2020-12-08 | 2021-03-23 | 杭州讯酷科技有限公司 | System logic construction method based on data table relation |
| CN113672672A (en) * | 2021-06-03 | 2021-11-19 | 厦门锐特信息技术有限公司 | Cloud report market system suitable for logistics supply chain business |
| CN113885859A (en) * | 2021-10-20 | 2022-01-04 | 西安热工研究院有限公司 | Low-code report implementation method based on SIS production operation data |
| CN114611476A (en) * | 2022-01-26 | 2022-06-10 | 博思数采科技发展有限公司 | Form content structured processing method and device |
| CN114780084A (en) * | 2022-06-22 | 2022-07-22 | 成都七柱智慧科技有限公司 | Configuration software for collaborative design of multiple types of interactive interfaces |
| CN117032602A (en) * | 2023-10-10 | 2023-11-10 | 海通安恒科技股份有限公司 | Printing method and system for rapidly realizing label field mapping and label rule configuration |
-
2019
- 2019-12-30 CN CN201911398416.2A patent/CN111178023A/en active Pending
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111625219A (en) * | 2020-05-22 | 2020-09-04 | 杭州指令集智能科技有限公司 | BO component processing method, device and equipment |
| CN111723129A (en) * | 2020-06-24 | 2020-09-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
| CN111723129B (en) * | 2020-06-24 | 2024-03-29 | 中国工商银行股份有限公司 | Report generation method, report generation device and electronic equipment |
| CN112232041A (en) * | 2020-07-31 | 2021-01-15 | 青岛百洋智能科技股份有限公司 | Automatic chart generation system and method |
| CN111881192B (en) * | 2020-08-03 | 2024-01-30 | 浪潮云信息技术股份公司 | Method, system, electronic equipment and storage medium for generating visual configuration report |
| CN111881192A (en) * | 2020-08-03 | 2020-11-03 | 浪潮云信息技术股份公司 | Method and system for generating visual configuration report, electronic equipment and storage medium |
| CN111930811A (en) * | 2020-10-09 | 2020-11-13 | 绿漫科技有限公司 | Lightweight dynamic data statistical system based on MyBatis |
| CN112540991A (en) * | 2020-12-08 | 2021-03-23 | 杭州讯酷科技有限公司 | System logic construction method based on data table relation |
| CN112540991B (en) * | 2020-12-08 | 2022-09-30 | 杭州讯酷科技有限公司 | System logic construction method based on data table relation |
| CN113672672A (en) * | 2021-06-03 | 2021-11-19 | 厦门锐特信息技术有限公司 | Cloud report market system suitable for logistics supply chain business |
| CN113885859A (en) * | 2021-10-20 | 2022-01-04 | 西安热工研究院有限公司 | Low-code report implementation method based on SIS production operation data |
| CN113885859B (en) * | 2021-10-20 | 2024-02-23 | 西安热工研究院有限公司 | Low-code report implementation method based on SIS production operation data |
| CN114611476A (en) * | 2022-01-26 | 2022-06-10 | 博思数采科技发展有限公司 | Form content structured processing method and device |
| CN114780084B (en) * | 2022-06-22 | 2022-08-30 | 成都七柱智慧科技有限公司 | Configuration system for collaborative multi-type interactive interface design |
| CN114780084A (en) * | 2022-06-22 | 2022-07-22 | 成都七柱智慧科技有限公司 | Configuration software for collaborative design of multiple types of interactive interfaces |
| CN117032602B (en) * | 2023-10-10 | 2024-01-26 | 海通安恒科技股份有限公司 | Printing method and system for rapidly realizing label field mapping and label rule configuration |
| CN117032602A (en) * | 2023-10-10 | 2023-11-10 | 海通安恒科技股份有限公司 | Printing method and system for rapidly realizing label field mapping and label rule configuration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111178023A (en) | Visual self-defined report design system | |
| US10222951B2 (en) | Modeling system for graphic user interface | |
| US11620117B2 (en) | Systems and methods for code clustering analysis and transformation | |
| CN109062567B (en) | B/S structure-based information management system rapid development platform | |
| JP6487282B2 (en) | Method for developing application to be executed in workflow management system, and apparatus for supporting generation of application to be executed in workflow management system | |
| US7366723B2 (en) | Visual query modeling for configurable patterns | |
| US7953767B2 (en) | Developing applications using configurable patterns | |
| US20050065951A1 (en) | Visualization of commonalities in data from different sources | |
| US20070136362A1 (en) | Systems and methods for report design and generation | |
| US8126937B2 (en) | Visual database modeling | |
| US8495510B2 (en) | System and method for managing browser extensions | |
| US20060225094A1 (en) | Enabling customization and personalization of views in content aggregation frameworks | |
| US20080148231A1 (en) | Computer-implemented system for analysis, administration, control, management and monitoring of a complex hardware/software architecture | |
| EP1830275A1 (en) | Information distribution system | |
| US9229920B1 (en) | Compound undo/redo manager for mixed model edits | |
| CN113535165A (en) | Interface generation method and device, electronic equipment and computer readable storage medium | |
| CN103034696B (en) | Data viewer manages | |
| US7409642B2 (en) | Method and system for applying user interface elements to data | |
| WO2006120926A1 (en) | Input form design device and input form design method | |
| US20080155501A1 (en) | System and Method for Revising an Electronic Draft | |
| WO2006051721A1 (en) | Document processing device, and document processing method | |
| KR100261265B1 (en) | Apparatus for making a web document and method of operating it | |
| KR20130051594A (en) | Web-based software generation method and apparatus | |
| CN116088817B (en) | Panorama service view designer and device based on mesh topological structure | |
| CN115408422A (en) | Data template generation method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |