CN109684387A - Report generation method and device - Google Patents
Report generation method and device Download PDFInfo
- Publication number
- CN109684387A CN109684387A CN201811585367.9A CN201811585367A CN109684387A CN 109684387 A CN109684387 A CN 109684387A CN 201811585367 A CN201811585367 A CN 201811585367A CN 109684387 A CN109684387 A CN 109684387A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- dimension
- expansion
- page
- 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
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the present application provides a kind of report generation method and device, and report form generation method includes firstly, response user's operation is loaded into the report layout page.Then, report unit is constructed in report layout region according to report data source and configures expansion mode for report unit.Finally, the report cell array being made of report unit is filled in report page to be presented along expansion direction, the corresponding data dimension angle value of the report unit and data read magnitude are filled in each report unit according to expansion dimension simultaneously, to generate the report page to be presented.Thus, pass through building report unit and report unit is filled according to data dimension and data metric automatically and generates data sheet, it avoids staff and needs first to construct structure of report in the complex operations that data are filled into structure of report one by one, improve report generation efficiency.
Description
Technical field
This application involves data sheet fields, in particular to a kind of report generation method and device.
Background technique
In data sheet field, when generating data sheet, related technical personnel face larger problem, are easy in use
When the Software Create report of operation, such as Excel software, it is difficult to the data source for directly utilizing database is needed when generating report
First to construct structure of report, then add data one by one in structure of report, with data volume become larger and the day of structure of report
Benefit complicates, and this operation brings very big workload, seriously annoyings those skilled in the relevant art.
Apply for content
In view of this, the application's is designed to provide a kind of report generation method and device, on solving or improve
State problem.
To achieve the goals above, the embodiment of the present application the technical solution adopted is as follows:
In a first aspect, the embodiment of the present application provides a kind of report form generation method, it is applied to electronic equipment, the method packet
It includes:
Respond user's operation and be loaded into the report layout page, wherein the report layout page include report layout region with
And report data source, the report data source include at least one data dimension and the corresponding data read of each data dimension
Amount;
Report unit is constructed in report layout region according to the report data source and is matched for the report unit
Set expansion mode, wherein include the data dimension and the data metric, the expansion mode packet in the report unit
Include expansion dimension and expansion direction;
The report unit battle array being made of the report unit is filled in report page to be presented along the expansion direction
Column, while the corresponding data dimension angle value of the report unit and data are filled in each report unit according to the expansion dimension
Metric, to generate the report page to be presented.
Optionally, the step of response user's operation loading report layout page includes:
It responds user's operation and obtains report layout task;
According to the report layout task creation include the report layout page in report layout region, and obtains the report
The tables of data of layout task instruction;
At least one data dimension and the corresponding data metric of each data dimension are obtained from the tables of data, and will
At least one described data dimension and the corresponding data metric of each data dimension are loaded into the report layout page.
Optionally, described to construct report unit in report layout region according to the report data source and be described
Report unit configure expansion mode the step of include:
The data dimension and the data metric are filled into report layout region;
According to building report unit in the report layout region of user's operation after filling, and will be in the data dimension
At least partly data dimension is configured to expansion dimension, while configuring the expansion direction of each expansion dimension, for the report list
Member configuration expansion mode.
Optionally, the described the step of data dimension and the data metric are filled into the report layout region
Later, which comprises
Screening is executed to the data dimension and data metric that are filled into report layout region, sorts, establish function
And one of query processing or the data manipulation of multiple combinations.
Optionally, the described the step of data dimension and the data metric are filled into the report layout region
Later, which comprises
Visual Chart is generated according to the data dimension and data metric for being filled into report layout region.
Optionally, described to fill the corresponding data dimension of report unit in each report unit according to the expansion dimension
The step of angle value and data read magnitude includes:
Each expansion dimension is traversed, the data dimension angle value of the expansion dimension is filled into the corresponding report list of the expansion dimension
Member;
The corresponding data read magnitude of the expansion dimension is obtained according to the data dimension angle value of the expansion dimension, and by the data
Metric is filled into corresponding report unit.
Optionally, after described the step of generating the report page to be presented, the method also includes:
Store the report page.
Second aspect, the embodiment of the present application also provide a kind of report generation device, and the report generation device includes:
The page insmods, and is loaded into the report layout page for responding user's operation, wherein the report layout page packet
Report layout region and report data source are included, the report data source includes at least one data dimension and each data dimension
Spend corresponding data metric;
Page configuration module, for constructing report unit simultaneously in report layout region according to the report data source
Expansion mode is configured for the report unit, wherein includes the data dimension and the data read in the report unit
Amount, the expansion mode include expansion dimension and expansion direction;And
Report generation module, for being filled in report page to be presented by the report unit along the expansion direction
The report cell array of composition, while the corresponding number of report unit is filled in each report unit according to the expansion dimension
According to dimension values and data read magnitude, to generate the report page to be presented.
Optionally, the page, which insmods, is also used to:
It responds user's operation and obtains report layout task;
According to the report layout task creation include the report layout page in report layout region, and obtains the report
The tables of data of layout task instruction;
At least one data dimension and the corresponding data metric of each data dimension are obtained from the tables of data, and will
At least one described data dimension and the corresponding data metric of each data dimension are loaded into the report layout page.
Optionally, the page configuration module is also used to:
The data dimension and the data metric are filled into report layout region;
According to building report unit in the report layout region of user's operation after filling, and will be in the data dimension
At least partly data dimension is configured to expansion dimension, while configuring the expansion direction of each expansion dimension, for the report list
Member configuration expansion mode.
Compared with prior art, the beneficial effect of the application is:
Report generation method and device provided by the embodiments of the present application, by building report unit and according to data dimension with
And data metric fills report unit automatically and generates data sheet, avoids staff and needs first to construct structure of report one by one
Data are filled into the complex operations of structure of report, improve report generation efficiency.
Detailed description of the invention
Technical solution in ord to more clearly illustrate embodiments of the present application, below will be to needed in the embodiment attached
Figure is briefly described.It should be appreciated that the following drawings illustrates only some embodiments of the application, therefore it is not construed as pair
The restriction of range.It for those of ordinary skill in the art, without creative efforts, can also be according to this
A little attached drawings obtain other relevant attached drawings.
Fig. 1 is the structural schematic block diagram of the electronic equipment provided by the embodiments of the present application for realizing object detection method;
Fig. 2 is a kind of flow diagram of report form generation method provided by the embodiments of the present application;
Fig. 3 is a kind of page presentation schematic diagram of the report layout page provided by the embodiments of the present application;
Fig. 4 is the page presentation schematic diagram of the first report unit provided by the embodiments of the present application;
Fig. 5 is the page presentation schematic diagram for the corresponding report page of report unit that Fig. 4 is provided;
Fig. 6 is the page presentation schematic diagram of second of report unit provided by the embodiments of the present application;
Fig. 7 is the page presentation schematic diagram for the corresponding report page of report unit that Fig. 6 is provided;
Fig. 8 is the page presentation schematic diagram of the third report unit provided by the embodiments of the present application;
Fig. 9 is the page presentation schematic diagram for the corresponding report page of report unit that Fig. 8 is provided;
Figure 10 is the functional block diagram of report generation device provided by the embodiments of the present application.
Icon: 100- electronic equipment;110- bus;120- processor;130- storage medium;140- bus interface;150-
Network adapter;160- user interface;200- report generation device;The 210- page insmods;220- page configuration module;
230- report generation module.
Specific embodiment
For technical problem described in above-mentioned background technique, report form generation method provided by the present application passes through building report
Unit passes through building report unit and fills report unit generation data sheet automatically according to data dimension and data metric,
It avoids staff and needs first to construct structure of report in the complex operations that data are filled into structure of report one by one, improve report
Table formation efficiency.
Defect present in the above scheme in the prior art, is that applicant is obtaining after practicing and carefully studying
As a result, therefore, the solution that the discovery procedure of the above problem and hereinafter the embodiment of the present application are proposed regarding to the issue above
Scheme all should be the contribution that applicant makes the application during the application.
To keep the purposes, technical schemes and advantages of the embodiment of the present application clearer, below in conjunction with the embodiment of the present application
In attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is
Some embodiments of the present application, instead of all the embodiments.The application being usually described and illustrated herein in the accompanying drawings is implemented
The component of example can be arranged and be designed with a variety of different configurations.
Therefore, the detailed description of the embodiments herein provided in the accompanying drawings is not intended to limit below claimed
Scope of the present application, but be merely representative of the selected embodiment of the application.Based on the embodiment in the application, this field is common
Technical staff's all other embodiment obtained without creative efforts belongs to the model of the application protection
It encloses.
It should also be noted that similar label and letter indicate similar terms therefore once a certain Xiang Yi in following attached drawing
It is defined in attached drawing, does not then need that it is further defined and explained in subsequent attached drawing.
In the description of the present application, it is also necessary to which explanation is unless specifically defined or limited otherwise, term " setting ",
" connection " shall be understood in a broad sense, for example, it may be being fixedly connected, may be a detachable connection, or be integrally connected;It can be
Mechanical connection, is also possible to be electrically connected;It can be directly connected, two can also be can be indirectly connected through an intermediary
Connection inside element.For the ordinary skill in the art, above-mentioned term can be understood in the application with concrete condition
In concrete meaning.
With reference to the accompanying drawing, it elaborates to some embodiments of the application.In the absence of conflict, following
Key in embodiment and embodiment can be combined with each other.
Referring to Fig. 1, being the structural schematic block diagram of electronic equipment 100 provided by the embodiments of the present application.Electronic equipment 100 can
It is connect using a part as server, and by network protocol with user client communication.
As shown in Figure 1, electronic equipment 100 can make general bus architecture by bus 110 to realize.According to electricity
The concrete application and overall design constraints condition of sub- equipment 100, bus 110 may include any number of interconnection bus and bridge
It connects.Together by various circuit connections, these circuits include processor 120, storage medium 130 and bus interface to bus 110
140.Optionally, electronic equipment 100 can be used bus interface 140 and connect network adapter 150 etc. via bus 110.Net
Network adapter 150 can be used for realizing the signal processing function of physical layer in electronic equipment 100, and pass through network protocol and each use
The connection of family end communication.User interface 160 can connect external equipment, such as: keyboard, display, mouse or control stick etc..Always
Line 110 can also connect various other circuits, such as timing source, peripheral equipment, voltage regulator or management circuit, this
A little circuits are known in the art, therefore are no longer described in detail.
It can replace, electronic equipment 100 may also be configured to generic processing system, such as be commonly referred to as chip, the general place
Reason system includes: to provide the one or more microprocessors of processing function, and provide at least part of of storage medium 130
External memory, it is all these all to be linked together by external bus architecture and other support circuits.
Alternatively, following realize can be used in electronic equipment 100: having processor 120, bus interface 140, user
The ASIC (specific integrated circuit) of interface 160;And it is integrated at least part of the storage medium 130 in one single chip, or
Following realize can be used in person, electronic equipment 100: one or more FPGA (field programmable gate array), PLD are (programmable
Logical device), controller, state machine, gate logic, discrete hardware components, any other suitable circuit or be able to carry out this
Any combination of the circuit of various functions described in application in the whole text.
Wherein, processor 120 is responsible for management bus 110 and general processing (is stored on storage medium 130 including executing
Software).One or more general processors and/or application specific processor can be used to realize in processor 120.Processor 120
Example includes microprocessor, microcontroller, dsp processor and the other circuits for being able to carry out software.It should be by software broadly
It is construed to indicate instruction, data or any combination thereof, regardless of being called it as software, firmware, middleware, microcode, hard
Part description language or other.
Storage medium 130 is illustrated as separating with processor 120 in Fig. 1, however, those skilled in the art be easy to it is bright
White, storage medium 130 or its arbitrary portion can be located at except electronic equipment 100.For example, storage medium 130 may include
Transmission line, the carrier waveform modulated with data, and/or the computer product that separates with radio node, these media can be with
It is accessed by processor 120 by bus interface 140.Alternatively, storage medium 130 or its arbitrary portion can integrate everywhere
It manages in device 120, for example, it may be cache and/or general register.
Following embodiments can be performed in processor 120, specifically, can store report generation device in storage medium 130
200, processor 120 can be used for report generation device 200.
Further, referring to Fig. 2, being a kind of flow diagram of report form generation method provided by the embodiments of the present application,
In the present embodiment, object detection method electronic equipment 100 as shown in Fig. 1 is executed.It should be noted that the embodiment of the present application
The object detection method of offer is not limitation with Fig. 3 and specific order below.The tool of report form generation method provided by the present application
Body process is as follows:
Step S110, response user's operation are loaded into the report layout page, wherein the report layout page includes that report is compiled
It arranges region and report data source, the report data source includes that at least one data dimension and each data dimension are corresponding
Data metric.
It should be noted that data dimension is the basic Component units in report data source, data metric is data dimension pair
The data value answered, for example, Chinese each area can configure when layout China regions car ownership carries out statistical report form
Car ownership for data dimension, each area is configurable to data metric.Data dimension and data read in the application
Amount is not proper data dimension and data metric, and data read magnitude can be worth according at least one data dimension
It arrives, only need to guarantee to confirm when generating report can be according to each data dimension after the data dimension angle value of each data dimension
Angle value uniquely confirms the data read magnitude of corresponding data metric, wherein a data dimension can correspond to multiple data metrics,
But each data metric only one corresponding value in the case where data dimension angle value confirms.
Optionally, a data source may include multiple data dimensions, and each data dimension can be that coordination can also
With hierarchical relationship, for example, being configurable to for each time in the car ownership of China regions and each area of China
Coordination, it is each area in the corresponding each city of each province and province can be hierarchical relationship.
Optionally, step S110 can first respond user's operation and obtain report layout task, then be compiled according to the report
Row's task creation includes the report layout page in report layout region, and obtains the tables of data of the report layout task instruction,
At least one data dimension and the corresponding data metric of each data dimension are finally obtained from the tables of data, and will be described
At least one data dimension and the corresponding data metric of each data dimension are loaded into the report layout page.
Specifically, at work, user creates the report layout page, and chooses the new report layout page and need to utilize
Tables of data.Report form generation method provided by the present application can first respond the operation of user, create the report layout page, and carry
Then the tables of data that access customer is chosen obtains the data metric and data dimension that building data sheet needs according to tables of data,
And data dimension and data metric are loaded into the report layout page, wherein data metric includes measurement labels title and number
According to metric, data dimension includes dimensional labels title and data dimension angle value, data metric include measurement labels title and
Data read magnitude is shown in the report writer page with dimensional labels title and measurement labels title.
Referring to Fig. 3, the report layout page may include report data source region, report layout region and configuring area
Domain, wherein report layout region is made of table to be edited;Report data source region is by each dimension for being shown with tabular form
It spends bookmark name and each measurement labels title is constituted;Configuring area is made of preset visual data manipulation.For example,
Data metric, data dimension and the data being manually entered are distinguished for convenience of user, it can be by data metric and data dimension
Degree is differently shown, for example, adding marker character * before dimensional labels title, marker character # is added before measurement labels title.
In another example when dimensional labels title is loaded into report layout region, interior frame is configurable to red, when measurement labels title carries
Interior frame is configurable to green when entering report layout region.
It optionally, is the workload and work difficulty that reduce related personnel, after selected data table, from the tables of data
The step of middle at least one data dimension of acquisition and each data dimension corresponding data metric, can be by provided by the present application
Report form generation method is automatically performed, and data can be divided into data dimension and data metric according to data type first, is made
For a kind of embodiment, data dimension can be the data of nonnumeric type, and data metric can be the data of data type, and
The data read magnitude of data metric is configured by each data value or is configured to the data dimension angle value of data dimension.Then according to number
Dimensional labels title or measurement labels name are obtained according to the label information (Table Header information, remark information etc.) of dimension or data metric
Claim.
It should be noted that the method for obtaining at least one data dimension and each data dimension can also pass through user
It is loaded into and determines data dimension and data metric.
Based on above-mentioned design, user, can be one when generating report using report form generation method provided by the present application
A maneuverable page carries out, and operation logic is simple, reduces using threshold, the user experience is improved.
Step S120 constructs report unit in report layout region according to the report data source and is the report
Table unit configures expansion mode, wherein includes the data dimension and number for being filled into report layout region in the report unit
According to measurement, the expansion mode includes expansion dimension and expansion direction.
Optionally, the report generation page shown according to Fig. 3 at work can be first by the data dimension and described
Data metric is filled into report layout region, then reports according to constructing in user's operation report layout region after filling
Table unit, and expansion dimension is configured by at least partly data dimension in the data dimension, while configuring each expansion dimension
The expansion direction of degree, to configure expansion mode for the report unit.
At work, each measurement labels title and dimensional labels title that can will be displayed in report data source region
The corresponding position being filled by way of dragging in report layout region, with complete paired data dimension and the data metric
Filling to constructing report unit.Then expanding location and array range are chosen from report layout region, wherein array model
The range being configurable to where the report unit of building is enclosed, expanding location can be to need to extend each position in report unit
It sets, then chooses the data dimension that array range needs to be unfolded in configuring area and be used as expansion dimension, and be each expansion dimension
Configure expansion direction.
It is appreciated that directly constituting data sheet using tables of data, there may be certain limitations, for example, tables of data can
Can be typing in chronological order, and may not be best presentation sequence in current time, for example, in earning report with
Performance index is that effect may also be presented with better in presentation sequence.Based on this, optionally, by the data dimension and described
Data metric was filled into after the step of report layout region, and report form generation method provided by the present application can also be to filling
Data dimension and data metric to report layout region execute screening, sort, establish in function and query processing
One or more combined data manipulations.
Wherein, screening, which can refer to, judges whether corresponding value meets preset rules according to default screening rule, and in report
It is middle to show the value for meeting preset rules;Sequence can refer to and reorders according to the case where numerical value to data, and establishing function can be with
Finger establishes function, and will obtain new data in existing numerical value input function;Query processing can refer to according to inquiry relationship from
Extract corresponding numerical value in tables of data, and handled, above-mentioned processing may include font-weight, font tilt, underline,
Add strikethrough, change one of font color, change background color operation or a variety of operative combinations.
For example, can possess to the corresponding vehicle of time dimension when generating China regions car ownership statistical report form
Amount carries out establishing function operation, establishes least-squares estimation function, and the vehicle population estimation in next time is shown in report
Value;Sorting operation is executed also according to the vehicle population estimated value in next time, by the vehicle population estimated value in next time
Descending sequence reorders to regional dimension;It can also be according to the vehicle population estimated value in next time to area
Dimension carries out screening operation, and the vehicle population estimated value for only retaining a time is greater than 100,000 regional dimension values;It can be with
Query processing is carried out to regional dimension according to the vehicle population estimated value in next time, inquires the vehicle population in next time
Estimated value is greater than 10,000,000 regional dimension values, and executes font-weight to the regional dimension values inquired and add the back of yellow
The operation of scenery.
It optionally, is the readability for promoting data, it is described the data dimension and the data metric to be filled into
After the step of report layout region, report form generation method provided by the present application further includes that basis is filled into report layout area
The data dimension and data metric in domain generate Visual Chart.
At work, each dimension of page configuration and measurement can be configured in Visual Chart, in data sheet
Corresponding Visual Chart is generated, can be generated in report when for example, generating China regions car ownership statistical report form
Line chart, wherein metric will be possessed and be configurable to ordinate, time dimension is configurable to abscissa, and regional dimension can
To be configured to node type.
Based on above-mentioned design, when data sheet is presented, the readability of data in report can be improved, improve in report
The utilization rate of data.
Step S130 fills the report being made of the report unit along the expansion direction in report page to be presented
List element array, while the corresponding data dimension angle value of the report unit is filled in each report unit according to the expansion dimension
And data read magnitude, to generate the report page to be presented.
It should be noted that report cell array is the expansion of report unit as a result, not only including multiple regular arrays
, the same or similar report unit of structure, can also include report unit interior location is unfolded it is irregular
Structure of report, for example, data sheet shown in fig. 5 is regular array, the identical report unit of structure, data shown in Fig. 7
Report is the irregular structure of report that report unit interior location is unfolded.
Optionally, be based on expanding location above-mentioned and array range, can first according to the expansion dimension of expanding location with
And expansion mode constructs multiple irregular structure of report, and each irregular structure of report is then obtained battle array according to array range
Arrange the irregular structure of report presented, such as data sheet shown in Fig. 9.
At work, after obtaining report cell array, each expansion dimension can be first traversed, by the number of the expansion dimension
It is filled into the corresponding report unit of the expansion dimension according to dimension values, the exhibition is then obtained according to the data dimension angle value of the expansion dimension
The corresponding data read magnitude of dimension is opened, and it is to be presented to generate this that the data read magnitude is filled into corresponding report unit
Report page.
Optionally, after the step of generating the report page to be presented, report form generation method provided by the present application may be used also
To save report page.The form wherein saved can for picture format, PDF format, database, in Excel format, webpage page
One or more combinations such as face, with the output format different convenient for users to selection.
Incorporated by reference to Fig. 4~Fig. 9, further report form generation method provided by the present application is illustrated.
Fig. 4 and Fig. 5 are please referred to, the report unit and number of the report unit of student card report (forms data dimension) are illustrated
According to report.
As shown in figure 4, including data dimension " # student number ", data metric " * name " " * institute " " * in the report unit
Not " and " * photo " and the comment " student number ", " gender ", " name " and " institute " for description information, exist
After constituting above-mentioned report unit by drag operation, array range can be configured by entire report unit, and " # school " is set
It is set to expansion dimension, expansion direction is configurable to drops down.
When generating report, the duplication quantity of report unit, shape can be determined with the quantity of data dimension " # student number " first
At report cell array, each report unit then is filled in by the data dimension angle value of " # student number " is corresponding, then according to number
The data read magnitude of the corresponding data metric of the data dimension is confirmed according to dimension values, to obtain data sheet shown in fig. 5.
Optionally, data sheet can be inputted into visualized algorithm file when then exporting, obtains the student card of each student,
And it is saved with picture format.In fabrication, direct " # student number " retrieves corresponding student card, without generating the student of student in real time
Card.
Illustrate again herein, in the application data dimension and data metric be not proper data dimension and
Data metric, the data dimension angle value for not needing two different dimensions can just determine data read magnitude, it is only necessary to guarantee for every
A determining data dimension has data read magnitude corresponding.
Fig. 6 and Fig. 7 are please referred to, the report unit and datagram of a kind of report unit of more data dimension reports are illustrated
Table.
As shown in fig. 6, including data dimension " region # " " area # " and " # year ", data metric in the report unit
" * total amount " and " * increment " and comment " total amount " and " increment ", as an implementation " * increment " can be
The data metric generated and establishing function and calculating " * total amount ", wherein the data dimension of every confirmation one " area # "
The data of value and one " # year " data dimension angle value available one " * total amount " data read magnitude and " * increment "
Metric.The expansion dimension that " region # " " area # " is drops down can be set upon deployment, " # year " is unfolded to the right
Dimension is unfolded, expanding location is respectively " region # " " area # " and the cell where " # year ", because for " area # "
And " # year " there are two measurements are corresponding, then both can set being sequentially generated by shown in Fig. 6 for generation.
Upon deployment, corresponding expansion dimension is unfolded according to along two different expansion directions, is obtained with as shown in Figure 7
Two to table.
Fig. 8 and Fig. 9 are please referred to, the report unit and data of the report unit of another more data dimension reports are illustrated
Report.
Referring to Fig. 8, report unit shown in Fig. 8 more data dimensions " # country " compared with Fig. 6, upon deployment
Entire report unit can be configured to array range, the expansion dimension of entire report unit is " # country ", drops down.
The report of each report unit can be confirmed according to the data dimension of " the # country " of confirmation when generating data sheet
Then structure forms report cell array in an array manner, and corresponding data dimension angle value is inserted corresponding report unit,
It is then filled with corresponding data read magnitude, to generate data sheet shown in Fig. 9.
It should be noted that data dimension can be embedded in comment, such as can be by " the vehicle occupancy volume of (# country)
Gauge outfit of the report " as a report.
It is alternatively possible to which reference two chooses the data dimension conduct in multiple and different directions of array range to the mode of table
Multinomial data sheet array can be generated in expansion dimension.
Report layout area only is dragged in by data dimension and data metric based on report form generation method provided by the present application
Domain, and the expansion mode that each data dimension is arranged produces the complex report forms comprising multistage gauge outfit.It is easy to operate, logic is clear
Clear ease of use personnel use, and improve user experience, avoid staff and construct structure of report and fill report one by one
Complex operations improve report generation efficiency, while when avoiding staff using professional report generation software, it is necessary to utilize
The case where correlative code can just be edited reduces the use difficulty of report form generation method, improves report form generation method
Ease for use.
The embodiment of the present application also provides a kind of report generation device 200, in one embodiment, referring to Fig. 10, being
The functional block diagram of report generation device 200 provided by the embodiments of the present application, report generation device 200 may include following functions mould
Block:
The page insmods 210, is loaded into the report layout page for responding user's operation, wherein the report layout page
Face includes report layout region and report data source, and the report data source includes at least one data dimension and each number
According to the corresponding data metric of dimension;
Page configuration module 220, for constructing report list in report layout region according to the report data source
Member simultaneously configures expansion mode for the report unit, wherein includes the data dimension and the number in the report unit
According to measurement, the expansion mode includes expansion dimension and expansion direction;And
Report generation module 230, for being filled in report page to be presented by the report along the expansion direction
The report cell array that unit is constituted, while the report unit is filled in each report unit according to the expansion dimension and is corresponded to
Data dimension angle value and data read magnitude, to generate the report page to be presented.
Optionally, the page, which insmods, 210 is also used to:
It responds user's operation and obtains report layout task;
According to the report layout task creation include the report layout page in report layout region, and obtains the report
The tables of data of layout task instruction;
At least one data dimension and the corresponding data metric of each data dimension are obtained from the tables of data, and will
At least one described data dimension and the corresponding data metric of each data dimension are loaded into the report layout page.
Optionally, page configuration module 220 is also used to:
The data dimension and the data metric are filled into report layout region;
According to building report unit in the report layout region of user's operation after filling, and will be in the data dimension
At least partly data dimension is configured to expansion dimension, while configuring the expansion direction of each expansion dimension, for the report list
Member configuration expansion mode.
The embodiment of the present application also provides a kind of readable storage medium storing program for executing, and computer program is stored in readable storage medium storing program for executing, meter
Calculation machine program is performed the report form generation method that may be implemented in above-mentioned any means embodiment.
In embodiment provided herein, it should be understood that disclosed device and method, it can also be by other
Mode realize.Device and method embodiment described above is only schematical, for example, flow chart and frame in attached drawing
Figure shows the system frame in the cards of the system of multiple embodiments according to the application, method and computer program product
Structure, function and operation.In this regard, each box in flowchart or block diagram can represent a module, section or code
A part, a part of module, section or code includes one or more for implementing the specified logical function holds
Row instruction.It should also be noted that function marked in the box can also be to be different from some implementations as replacement
The sequence marked in attached drawing occurs.For example, two continuous boxes can actually be basically executed in parallel, they are sometimes
It can execute in the opposite order, this depends on the function involved.It is also noted that every in block diagram and or flow chart
The combination of box in a box and block diagram and or flow chart can use the dedicated base for executing defined function or movement
It realizes, or can realize using a combination of dedicated hardware and computer instructions in the system of hardware.
In addition, each functional module in each embodiment of the application can integrate one independent portion of formation together
Point, it is also possible to modules individualism, an independent part can also be integrated to form with two or more modules.
It should be noted that, in this document, term " including ", " including " or its any other variant are intended to non-row
Its property includes, so that the process, method, article or equipment for including a series of elements not only includes those elements, and
And further include the other elements being not explicitly listed, or further include for this process, method, article or equipment institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence " including one ... ", it is not excluded that including wanting
There is also other identical elements in the process, method, article or equipment of element.
It is obvious to a person skilled in the art that the application is not limited to the details of above-mentioned exemplary embodiment, Er Qie
In the case where without departing substantially from spirit herein or basic key, the application can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and scope of the present application is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the application.Any reference signs in the claims should not be construed as limiting the involved claims.
Claims (10)
1. a kind of report form generation method, which is characterized in that be applied to electronic equipment, which comprises
It responds user's operation and is loaded into the report layout page, wherein the report layout page includes report layout region and report
Table data source, the report data source include at least one data dimension and the corresponding data metric of each data dimension;
Report unit is constructed in report layout region according to the report data source and configures exhibition for the report unit
Evolution formula, wherein include the data dimension and the data metric in the report unit, the expansion mode includes exhibition
Open dimension and expansion direction;
The report cell array being made of the report unit is filled in report page to be presented along the expansion direction, together
When the corresponding data dimension angle value of the report unit and data metric are filled in each report unit according to the expansion dimension
Value, to generate the report page to be presented.
2. report form generation method according to claim 1, which is characterized in that the response user's operation is loaded into report layout
The step of page includes:
It responds user's operation and obtains report layout task;
According to the report layout task creation include the report layout page in report layout region, and obtains the report layout
The tables of data of task instruction;
At least one data dimension and the corresponding data metric of each data dimension are obtained from the tables of data, and will be described
At least one data dimension and the corresponding data metric of each data dimension are loaded into the report layout page.
3. report form generation method according to claim 1, which is characterized in that it is described according to the report data source described
Report unit is constructed in report layout region and includes: the step of configuring expansion mode for the report unit
The data dimension and the data metric are filled into report layout region;
According in the report layout region of user's operation after filling construct report unit, and by the data dimension at least
Partial data dimension is configured to expansion dimension, while configuring the expansion direction of each expansion dimension, to match for the report unit
Set expansion mode.
4. report form generation method according to claim 3, which is characterized in that described by the data dimension and the number
After the step of being filled into the report layout region according to measurement, which comprises
To the data dimension and data metric that are filled into report layout region execute screening, sort, establish function and
One of query processing or the data manipulation of multiple combinations.
5. report form generation method according to claim 3, which is characterized in that described by the data dimension and the number
After the step of being filled into the report layout region according to measurement, which comprises
Visual Chart is generated according to the data dimension and data metric for being filled into report layout region.
6. report form generation method according to claim 1, which is characterized in that it is described according to the expansion dimension in each report
The step of corresponding data dimension angle value of the report unit and data read magnitude are filled in table unit include:
Each expansion dimension is traversed, the data dimension angle value of the expansion dimension is filled into the corresponding report unit of the expansion dimension;
The corresponding data read magnitude of the expansion dimension is obtained according to the data dimension angle value of the expansion dimension, and by the data metric
Value is filled into corresponding report unit.
7. report form generation method according to claim 1, which is characterized in that the generation report page to be presented
After step, the method also includes:
Store the report page.
8. a kind of report generation device, which is characterized in that the report generation device includes:
The page insmods, and is loaded into the report layout page for responding user's operation, wherein the report layout page includes report
Table layout region and report data source, the report data source include at least one data dimension and each data dimension pair
The data metric answered;
Page configuration module, for constructing report unit in report layout region according to the report data source and being institute
State report unit configuration expansion mode, wherein include the data dimension and the data metric, institute in the report unit
Stating expansion mode includes expansion dimension and expansion direction;And
Report generation module is made of for filling in report page to be presented along the expansion direction the report unit
Report cell array, while the corresponding data dimension of report unit is filled in each report unit according to the expansion dimension
Angle value and data read magnitude, to generate the report page to be presented.
9. report generation device according to claim 8, which is characterized in that the page, which insmods, to be also used to:
It responds user's operation and obtains report layout task;
According to the report layout task creation include the report layout page in report layout region, and obtains the report layout
The tables of data of task instruction;
At least one data dimension and the corresponding data metric of each data dimension are obtained from the tables of data, and will be described
At least one data dimension and the corresponding data metric of each data dimension are loaded into the report layout page.
10. report generation device according to claim 8, which is characterized in that the page configuration module is also used to:
The data dimension and the data metric are filled into report layout region;
According in the report layout region of user's operation after filling construct report unit, and by the data dimension at least
Partial data dimension is configured to expansion dimension, while configuring the expansion direction of each expansion dimension, to match for the report unit
Set expansion mode.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811585367.9A CN109684387B (en) | 2018-12-24 | 2018-12-24 | Report generation method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811585367.9A CN109684387B (en) | 2018-12-24 | 2018-12-24 | Report generation method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109684387A true CN109684387A (en) | 2019-04-26 |
CN109684387B CN109684387B (en) | 2021-03-09 |
Family
ID=66188968
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811585367.9A Active CN109684387B (en) | 2018-12-24 | 2018-12-24 | Report generation method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109684387B (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110852050A (en) * | 2020-01-16 | 2020-02-28 | 杭州健戎潜渊科技有限公司 | Method and device for configuring report generation system and electronic equipment |
CN111488089A (en) * | 2020-04-07 | 2020-08-04 | 携程旅游网络技术(上海)有限公司 | Man-machine interaction method and device, storage medium and electronic equipment |
CN111797125A (en) * | 2020-06-12 | 2020-10-20 | 中国建设银行股份有限公司 | Report creating method and device, electronic equipment and computer readable storage medium |
CN113010583A (en) * | 2021-03-02 | 2021-06-22 | 金蝶蝶金云计算有限公司 | Sorting method and device based on report, computer equipment and storage medium |
CN116956847A (en) * | 2023-07-25 | 2023-10-27 | 陕西师范大学 | Report management method and device |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101620591A (en) * | 2009-08-12 | 2010-01-06 | 国网电力科学研究院 | Method for designing module report form layout based on cell mode |
US20100251100A1 (en) * | 2009-03-31 | 2010-09-30 | Yann Delacourt | Primitive-based presentation of dimensional information using layout script |
CN102117296A (en) * | 2009-12-31 | 2011-07-06 | 青岛海尔软件有限公司 | Method for generating dynamic configuration report |
CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
US20160328432A1 (en) * | 2015-05-06 | 2016-11-10 | Squigglee LLC | System and method for management of time series data sets |
CN106528514A (en) * | 2016-10-31 | 2017-03-22 | 山东鲁能软件技术有限公司 | Report generation system and method |
CN106776644A (en) * | 2015-11-24 | 2017-05-31 | 大唐软件技术股份有限公司 | A kind of reporting system collocation method and device |
WO2018144543A1 (en) * | 2017-02-01 | 2018-08-09 | Anvizent Analytics Pvt., LTD | Big data analytical platform tools and methods of use |
-
2018
- 2018-12-24 CN CN201811585367.9A patent/CN109684387B/en active Active
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20100251100A1 (en) * | 2009-03-31 | 2010-09-30 | Yann Delacourt | Primitive-based presentation of dimensional information using layout script |
CN101620591A (en) * | 2009-08-12 | 2010-01-06 | 国网电力科学研究院 | Method for designing module report form layout based on cell mode |
CN102117296A (en) * | 2009-12-31 | 2011-07-06 | 青岛海尔软件有限公司 | Method for generating dynamic configuration report |
CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
US20160328432A1 (en) * | 2015-05-06 | 2016-11-10 | Squigglee LLC | System and method for management of time series data sets |
CN106776644A (en) * | 2015-11-24 | 2017-05-31 | 大唐软件技术股份有限公司 | A kind of reporting system collocation method and device |
CN106528514A (en) * | 2016-10-31 | 2017-03-22 | 山东鲁能软件技术有限公司 | Report generation system and method |
WO2018144543A1 (en) * | 2017-02-01 | 2018-08-09 | Anvizent Analytics Pvt., LTD | Big data analytical platform tools and methods of use |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110852050A (en) * | 2020-01-16 | 2020-02-28 | 杭州健戎潜渊科技有限公司 | Method and device for configuring report generation system and electronic equipment |
CN111488089A (en) * | 2020-04-07 | 2020-08-04 | 携程旅游网络技术(上海)有限公司 | Man-machine interaction method and device, storage medium and electronic equipment |
CN111797125A (en) * | 2020-06-12 | 2020-10-20 | 中国建设银行股份有限公司 | Report creating method and device, electronic equipment and computer readable storage medium |
CN113010583A (en) * | 2021-03-02 | 2021-06-22 | 金蝶蝶金云计算有限公司 | Sorting method and device based on report, computer equipment and storage medium |
CN116956847A (en) * | 2023-07-25 | 2023-10-27 | 陕西师范大学 | Report management method and device |
Also Published As
Publication number | Publication date |
---|---|
CN109684387B (en) | 2021-03-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109684387A (en) | Report generation method and device | |
CN105867931B (en) | The variation and device at information displaying interface | |
CN104520877B (en) | Hand-written rendering apparatus and method | |
US6292766B1 (en) | Simulation tool input file generator for interface circuitry | |
CN111125560B (en) | Data visualization processing method, device and computer system | |
CN107153544A (en) | A kind of Worksheet self-defining method and device | |
US20080109780A1 (en) | Method of and apparatus for optimal placement and validation of i/o blocks within an asic | |
CN103617047A (en) | Method, device and processor for developing business processes | |
CN109063829A (en) | Neural network construction method, device, computer equipment and storage medium | |
CN109697064A (en) | A kind of generation method and device of the customized page | |
CN105447098B (en) | A kind of information query method and device | |
CN105653507A (en) | Chart generation method and device | |
CN103729713A (en) | Audit result display configuration method and device | |
CN105389184B (en) | The configuration method and device of Product Interface information | |
CN116468010A (en) | Report generation method, device, terminal and storage medium | |
CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
Mu et al. | Mapping uncertain geographical attributes: incorporating robustness into choropleth classification design | |
CN111367514B (en) | Page card development method and device, computing device and storage medium | |
CN107562825A (en) | A kind of system and method for generating data display interface | |
Kim et al. | Developing a flow mapping module in a GIS environment | |
CN104182226A (en) | General mobile information system adaptation method and device | |
CN102866985B (en) | For data formatter and the method for on-line analysing processing system | |
CN101719157A (en) | Data filtering method, system and data processing device used for system | |
CN104199648A (en) | General mobile information system adaptation method and device | |
CN116956847A (en) | Report management 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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |