CN109829002A - A kind of complex report forms building system and construction method based on web - Google Patents
A kind of complex report forms building system and construction method based on web Download PDFInfo
- Publication number
- CN109829002A CN109829002A CN201811530730.7A CN201811530730A CN109829002A CN 109829002 A CN109829002 A CN 109829002A CN 201811530730 A CN201811530730 A CN 201811530730A CN 109829002 A CN109829002 A CN 109829002A
- Authority
- CN
- China
- Prior art keywords
- data
- report forms
- field
- complex report
- module
- 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
- 238000010276 construction Methods 0.000 title claims abstract description 17
- 238000001914 filtration Methods 0.000 claims abstract description 4
- 238000005259 measurement Methods 0.000 claims abstract description 4
- 238000006116 polymerization reaction Methods 0.000 claims description 6
- 230000001105 regulatory effect Effects 0.000 claims description 6
- 230000000712 assembly Effects 0.000 claims description 3
- 238000000429 assembly Methods 0.000 claims description 3
- 230000001747 exhibiting effect Effects 0.000 claims description 3
- 238000004458 analytical method Methods 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000976 ink Substances 0.000 description 1
- 238000000034 method Methods 0.000 description 1
Landscapes
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a kind of complex report forms building system and construction method based on web, comprising the following steps: obtain data and displaying needed for generating complex report forms in database；User pulls the field being concerned about to the allocation window of web terminal, obtains original complex report forms, the time and character string in the field are classified as the dimension of original complex report forms automatically, and the numeric type in the field is classified as the measurement of original complex report forms automatically；The original complex report forms are configured by the configuration component of web terminal, obtain output statistical chart and export complex report forms.Of the invention is directly edited by extracting the field being concerned about in database and passing through integrated configuration component in web terminal, greatly improves the working efficiency of statistics and analysis personnel, and can be with the complex report forms and statistical chart of real-time update and displaying editor；The configuration to complex report forms is realized by configuration components such as left association, upper association, displaying, filterings, more meets the needs of business analysis associated user.
Description
Technical field
The invention belongs to big data processing technology fields, and in particular to it is a kind of based on web complex report forms building system and
Construction method.
Background technique
It is frequently necessary to handle miscellaneous table, most of Table Design much information, and table in statistician
Structure can also be followed without rule, such report is referred to as complex report forms.
Traditional complex report forms processing uses excel tool more, but more polynary demand is unable to satisfy excel tool
Various usage scenarios, cause big inconvenience in some cases.
One, the data in report can not be write with a brush dipped in Chinese ink in real time, and excel can draw complicated and diversified complex report forms, but cannot root
According to the automatically updating data report in operation system database, updates be required to be manually operated every time；
Two, when there are more people simultaneously update or show report when, need Manual arranging to summarize data, can not real-time update extremely
Cloud；
Three, specific aim is not strong, and the exploitation of excel needs meet the needs of most users, and be used for business analysis or
Often make the editorial efficiency of professional low when the purposes such as statistics.
Summary of the invention
It is an object of the invention to: above-mentioned deficiency in the prior art is solved, the complex report forms building system based on web is provided
System and construction method, are directly realized by the editor to complex report forms by webpage, convenient and efficient.
To achieve the goals above, the technical solution adopted by the present invention are as follows:
A kind of complex report forms construction method based on web, comprising the following steps:
Step 1: data and displaying needed for generating complex report forms in database are obtained；
Step 2: user pulls the field being concerned about to the allocation window of web terminal, obtains original complex report forms, the field
In time and character string be classified as the dimensions of original complex report forms automatically, the numeric type in the field is classified as original multiple automatically
The measurement of miscellaneous report；
Step 3: configuring the original complex report forms by the configuration component of web terminal, obtain output statistical chart and
Export complex report forms.
Further, in above-mentioned step two, the extended mode of the field is laterally or longitudinally.
Further, configuration component includes: in above-mentioned steps three
Left associated component, for being associated the cell of certain column data and left column data field in order to the later period
Inquire data；
Upper associated component, for being associated certain row data and some dimension of top in order to later data inquiry；
Component exhibiting, for original complex report forms to be grouped displaying or detail displaying, the grouping displaying is according to number
According to types of polymerization data, the detail be shown as show total data；
Filter assemblies, for being filtered according to the numerical value of present field to the field, filter type includes being greater than, being small
In, be equal to, be more than or equal to or be less than or equal to；
Regulatory components, for editing to the data in the field for meeting filter condition, edit mode includes modified application
First lattice background, font color and/or retraction；
Formula component, for carrying out complicated calculations to the data in original complex report forms；
Component is hidden, for only display field without the particular content in display field；
Parameter component is used for calculated field.
Further, above-mentioned configuration component further includes format component, and the format component includes character string component sum number
Word component, the character string component is for several positions of data intercept and/or replacement data content from left to right, the number group
Part is used to change the display mode of data, and the display mode includes standard figures, percentage and thousand quartiles.
Further, above-mentioned regulatory components are also used to legacy data content in cell replacing with new text, number
Word or picture
A kind of complex report forms building system based on web, using the above-mentioned complex report forms construction method based on web, packet
It includes:
Data acquisition module, for obtaining data needed for generation complex report forms in database；
Web terminal, the web terminal include allocation window and configuration module；
Generation module, for generating output statistical chart and output complex report forms.
Further, above-mentioned configuration module includes
Left relating module, for being associated the cell of certain column data and left column data field in order to the later period
Inquire data；
Upper relating module, for being associated certain row data and some dimension of top in order to later data inquiry；
Display module, for original complex report forms to be grouped displaying or detail displaying, the grouping displaying is according to number
According to types of polymerization data, the detail be shown as show total data；
Filtering module, for being filtered according to the numerical value of present field to the field, filter type includes being greater than, being small
In, be equal to, be more than or equal to or be less than or equal to；
Condition module, for editing to the data in the field for meeting filter condition, edit mode includes modified application
First lattice background, font color and/or retraction；
Formula module, for carrying out complicated calculations to the data in original complex report forms；
Hidden module, for only display field without the particular content in display field；
Parameter module is used for calculated field.
Further, above-mentioned format module includes character string module and digital module, and the character string module is used for from a left side
Several positions and/or replacement data content to right data intercept, the digital module is used to change the display mode of data, described
Display mode includes standard figures, percentage and thousand quartiles.
By adopting the above-described technical solution, the beneficial effects of the present invention are:
Complex report forms based on web of the invention construct system and construction method by extracting the field being concerned about in database
And directly edited in web terminal by integrated configuration component, the working efficiency of statistics and analysis personnel is greatly improved, and
With real-time update and it can show the complex report forms and statistical chart edited.
The complex report forms building system based on web of the invention and construction method by it is left be associated with, it is upper be associated with, displaying, mistake
The configuration components such as filter realize the configuration to complex report forms, more meet the needs of business analysis associated user.
Detailed description of the invention
Fig. 1 is that the complex report forms of the invention based on web construct flow diagram.
Fig. 2 is that the complex report forms of the invention based on web construct system structure diagram.
Specific embodiment
Referring to attached drawing 1-2, specific description is done to embodiments of the present invention.
A kind of complex report forms construction method based on web, comprising the following steps:
Step 1: data and displaying needed for generating complex report forms in database are obtained；
Step 2: user pulls the field being concerned about to the allocation window of web terminal, obtains original complex report forms, the field
In time and character string be classified as the dimensions of original complex report forms automatically, the numeric type in the field is classified as original multiple automatically
The measurement of miscellaneous report；
Step 3: configuring the original complex report forms by the configuration component of web terminal, obtain output statistical chart and
Export complex report forms.
Further, in above-mentioned step two, the extended mode of the field is laterally or longitudinally.
Further, configuration component includes: in above-mentioned steps three
Left associated component, for being associated the cell of certain column data and left column data field in order to the later period
Inquire data；
Upper associated component, for being associated certain row data and some dimension of top in order to later data inquiry；
Component exhibiting, for original complex report forms to be grouped displaying or detail displaying, the grouping displaying is according to number
According to types of polymerization data, the detail be shown as show total data；
Filter assemblies, for being filtered according to the numerical value of present field to the field, filter type includes being greater than, being small
In, be equal to, be more than or equal to or be less than or equal to；
Regulatory components, for editing to the data in the field for meeting filter condition, edit mode includes modified application
First lattice background, font color and/or retraction；
Formula component, for carrying out complicated calculations to the data in original complex report forms；
Component is hidden, for only display field without the particular content in display field；
Parameter component is used for calculated field.
Further, above-mentioned configuration component further includes format component, and the format component includes character string component sum number
Word component, the character string component is for several positions of data intercept and/or replacement data content from left to right, the number group
Part is used to change the display mode of data, and the display mode includes standard figures, percentage and thousand quartiles.
Further, above-mentioned regulatory components are also used to legacy data content in cell replacing with new text, number
Word or picture
A kind of complex report forms building system based on web, using the above-mentioned complex report forms construction method based on web, packet
It includes:
Data acquisition module, for obtaining data needed for generation complex report forms in database；
Web terminal, the web terminal include allocation window and configuration module；
Generation module, for generating output statistical chart and output complex report forms.
Further, above-mentioned configuration module includes
Left relating module, for being associated the cell of certain column data and left column data field in order to the later period
Inquire data；
Upper relating module, for being associated certain row data and some dimension of top in order to later data inquiry；
Display module, for original complex report forms to be grouped displaying or detail displaying, the grouping displaying is according to number
According to types of polymerization data, the detail be shown as show total data；
Filtering module, for being filtered according to the numerical value of present field to the field, filter type includes being greater than, being small
In, be equal to, be more than or equal to or be less than or equal to；
Condition module, for editing to the data in the field for meeting filter condition, edit mode includes modified application
First lattice background, font color and/or retraction；
Formula module, for carrying out complicated calculations to the data in original complex report forms；
Hidden module, for only display field without the particular content in display field；
Parameter module is used for calculated field.
Further, above-mentioned format module includes character string module and digital module, and the character string module is used for from a left side
Several positions and/or replacement data content to right data intercept, the digital module is used to change the display mode of data, described
Display mode includes standard figures, percentage and thousand quartiles.
Claims (8)
1. a kind of complex report forms construction method based on web, it is characterised in that: the following steps are included:
Step 1: data and displaying needed for generating complex report forms in database are obtained；
Step 2: user pulls the field being concerned about to the allocation window of web terminal, original complex report forms is obtained, in the field
Time and character string are classified as the dimension of original complex report forms automatically, and the numeric type in the field is classified as original complicated report automatically
The measurement of table；
Step 3: configuring the original complex report forms by the configuration component of web terminal, obtains output statistical chart and output
Complex report forms.
2. the complex report forms construction method according to claim 1 based on web, it is characterised in that: in the step two,
The extended mode of the field is laterally or longitudinally.
3. the complex report forms construction method according to claim 2 based on web, it is characterised in that: match in the step 3
Setting component includes:
Left associated component, for being associated the cell of certain column data and left column data field in order to later period inquiry
Data；
Upper associated component, for being associated certain row data and some dimension of top in order to later data inquiry；
Component exhibiting, for original complex report forms to be grouped displaying or detail displaying, the grouping displaying is according to data
Types of polymerization data, the detail are shown as showing total data；
Filter assemblies, for being filtered according to the numerical value of present field to the field, filter type include be greater than, be less than, etc.
In, be more than or equal to or be less than or equal to；
Regulatory components, for editing to the data in the field for meeting filter condition, edit mode includes changing unit lattice
Background, font color and/or retraction；
Formula component, for carrying out complicated calculations to the data in original complex report forms；
Component is hidden, for only display field without the particular content in display field；
Parameter component is used for calculated field.
4. the complex report forms construction method according to claim 3 based on web, it is characterised in that: the configuration component
Further include format component, the format component includes character string component and digital assembly, the character string component be used for from a left side to
Several positions of right data intercept and/or replacement data content, the digital assembly is used to change the display mode of data, described aobvious
The mode of showing includes standard figures, percentage and thousand quartiles.
5. the complex report forms construction method according to claim 3 based on web, it is characterised in that: the regulatory components
It is also used to legacy data content in cell replacing with new text, number or picture.
6. a kind of complex report forms based on web construct system, using answering based on web of any of claims 1-5
Miscellaneous report construction method, characterized by comprising:
Data acquisition module, for obtaining data needed for generation complex report forms in database；
Web terminal, the web terminal include allocation window and configuration module；
Generation module, for generating output statistical chart and output complex report forms.
7. the complex report forms according to claim 6 based on web construct system, it is characterised in that: the configuration module
Including
Left relating module, for being associated the cell of certain column data and left column data field in order to later period inquiry
Data；
Upper relating module, for being associated certain row data and some dimension of top in order to later data inquiry；
Display module, for original complex report forms to be grouped displaying or detail displaying, the grouping displaying is according to data
Types of polymerization data, the detail are shown as showing total data；
Filtering module, for being filtered according to the numerical value of present field to the field, filter type include be greater than, be less than, etc.
In, be more than or equal to or be less than or equal to；
Condition module, for editing to the data in the field for meeting filter condition, edit mode includes changing unit lattice
Background, font color and/or retraction；
Formula module, for carrying out complicated calculations to the data in original complex report forms；
Hidden module, for only display field without the particular content in display field；
Parameter module is used for calculated field.
8. the complex report forms according to claim 7 based on web construct system, it is characterised in that: the configuration module
Further include format module, the format module includes character string module and digital module, the character string module be used for from a left side to
Several positions of right data intercept and/or replacement data content, the digital module is used to change the display mode of data, described aobvious
The mode of showing includes standard figures, percentage and thousand quartiles.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811530730.7A CN109829002A (en) | 2018-12-14 | 2018-12-14 | A kind of complex report forms building system and construction method based on web |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811530730.7A CN109829002A (en) | 2018-12-14 | 2018-12-14 | A kind of complex report forms building system and construction method based on web |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109829002A true CN109829002A (en) | 2019-05-31 |
Family
ID=66859647
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811530730.7A Pending CN109829002A (en) | 2018-12-14 | 2018-12-14 | A kind of complex report forms building system and construction method based on web |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109829002A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114925665A (en) * | 2022-06-08 | 2022-08-19 | 杭州比智科技有限公司 | Graph data editing method and system based on web table |
| CN118552654A (en) * | 2024-07-29 | 2024-08-27 | 无锡容智技术有限公司 | Automatic drawing method based on algorithm formula |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130332811A1 (en) * | 2012-06-07 | 2013-12-12 | Microsoft Corporation | Progressive loading for web-based spreadsheet applications |
| CN104360992A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | WEB report design system built based on EXCEL platform and implementation method |
-
2018
- 2018-12-14 CN CN201811530730.7A patent/CN109829002A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130332811A1 (en) * | 2012-06-07 | 2013-12-12 | Microsoft Corporation | Progressive loading for web-based spreadsheet applications |
| CN104360992A (en) * | 2014-12-02 | 2015-02-18 | 福建工程学院 | WEB report design system built based on EXCEL platform and implementation method |
Non-Patent Citations (3)
| Title |
|---|
| CGQ北京: ""大屏数据可视化工具"", 《HTTP://C.RAQSOFT.COM.CN/ARTICLE/1535678317741#TOC_H3_13》 * |
| LEE869486359: ""润乾报表多维分析功能漫游"", 《HTTP://C.RAQSOFT.COM.CN/ARTICLE/1535678317741》 * |
| SLN北京: ""把Excel透视表搬到web上"", 《HTTP://C.RAQSOFT.COM.CN/ARTICLE/1534232078598》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114925665A (en) * | 2022-06-08 | 2022-08-19 | 杭州比智科技有限公司 | Graph data editing method and system based on web table |
| CN118552654A (en) * | 2024-07-29 | 2024-08-27 | 无锡容智技术有限公司 | Automatic drawing method based on algorithm formula |
| CN118552654B (en) * | 2024-07-29 | 2024-12-31 | 无锡容智技术有限公司 | Automatic drawing method based on algorithm formula |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106528129B (en) | A kind of Web application interface generation system and method | |
| CN106325969B (en) | The reversely tracing system of demand change | |
| CN113535931B (en) | Information processing method and device, electronic equipment and storage medium | |
| CN108804513A (en) | Automatic visual analysis method for big data platform | |
| CN102339314A (en) | An XML-based cross-terminal data form description and presentation method | |
| CN111309313A (en) | A fast way to generate HTML and store form data | |
| CN109829002A (en) | A kind of complex report forms building system and construction method based on web | |
| CN105045817B (en) | SQL Server database evidence-taking and analysis system and method based on transaction journal | |
| CN109740139A (en) | Document title custom style control method, device, computer equipment and storage medium | |
| CN113656454B (en) | Comprehensive supervision modeling statistical method, device, terminal and storage medium | |
| CN106919606A (en) | A kind of method and system that SQL query condition is realized based on tree construction | |
| CN113885859A (en) | Low-code report implementation method based on SIS production operation data | |
| CN112699032B (en) | Method for realizing vddbench performance test result analysis based on Excel | |
| CN112634004B (en) | Method and system for analyzing blood-cause atlas of credit investigation data | |
| CN105159688A (en) | Programmable information visualization interaction type design method | |
| CN109918351A (en) | A method and system for converting beamer presentation to PowerPoint presentation | |
| CN102467496B (en) | Method and device for converting stream mode typeset content into block mode typeset document | |
| CN116126873B (en) | Data summarization method and device based on nonstandard data table and storage medium | |
| CN108460007A (en) | A kind of automation report logic engine and method | |
| CN108664546A (en) | Xml data structure conversion method and device | |
| CN114443656A (en) | Customizable automated data model analysis tool and use method thereof | |
| CN105930398A (en) | Visualization method and apparatus for data in power system | |
| CN109241167A (en) | List data introduction method based on B/S framework | |
| CN113536407B (en) | Method, device and storage medium for constructing project drawing based on unit equipment | |
| CN109885296A (en) | A kind of data visualization Customization Tool |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190531 |
|
| RJ01 | Rejection of invention patent application after publication |