CN109213811A - A kind of report form showing method and device - Google Patents
A kind of report form showing method and device Download PDFInfo
- Publication number
- CN109213811A CN109213811A CN201710524476.9A CN201710524476A CN109213811A CN 109213811 A CN109213811 A CN 109213811A CN 201710524476 A CN201710524476 A CN 201710524476A CN 109213811 A CN109213811 A CN 109213811A
- Authority
- CN
- China
- Prior art keywords
- report
- column properties
- gauge outfit
- properties value
- value
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of report form showing method and devices.This method comprises: receiving inquiry request；SQL statement is dynamically spelt in report database according to report document information, obtains SQL query statement；Corresponding result set is inquired in report database according to SQL query statement, and generates the basic gauge outfit of report according to the corresponding Column Properties value of SQL query statement, the corresponding Column Properties value of the basis gauge outfit can be dragged, generates corresponding sublist head；Data exhibiting is carried out in the report according to the gauge outfit of generation to the data in the result set.The present invention is showed and working process by carrying out statistics to data, only need to inquire a database, and by adding single drag operation that can be grouped statistics to the corresponding report data of basic gauge outfit, report data shows novel form, and it is easy to operate, meet user's habit, it is widely applicable.
Description
Technical field
The present invention relates to technical field of data processing, in particular to a kind of report form showing method and device.
Background technique
Report is exactly to show data with formats such as table, charts.With the appearance of computer, pass through computer disposal number
It generated according to the function with interface, show that report is possibly realized, it is soft to have expedited the emergence of many reports for a large amount of data processing needs
Part, report software are mainly characterized by data mobilism, format diversification, and realize the complete of report data and statement form
Separation, gauge outfit pattern and data all fix in advance, and the content of only report is dynamic data, and user can only modify number
According to or only modify format.
Gauge outfit pattern provided by existing report software is fixed, so that process of the report software in production gauge outfit
In if can be related to merging rows, close parallel operation when to production reports user technical capability it is more demanding, be only suitable for professional people
Member operates, and use occasion is limited.
Summary of the invention
Based on one object of the present invention, the present invention provides a kind of report form showing method and devices, to solve report table
The limited problem of the fixed bring report software use occasion of head.
In order to achieve the above objectives, the technical scheme of the present invention is realized as follows:
On the one hand, the present invention provides a kind of report form showing methods, this method comprises:
Inquiry request is received, the inquiry request carries report document information；
SQL statement is dynamically spelt in report database according to the report document information, obtains SQL query statement,
SQL statement, the corresponding report document number of every SQL statement are registered in the report database；
Corresponding result set is inquired in the report database according to the SQL query statement, and according to the SQL
The corresponding Column Properties value of query statement generates the basic gauge outfit of report, and the corresponding Column Properties value of the basis gauge outfit can be dragged, raw
At corresponding sublist head；
Data exhibiting is carried out in the report according to the gauge outfit of generation to the data in the result set, the generation
Gauge outfit includes basic gauge outfit and the sublist head by the dragged generation of Column Properties value.
On the other hand, the present invention provides a kind of report form showing device, which includes:
Receiving unit, for receiving inquiry request, the inquiry request carries report document information；
Spelling unit is obtained for dynamically spelling SQL statement in report database according to the report document information
SQL query statement registers with SQL statement, the corresponding report document number of every SQL statement in the report database；
Creating unit, for inquiring corresponding result set in the report database according to the SQL query statement, with
And the basic gauge outfit of report, the corresponding Column Properties of basis gauge outfit are generated according to the corresponding Column Properties value of the SQL query statement
Value can be dragged, generates corresponding sublist head；
Show unit, for carrying out data exhibition in the report according to the gauge outfit of generation to the data in the result set
Existing, the gauge outfit of the generation includes basic gauge outfit and the sublist head by the dragged generation of Column Properties value.
The beneficial effects of the present invention are: the present invention registers SQL statement in report database, to be carried according to inquiry request
Report document number dynamic spelling SQL query statement, reach SQL statement spelling optimal effectiveness, all design one without each case
Kind SQL statement is inquired；And the present invention is loaded into the column of gauge outfit by the data in the result set that inquires to SQL statement
Attribute value can produce the sublist head of basic gauge outfit by drag operation in trailing report, and then can dynamically change
The gauge head structure of report forms the subreport of corresponding each sublist head, so that each subreport shows corresponding data.
Report form showing method and device of the invention is showed and working process by carrying out statistics to data, need to only inquire one
Secondary database, and by adding single drag operation that can be grouped statistics, report number to the corresponding report data of basic gauge outfit
According to showing novel form, and it is easy to operate, meet user's habit, it is widely applicable.
Detailed description of the invention
Fig. 1 is report form showing method flow chart provided in an embodiment of the present invention；
Fig. 2 is multilevel report schematic diagram provided in an embodiment of the present invention；
Fig. 3 is report form showing device structural block diagram provided in an embodiment of the present invention.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, below in conjunction with attached drawing to embodiment party of the present invention
Formula is described in further detail.
Fig. 1 is report form showing method flow chart provided in an embodiment of the present invention, as shown in Figure 1, the method packet of the present embodiment
It includes:
S100, receives inquiry request, which carries report document information.
S110 dynamically spells SQL statement according to report document information in report database, obtains SQL query statement,
SQL statement, the corresponding report document number of every SQL statement are registered in the report database.
Wherein, the report database of the present embodiment is the database for supporting SQL query.
S120 inquires corresponding result set according to SQL query statement in report database, and according to SQL query language
The corresponding Column Properties value of sentence generates the basic gauge outfit of report, and the corresponding Column Properties value of the basis gauge outfit can be dragged, generates and corresponds to
Sublist head.
" basic gauge outfit corresponding Column Properties value can be dragged " described in the present embodiment be it is to be understood that can be to underlying table
Each Column Properties value in head carries out drag operation, and the Column Properties value in basic gauge outfit is such as hauled out the basis gauge outfit, generates phase
The sublist head answered, or the Column Properties value of hauling-out is entrained back into the basis gauge outfit, the Column Properties value by dragging basic gauge outfit reaches
The purpose that basic gauge outfit is updated to dynamic, to generate corresponding report data.
S130 carries out data exhibiting, the table of the generation according to the gauge outfit of generation to the data in result set in report
Head includes basic gauge outfit and the sublist head by the dragged generation of Column Properties value.
Illustratively, if the Column Properties value in basic gauge outfit is not dragged always, or the Column Properties value in basic gauge outfit
It after being dragged out and is entrained back into basic gauge outfit, step S130 is interpreted as: existing to the data in result set according to basic gauge outfit
Data exhibiting is carried out in report.
If the columns value in basic gauge outfit is dragged, such as certain (some) Column Properties values are dragged out, alternatively, in basic gauge outfit
Certain (or some) Column Properties values be dragged out, other Column Properties values are entrained back into basic gauge outfit, and step S130 is interpreted as:
Data exhibiting is carried out in report according to the sublist head of generation to the data in result set.
The present embodiment registers SQL statement in report database, with the report document dynamic carried according to inquiry request
SQL query statement is spelt, SQL statement spelling optimal effectiveness is reached, a kind of SQL statement is all designed without each case and is looked into
It askes；And the present embodiment can be dragged by the Column Properties value that the data in the result set that inquires to SQL statement are loaded into gauge outfit
In dynamic report, the sublist head of basic gauge outfit is produced by drag operation, and then can dynamically change the gauge outfit knot of report
Structure forms the subreport of corresponding each sublist head, so that each subreport shows corresponding data.
The report form showing method of the present embodiment is showed and working process by carrying out statistics to data, need to only inquire a number
According to library, and by adding single drag operation that can be grouped statistics, report data exhibition to the corresponding report data of basic gauge outfit
Existing novel form, and it is easy to operate, meet user's habit, it is widely applicable.
In one embodiment of the invention, SQL statement is registered in report database by following methods:
The SQL statement finished writing in advance is carried out according to Select field, From field, Where field and Groupby field
It splits, and the data of fractionation is saved in corresponding four excel tables, which is associated with by report document number,
And correspond respectively to the main table in report database, sublist, relation table and querying condition table；By the corresponding number of every excel table
According to importeding into the corresponding table of report database.
In practical application, secondary development personnel write the SQL statement of a large and complete statistical report form in advance, will be written
SQL statement is split in corresponding excel table, which is associated with by report document number, and report data respectively
Main table (FX_ReportConfigGroupMain), sublist (FX_ReportConfigColSub), relation table (FX_ in library
FxConrelationship) and querying condition table (FX_ConfRepGroupWhere), JSTL tool can be used by every
The corresponding data of excel table are imported into the corresponding table of report database, complete the registration of SQL statement, subsequent to be selected according to user
Corresponding field is packaged into SQL query statement and carries out data query by the inquiry field and grouping field selected.
In one embodiment of the invention, on the basis for generating report according to the corresponding Column Properties value of SQL query statement
Method after gauge outfit, in Fig. 1 further include:
It receives the dragging for dragging the Column Properties value of basic gauge outfit to request, dragging request carries trailing dependent of dead military hero
The drawing direction of property value and Column Properties value；
According to the drawing direction of trailing Column Properties value and Column Properties value, the report of corresponding dragging request is generated in report
Table.
Wherein, dragging request can carry one or more trailing Column Properties values, the dependent of dead military hero carried in dragging request
The drawing direction of property value includes hauling out and being entrained back into basic gauge outfit from basic gauge outfit.
When the drawing direction of Column Properties value is to haul out from basic gauge outfit, judges whether there is and be dragged out other Column Properties
Value, other Column Properties values being dragged out if it does not exist then create junior using Column Properties value as grouping field based on basic gauge outfit
Gauge outfit, and the subreport for covering report is generated with the lower table header of creation；Other Column Properties values being dragged out if it exists, then merge
The Column Properties value being dragged out, the Column Properties value after being merged, based on basic gauge outfit using the Column Properties value after merging as grouping
Field creates lower table header, and the subreport of covering report is generated with the lower table header of creation；
When the drawing direction of Column Properties value is to be entrained back into basic gauge outfit, other dependents of dead military hero being dragged out are judged whether there is
Property value, other Column Properties values being dragged out if it does not exist then generate the corresponding report of basic gauge outfit；Be dragged out if it exists other
Column Properties value merges the Column Properties value being dragged out, the Column Properties value after being merged, the column after merging based on basic gauge outfit
Attribute value creates lower table header as grouping field, and the subreport for covering the report is generated with the lower table header of creation.
Illustratively, it is illustrated in combination with fig. 2 the detailed process for dragging the Column Properties value generation subreport of basic gauge outfit.
As shown in Fig. 2, the basic gauge outfit in Fig. 2 includes: " specific name (CategoryName) ", " name of product
(ProductName) ", " product selling price (ProductSales) ", " Shipping Date (ShippedDate) ", " year
(Year) ", the Column Properties value such as " quartering (Quarter) ", " moon (Month) " and " all (Week) ".
It is illustrated in Fig. 2, " specific name " and " name of product " is hauled out from basic gauge outfit, Fig. 2 is illustratively
The blank space the two Column Properties values being dragged to above gauge outfit is shown.
It should be noted that needing basis when user generates dragging request by dragging the Column Properties value of basic gauge outfit
The dragging sequence of Column Properties value sequentially generates report.
It is assumed that first hauling out " specific name " from basic gauge outfit, then " name of product " is hauled out from basic gauge outfit, this
When, first " specific name " counts the corresponding report data of basic gauge outfit as grouping field, generates level-one subreport,
Then " name of product " and " specific name " is merged, regard " name of product+specific name " after merging as grouping field pair
The corresponding report data of basic gauge outfit is counted, and second level subreport is generated.It should be noted that the level-one subreport in Fig. 2
Covered by second level subreport.
Fig. 2 illustratively indicates every grade of subreport with tree-like mark "-", wherein being located at the tree-like mark of the table leftmost side
"-" is level-one subreport mark, and the tree-like mark "-" positioned at table time left side is second level subreport mark, identifies every grade according to this
Subreport.
It is assumed that user formerly hauls out " specific name " from basic gauge outfit, then by " name of product " from basic gauge outfit
It hauls out, after generating report shown in Fig. 2 and being shown, " name of product " is entrained back into basic gauge outfit by user again, this
When, the report showed is a sub grade report.Specifically, when " name of product " is entrained back into basic gauge outfit by user, due to report
There is also the Column Properties values " specific name " being dragged out in table, are used as grouping field to basic gauge outfit pair for " specific name " at this time
The report data answered is counted, and level-one subreport is generated, and carries out the data exhibiting of level-one subreport.
In practical applications, CORE JAVA SWING can be used to realize above-mentioned report form showing method, utilize unification
Parent handles showing for various reports.
Illustratively, report subclass can be used, as (the report subclass is report to report parent DeliveryCountUI
The report parent of the abstract class such as nested class ReportNestedUI), it is extracted according to report document number for preparing spelling SQL language
The four object value VO, i.e., main table object value ReportConfigGroupMainVO, sublist object value of sentence
ReportConfigColSubVO, relation table object value FxConrelationshipVO and querying condition object value
ConfRepGroupWhereVO, this thing can initialize a table using report tool JTable and show for user, but initialize
All pre-display column of being classified as of showing at this time of the table big complete or collected works.
When the user clicks such as the inquiry button in Fig. 2, it will pop up as query frame selects grouping column for user and looks into
Inquiry condition column, after user determines grouping column and querying condition column, ReportNestedUI parent uses data load method
ConstructGroupTable responds the inquiry request of user, and the result set data inquired are loaded into grouping sheet
In GroupTable table, the present embodiment presets the template Model of GroupTable table, i.e., by grouping sheet template
AggregateGroupTableModel table structure is defined, and makes the column name (i.e. Column Properties value) of the table can be dragged.
Each column name in basic gauge outfit can trigger AggregateGroupTableModel calling when dragged
It is grouped execution method groupExecute, to obtain the grouping field for dragging request and carrying, based on the grouping field of acquisition to base
The corresponding report data of plinth gauge outfit carries out statistical packet, obtains the dragging and requests corresponding subreport.
Of course, it is possible to add up to data as shown in Fig. 2, total function is added in report, it also can be set and beat
Print excel export, refreshes, adjustment col width, the functions such as icon is arranged.
Corresponding to the above method embodiment, the present invention also provides a kind of report form showing device embodiments.
Fig. 3 is report form showing device structural block diagram provided in an embodiment of the present invention, as shown in figure 3, the device includes receiving
Unit 31 spells unit 32, creating unit 33 and shows unit 34；
Receiving unit 31, for receiving inquiry request, which carries report document information；
Spelling unit 32 is obtained for dynamically spelling SQL statement in report database according to report document information
SQL query statement registers with SQL statement, the corresponding report document number of every SQL statement in the report database；
Creating unit 33, for inquiring corresponding result set in the report database according to the SQL query statement,
And the basic gauge outfit of report, the corresponding dependent of dead military hero of basis gauge outfit are generated according to the corresponding Column Properties value of the SQL query statement
Property value can be dragged, generates corresponding sublist head；
Show unit 34, for carrying out data exhibition in the report according to the gauge outfit of generation to the data in result set
Existing, the gauge outfit of the generation includes basic gauge outfit and the sublist head by the dragged generation of Column Properties value.
Preferably, the device in Fig. 3 further includes registration import unit to the present embodiment；
The registration import unit, for by the SQL statement finished writing in advance according to Select field, From field, Where word
Section and Groupby field are split, and the data of fractionation are saved in corresponding four excel tables, four excel tables
It is associated with by report document number, and corresponds respectively to the main table in report database, sublist, relation table and querying condition table；It will
The corresponding data of every excel table are imported into the corresponding table of the report database.
Inquiry request in the present embodiment also carries query condition information and grouping conditional information；
Unit 32 is then spelt, four for being also used to be used to spell according to report document information extraction SQL query statement are right
As value；According to query condition information and grouping conditional information call statement querying method getSQL, it is based on four object values
Spell the corresponding SQL query statement of the inquiry request.
In an implementation of the present embodiment, receiving unit 31, for receive to the Column Properties value of basic gauge outfit into
The dragging request of row dragging, dragging request carry the drawing direction of trailing Column Properties value and Column Properties value；
Creating unit 33 generates in report for the drawing direction according to trailing Column Properties value and Column Properties value
The report of corresponding dragging request.
In this implementation, the device in Fig. 3 further includes judging unit, is asked for receiving dragging in receiving unit 31
When asking, judges whether there is and be dragged out other Column Properties values；
Correspondingly, creating unit 33, is to haul out from basic gauge outfit, and judge single for the drawing direction in Column Properties value
Member judgement creates junior using Column Properties value as grouping field based on basic gauge outfit there is no when other Column Properties values being dragged out
Gauge outfit, and the subreport for covering report is generated with the lower table header of creation；It is from basic gauge outfit in the drawing direction of Column Properties value
Middle hauling-out, and judging unit judgement exist be dragged out other Column Properties values when, merge the Column Properties value being dragged out, merged
Column Properties value afterwards creates lower table header using the Column Properties value after merging as grouping field based on basic gauge outfit, and with creation
Lower table header generate covering report subreport；
It and in the drawing direction of Column Properties value is to be entrained back into basic gauge outfit, and judging unit judgement is there is no being dragged
When other Column Properties values out, the corresponding report of basic gauge outfit is generated；It is to be entrained back into underlying table in the drawing direction of Column Properties value
In head, and when judging unit judgement has other Column Properties values being dragged out, merges the Column Properties value that has been dragged out, merged
Column Properties value afterwards creates lower table header using the Column Properties value after merging as grouping field based on basic gauge outfit, and with creation
Lower table header generate covering report subreport.
The specific working mode of each unit of apparatus of the present invention embodiment may refer to embodiment of the method for the invention, herein
It repeats no more.
For the ease of clearly describing the technical solution of the embodiment of the present invention, in the embodiment of invention, use " first ",
Printed words such as " second " distinguish function and the essentially identical identical entry of effect or similar item, and those skilled in the art can manage
The printed words such as solution " first ", " second " are not defined quantity and execution order.
The above description is merely a specific embodiment, under above-mentioned introduction of the invention, those skilled in the art
Other improvement or deformation can be carried out on the basis of the above embodiments.It will be understood by those skilled in the art that above-mentioned tool
Body description only preferably explains that the purpose of the present invention, protection scope of the present invention should be subject to the protection scope in claims.
Claims (10)
1. a kind of report form showing method, which is characterized in that this method comprises:
Inquiry request is received, the inquiry request carries report document information；
SQL statement is dynamically spelt in report database according to the report document information, obtains SQL query statement, it is described
SQL statement, the corresponding report document number of every SQL statement are registered in report database；
Corresponding result set is inquired in the report database according to the SQL query statement, and according to the SQL query
The corresponding Column Properties value of sentence generates the basic gauge outfit of report, and the corresponding Column Properties value of the basis gauge outfit can be dragged, generation pair
The sublist head answered；
Data exhibiting, the gauge outfit of the generation are carried out in the report according to the gauge outfit of generation to the data in the result set
Including basic gauge outfit and by the sublist head of the dragged generation of Column Properties value.
2. the method according to claim 1, wherein registering SQL language in report database according to following methods
Sentence:
The SQL statement finished writing in advance is torn open according to Select field, From field, Where field and Groupby field
Point, and the data of fractionation are saved in corresponding four excel tables, which is associated with by report document number, and
Correspond respectively to main table, sublist, relation table and the querying condition table in report database；
The corresponding data of every excel table are imported into the corresponding table of the report database.
3. the method according to claim 1, wherein the inquiry request also carries query condition information and grouping
Conditional information, it is described SQL statement is dynamically spelt in report database according to the report document information to include:
It is used to spell four object values of SQL query statement according to the report document information extraction；
According to query condition information and grouping conditional information call statement querying method getSQL, spelled based on four object values
Write the corresponding SQL query statement of the inquiry request.
4. the method according to claim 1, wherein according to the corresponding Column Properties value of the SQL query statement
After the basic gauge outfit for generating report, the method also includes:
It receives the dragging for dragging the Column Properties value of the basic gauge outfit to request, the dragging request carries trailing column
The drawing direction of attribute value and Column Properties value；
According to the drawing direction of trailing the Column Properties value and Column Properties value, the corresponding dragging is generated in the report
The report of request.
5. according to the method described in claim 4, it is characterized in that, the trailing Column Properties carried according to the dragging request
The drawing direction of value and Column Properties value, the report that the corresponding dragging request is generated in the report include:
When the drawing direction of the Column Properties value is to haul out from basic gauge outfit, judges whether there is and be dragged out other Column Properties
Value, other Column Properties values being dragged out if it does not exist, then based on the basic gauge outfit using the Column Properties value as grouping field
Lower table header is created, and generates the subreport for covering the report with the lower table header of creation；Other column being dragged out if it exists
Attribute value, then merge the Column Properties value being dragged out, the Column Properties value after being merged, based on the basic gauge outfit to merge after
Column Properties value creates lower table header as grouping field, and the subreport for covering the report is generated with the lower table header of creation；
When the drawing direction of the Column Properties value is to be entrained back into basic gauge outfit, other dependents of dead military hero being dragged out are judged whether there is
Property value, other Column Properties values being dragged out if it does not exist then generate the corresponding report of the basic gauge outfit；It is dragged out if it exists
Other Column Properties values merge the Column Properties value being dragged out, the Column Properties value after being merged, based on the basic gauge outfit to close
Column Properties value after and creates lower table header as grouping field, and the son for covering the report is generated with the lower table header of creation
Report.
6. a kind of report form showing device, which is characterized in that the device includes:
Receiving unit, for receiving inquiry request, the inquiry request carries report document information；
It spells unit and obtains SQL for dynamically spelling SQL statement in report database according to the report document information
Query statement registers with SQL statement, the corresponding report document number of every SQL statement in the report database；
Creating unit, for inquiring corresponding result set, Yi Jigen in the report database according to the SQL query statement
The basic gauge outfit of report is generated according to the corresponding Column Properties value of the SQL query statement, the corresponding Column Properties value of the basis gauge outfit can
It is dragged, generate corresponding sublist head；
Show unit, for carrying out data exhibiting in the report according to the gauge outfit of generation to the data in the result set,
The gauge outfit of the generation includes basic gauge outfit and the sublist head by the dragged generation of Column Properties value.
7. device according to claim 6, which is characterized in that the device further includes registration import unit；
The registration import unit, for by the SQL statement finished writing in advance according to Select field, From field, Where field
It is split with Groupby field, and the data of fractionation is saved in corresponding four excel tables, four excel tables are logical
The association of report document number is crossed, and corresponds respectively to the main table in report database, sublist, relation table and querying condition table；It will be every
The corresponding data of excel table are opened to imported into the corresponding table of the report database.
8. device according to claim 6, which is characterized in that the inquiry request also carries query condition information and grouping
Conditional information；
The spelling unit, for being used to spell four objects of SQL query statement according to the report document information extraction
Value；According to query condition information and grouping conditional information call statement querying method getSQL, spelled based on four object values
Write the corresponding SQL query statement of the inquiry request.
9. device according to claim 6, which is characterized in that
The receiving unit, for receiving the dragging request dragged to the Column Properties value of the basic gauge outfit, the dragging
Request carries the drawing direction of trailing Column Properties value and Column Properties value；
The creating unit, for the drawing direction according to trailing the Column Properties value and Column Properties value, in the report
The middle report for generating the corresponding dragging request.
10. device according to claim 9, which is characterized in that the device further includes judging unit；
The judging unit, for judging whether there is and being dragged out other column when the receiving unit receives dragging request
Attribute value；
The creating unit is to haul out from basic gauge outfit, and the judgement is single for the drawing direction in the Column Properties value
There is no when other Column Properties values being dragged out, be based on the basic gauge outfit using the Column Properties value as grouping field for member judgement
Lower table header is created, and generates the subreport for covering the report with the lower table header of creation；In the dragging of the Column Properties value
Direction be hauled out from basic gauge outfit, and the judging unit judgement exist be dragged out other Column Properties values when, merging dragged
Column Properties value out, the Column Properties value after being merged, based on the basic gauge outfit using the Column Properties value after merging as grouping
Field creates lower table header, and the subreport for covering the report is generated with the lower table header of creation；
And the Column Properties value drawing direction be entrained back into basic gauge outfit, and the judging unit judgement be not present
When other Column Properties values being dragged out, the corresponding report of the basic gauge outfit is generated；It is in the drawing direction of the Column Properties value
It is entrained back into basic gauge outfit, and when judging unit judgement has other Column Properties values being dragged out, merges and be dragged out
Column Properties value, the Column Properties value after being merged, based on the basic gauge outfit using the Column Properties value after merging as grouping field
Lower table header is created, and generates the subreport for covering the report with the lower table header of creation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710524476.9A CN109213811B (en) | 2017-06-30 | 2017-06-30 | Report form display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710524476.9A CN109213811B (en) | 2017-06-30 | 2017-06-30 | Report form display method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109213811A true CN109213811A (en) | 2019-01-15 |
| CN109213811B CN109213811B (en) | 2021-05-11 |
Family
ID=64977135
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710524476.9A Active CN109213811B (en) | 2017-06-30 | 2017-06-30 | Report form display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109213811B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256684A (en) * | 2020-10-23 | 2021-01-22 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090040240A1 (en) * | 2007-08-08 | 2009-02-12 | David Kirk Grotjohn | Hovering table headers |
| CN101799801A (en) * | 2010-01-26 | 2010-08-11 | 中兴通讯股份有限公司 | Realization method and device of self-definition statistical report form based on flow protocol |
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
| CN104714974A (en) * | 2013-12-17 | 2015-06-17 | 航天信息股份有限公司 | Method and device for parsing and reprocessing query statement |
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| CN105095249A (en) * | 2014-05-05 | 2015-11-25 | 中国石油化工股份有限公司 | Method generating multi-dimension report form |
| US20160292240A1 (en) * | 2015-03-31 | 2016-10-06 | Informatica Llc | Table Based Data Set Extraction From Data Clusters |
-
2017
- 2017-06-30 CN CN201710524476.9A patent/CN109213811B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090040240A1 (en) * | 2007-08-08 | 2009-02-12 | David Kirk Grotjohn | Hovering table headers |
| CN101799801A (en) * | 2010-01-26 | 2010-08-11 | 中兴通讯股份有限公司 | Realization method and device of self-definition statistical report form based on flow protocol |
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| CN104714974A (en) * | 2013-12-17 | 2015-06-17 | 航天信息股份有限公司 | Method and device for parsing and reprocessing query statement |
| CN105095249A (en) * | 2014-05-05 | 2015-11-25 | 中国石油化工股份有限公司 | Method generating multi-dimension report form |
| CN104361137A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Device and method for generating data fetching conditions of report form |
| US20160292240A1 (en) * | 2015-03-31 | 2016-10-06 | Informatica Llc | Table Based Data Set Extraction From Data Clusters |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112256684A (en) * | 2020-10-23 | 2021-01-22 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
| CN112256684B (en) * | 2020-10-23 | 2022-08-16 | 厦门悦讯信息科技股份有限公司 | Report generation method, terminal equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109213811B (en) | 2021-05-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106033471B (en) | A kind of method and apparatus handling list | |
| US20060195424A1 (en) | Generating business warehouse reports | |
| US8635253B2 (en) | Decorated model architecture for efficient model-driven application development | |
| US20060200797A1 (en) | Integration of data management operations into a workflow system | |
| CN103955538B (en) | HBase data persistence and query methods and HBase system | |
| CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
| JP2009509271A (en) | Apparatus and method for data profiling based on composition of extraction, transformation and reading tasks | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| CN109634992B (en) | A kind of structure of report decomposition method, report form generation method, device | |
| CN110362591B (en) | Report form display method and device | |
| EP1793317A2 (en) | Dynamic data presentation | |
| US20200210640A1 (en) | Method and apparatus for displaying textual information | |
| US20130166531A1 (en) | Data browser for group-by data access | |
| CN101122915A (en) | Search engine based on parameter | |
| CN109213776B (en) | Report form display method and device | |
| CN112286907A (en) | Database configuration method and device, electronic equipment and readable storage medium | |
| CN109542425B (en) | Automatic application method and system of retail supply chain | |
| CN102819542A (en) | Method and device for presenting instance documents | |
| CN103631767A (en) | Automatic generation method of universal data report | |
| US8392358B2 (en) | Temporal extent considerations in reporting on facts organized as a dimensionally-modeled fact collection | |
| CN109213811A (en) | A kind of report form showing method and device | |
| CN110019433B (en) | Report query method and device | |
| CN111143356A (en) | Report retrieval method and device | |
| US9128908B2 (en) | Converting reports between disparate report formats | |
| Szekely et al. | T2WML: A Cell-Based Language to Map Tables into Wikidata Records. |
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 | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Room 818, 8 / F, 34 Haidian Street, Haidian District, Beijing 100080 Applicant after: BEIJING ULTRAPOWER SOFTWARE Co.,Ltd. Address before: 100089 Beijing city Haidian District wanquanzhuang Road No. 28 Wanliu new building 6 storey block A Room 601 Applicant before: BEIJING ULTRAPOWER SOFTWARE Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |