CN105843945A - Report generation method and system - Google Patents
Report generation method and system Download PDFInfo
- Publication number
- CN105843945A CN105843945A CN201610217609.3A CN201610217609A CN105843945A CN 105843945 A CN105843945 A CN 105843945A CN 201610217609 A CN201610217609 A CN 201610217609A CN 105843945 A CN105843945 A CN 105843945A
- Authority
- CN
- China
- Prior art keywords
- sql
- report
- user
- data set
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2445—Data retrieval commands; View definitions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a report generation method and system. The method comprises the following steps: a corresponding report configuration template and data source are acquired according to a report generation request of a user; a target data set is determined from the data source through a dynamically generated SQL (structured query language), wherein the dynamically generated SQL is formed by assembling query parameters input by the user, query conditions configured by the user on the report configuration template and stand SQL statements; the target data set is subjected to visualization processing according to a preset view style, a view-shaped report is generated, and the report generation method is used for solving the problems that a report generation method in the prior art is too specialized and the operation difficulty is greater.
Description
Technical field
The present invention relates to field of computer technology, particularly relate to a kind of report form generation method and system.
Background technology
Form is indispensable a kind of data exhibiting mode in enterprise application system, and it can be that user is special
Be enterprise user on the middle and senior level provide intuitively Data View (carry out automatic statistical computation, as sued for peace, being averaging,
Packet is carried out extensions and footings etc.), formulate commercial plan for user and decision-making provides basis and foundation.Form
Also it is one of mode realizing data visualization in business intelligence application simultaneously.Especially at current big data age,
Enterprise needs mass data is extracted, analyzes, monitors and excavated potential business opportunities, Qi Zhongye
Needing especially to present data visualization, these all become the most important research topic.The most a set of spirit
Alive and powerful reporting system can be enterprise (the Internet of the biggest data age and mobile interchange
Net enterprise) bring the tremendous increase of the productivity.
In prior art, generate as a example by form by webfocus report tool, first using the table as data source
It is mapped as the mapped file of a table field level, then employing pulls the mode of attribute in mapped file and forms Excel
The visual configuration mode of formula, but the shortcoming of this configuration mode is: at the existing number of big data age
Strengthening according to the relatedness between source, the type of database variation of Data Source, existing pulling maps literary composition
The method of part cannot complete the complex query that some database functions could realize.At this moment prior art also needs to
The implementation language of the webfocus specified by instrument further encodes, and can generate the form of coupling
Pattern.Generate the process specialization of the report style mated relatively by force owing to utilizing schedule language to carry out coding, lead
Cause this domestic consumer had undoubtedly to bigger operation easier and operate relatively complicated.
Therefore, need a kind of report form generation method badly, generate the collocation method mistake of form in order to solve prior art
In specialization, the problem that operation easier is bigger.
Summary of the invention
The embodiment of the present invention provides a kind of report form generation method and system, generates form in order to solve prior art
Collocation method the most specialized, problem that operation easier is bigger.
The inventive method includes a kind of report form generation method, and the method includes: the generation form according to user please
Ask, obtain corresponding form configuration template and data source；
From described data source, target data set is determined by the SQL SQL dynamically generated,
Wherein, the SQL of described dynamic generation is that the query argument that inputted by described user, user join at described form
Put in template the querying condition of configuration and stsndard SQL statement is assemblied to form；
According to default view pattern, described target data set is carried out visualization processing, generate view shape
Form.
Based on same inventive concept, the embodiment of the present invention provides a kind of report generating system further, should
System includes:
Acquiring unit, for the generation report request according to user, obtains corresponding form configuration template sum
According to source；
Determine unit, determine from described data source for the SQL SQL by dynamically generating
Target data set, wherein, the SQL of described dynamic generation is query argument, the use inputted by described user
Querying condition that family configures on described form configuration template and stsndard SQL statement are assemblied to form；
Signal generating unit, for described target data set being carried out visualization processing according to the view pattern preset,
Generate the form of view shape.
The report generation instruction that the embodiment of the present invention sends according to user, obtains data source from data base, continues
And from described data source, obtain target data set by SQL, carry out according to the report form template preset institute
State target data set and carry out visualization processing, generate the form of view shape.This method is by utilizing SQL
Statement instead of prior art and pulls the mode of mapped file, because can be used in combination number in SQL statement
According to the proprietary data built-in function in storehouse, such that it is able to realize in more complicated inquiry, and this process is not
Need the language using report tool to encode, reached zero code development and generated the purpose of form, it is seen that
This method, for common report making user, is easily mastered, and easy and simple to handle.
Accompanying drawing explanation
For the technical scheme being illustrated more clearly that in the embodiment of the present invention, institute in embodiment being described below
The accompanying drawing used is needed to briefly introduce, it should be apparent that, the accompanying drawing in describing below is only the present invention's
Some embodiments, from the point of view of those of ordinary skill in the art, on the premise of not paying creative work,
Other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 provides a kind of report tool configuration diagram for the embodiment of the present invention；
Fig. 2 provides a kind of report form generation method schematic flow sheet for the embodiment of the present invention；
Fig. 3 provides a kind of form configuration interface interaction figure for the embodiment of the present invention；
Fig. 4 is for providing a kind of report form template configuration interface interaction figure for the embodiment of the present invention；
Fig. 5 provides a kind of report generation device schematic flow sheet for the embodiment of the present invention.
Detailed description of the invention
In order to make the object, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing to this
Bright it is described in further detail, it is clear that described embodiment is only some embodiments of the present invention,
Rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art are not doing
Go out all other embodiments obtained under creative work premise, broadly fall into the scope of protection of the invention.
Report tool is to provide the user form exploitation and the platform of form displaying, and the principle of report tool is root
From selected data source, obtain data according to the demand of user and be packaged into the form (web (webpage) of user's request
The page, EXCEL, PDF or picture) feed back to user, allow users to data are carried out computational analysis
And assist the purpose of its work.The report form generation method that the embodiment of the present invention provides is based on form newly developed
Instrument, by carrying out configuring and then generating the form of user's view shape to be generated on new report tool.
Developer realizes multiple configuration page by report tool, can realize configuration in configuration page list
Report name, data source, SQL, querying condition and some patterns, preserve after preview is errorless, and form configures
Template can be saved in reporting system with xml form.When user needs to use certain form configuration template,
Need sign in another operation system and enter into query page, input some query arguments, click on inquiry
Button, at this moment operation system (can include the inquiry ginseng that user inputs to the url of reporting system transmission report request
Number).Reporting system can find the form configuration specified upon receiving a request, by looking into of query argument and configuration
Inquiry condition coupling is assemblied into complete SQL again with SQL, perform SQL query data encapsulation of data in conjunction with
The view pattern of configuration, the form assembling generation view shape returns to operation system, in order to show user.
It addition, the form result generated by the embodiment of the present invention is stored in server end, the mesh of do so
Be easy for support multi-person synergy exploitation, additionally server end storage on form can be drawn by different users
With, it is to avoid repeatedly generate form.
Before introducing the report form generation method of the embodiment of the present invention, introduce report tool newly developed in advance
System architecture, as it is shown in figure 1, this framework specifically includes that presentation layer, infrastructure layer, Data Persistence Layer.
Wherein, infrastructure layer includes: the configuration of parameter configuration, data source, template configuration, form configuration, form
Preview, abnormality processing.
The report tool realized by above-mentioned architecture can be embodied by the surface chart of multiple man-machine interactions, its
In, comprise multiple control above the interaction figure of form configuration, be mainly used to realize configuration report name, SQL
Statement, dynamic WHERE condition, gauge outfit, total, each field type pattern and lower brill etc..Additionally
Also including, the interaction figure of report form template configuration, the form for the shape such as figure and form generates correspondence respectively
Template, each template is with the form of plug-in unit, and such as JSP form saves.
Based on above-mentioned report tool, the embodiment of the present invention provides a kind of report form generation method schematic flow sheet, ginseng
As shown in Figure 2, specifically implementation method includes:
Step S101, according to the generation report request of user, obtains corresponding form configuration template and data source.
Step S102, determines target by the SQL SQL dynamically generated from described data source
Data acquisition system, wherein, the SQL of described dynamic generation is query argument, the Yong Hu inputted by described user
The querying condition configured on described form configuration template and stsndard SQL statement are assemblied to form.
Step S103, carries out visualization processing according to default view pattern to described target data set, raw
Become the form of view shape.
In step S101, the generation report request of user is that user operates on report tool, selects
The instruction that the control of corresponding newly-built form sends, carries data source ingress path, need in report request
Form configuration template type etc. to be used.Therefore, according to the generation report request of user, obtain from internal memory
Take form configuration template to be used and data source.
Specifically, after receiving the newly-built statement instruction that user sends, the server at this report tool place
This newly-built statement instruction can be responded, show the first interactive interface, as it is shown on figure 3, wherein, described first
Interactive interface inputs the first information of SQL query parameter, instruction user's input including at least instruction user
Second information of the report form template type needed for described newly-built form, instruction user input described newly-built report
3rd information of the data source needed for table.
It is emphasized that for indicate user input form permissible according to the first information of data source
Be include Text Entry information so that user can with hand input-data source, or, including close
In the information of drop-down list of each data source so that user selects required data source.Equally
, the second information of the distribution form needed for indicating user to input this form can be to include text
The information of input frame so that user can be manually entered distribution form, or, including about layout shape
The information of the drop-down list of formula is so that user selects required distribution form.And be used for indicating use
3rd information of family input SQL query instruction can be to include carrying of SQL query statement editing interface
Show information so that user inputs this SQL query statement in this editing interface.In Fig. 3 the three of arrow indication
Individual control, refers to mentioned above three information, and user at least goes out to select phase at data source control
The path of the form answered；Simultaneously select post figure in a template according to the demand of client, or other shape
Template, it addition, at SQL control, input corresponding query statement.Wherein, in Fig. 3, under SQL
Side also has the control of querying condition, and this control can realize WHERE conditional statement function, and user can root
According to the adaptive interpolation of needs or deletion.
Assume that user needs to comprise the data sheet of A1, A2, B3, B4 and C4 data, this data sheet
Required data are stored in data base, including Table A, table B, table C, wherein, Table A include A1, A2,
A3, A4, table B includes B1, B2, B3, B4, and table C includes C1, C2, C3, C4, in datagram
Table needs to represent the information of A1, A2, B3, B4 and C4, its SQL (Structured Query
Language, SQL) statement can be written as: Select A1, A2, B3, B4, C4From A, B, C Where
A1=B1 And A1=C1, wherein Table A, table B, table C are as shown in content in following table.
Table A:
| Student number (A1) | Name (A2) | Chinese language (A3) | Mathematics (A4) |
| 001 | Zhang San | 89 | 90 |
| 002 | Li Si | 90 | 78 |
| 003 | King five | 92 | 86 |
Table B:
| Student number (B1) | Contact method (B2) | Home address (B3) | Birthday (B4) |
| 001 | 130xxxxx | Shanghai City xxxxx | 1987.1 |
| 002 | 133xxxxx | Shandong Province xxxxx | 1988.6 |
| 003 | 135xxxxx | Beijing xxxxx | 1985.3 |
Table C:
| Student number (C1) | Sex (C2) | Cut classes number of times (C3) | Sports performance (C4) |
| 001 | Female | Nothing | 60 |
| 002 | Female | 5 | 90 |
| 003 | Man | 1 | 95 |
Knowable to Table A, table B, table C, A1, B1, C1, A2, B3, B4, C4 are respectively present in table
In A, B, C, therefore by conditional statement Where A1=B1 And A1=C1 by information common in three tables
Series connection obtains about A1, the query statement of A2, B3, B4, C4.In conjunction with this example, provide at Fig. 3
Interface alternation figure in, can go out to select Table A, table B, path corresponding for table C in data source, and at SQL
Middle input Select A1, A2, B3, B4, C4 From A, B, C, go out can join at querying condition control
Putting the conditional statements such as A1=B1, A1=C1, so, system resolves above-mentioned SQL statement and inquiry bar on backstage
Part, determines the field in described data source by resolving the query argument of described user input, and according to described
Querying condition determines the scope of form cell corresponding to described field；According to filling out in described form cell
Make up the number according to determining target data set.The field included such as Table A has student number, name, Chinese language, mathematics；
The field that table B includes has student number, contact method, home address, birthday；The field that table C includes has
Student number, sex, cut classes number of times, sports performance etc..According to querying condition backstage resolve it is known that from Table A,
Table B, table C find student number, name, home address, birthday, these five fields of sports performance corresponding
Target data set, i.e. following table:
It addition, the configuration of parameter replacement can also be carried out in querying condition control, replace the configuration of described form
Field in original SQL statement in template；Resolve the SQL after replacing, determine the word in described data source
Section；And the scope of form cell corresponding to described field is determined according to described querying condition；According to described report
Filling data in table unit lattice determine target data set.
Such as, containing the SQL statement template preset in the form configuration page of acquisition, because report to be generated
Table is the renewal of part field on the basis of original report generation, so now can be to original SQL language
Sentence template carries out parameter replacement, the argument section that the most original SQL statement template is as follows, to be replaced
Mark with #.
select*
from A a
Left join B b on b.id=a.id
Where A.name='#student_name#'；
Such as input " Zhang San " as user in # marked content, then SQL is dynamically generated by parameter Exchange rings
Complete S QL is:
select*
from A a
Left join B b on b.id=a.id
Where A.name=' Zhang San '；
Also the replacement or to tables of data, original SQL statement template is as follows, parameter portion to be replaced
Divide and mark with #.
select*
from #table_name# a
Left join B b on b.id=a.id
Where A.name=' Zhang San '；
When the table name of user's input is " C ", then SQL is dynamically generated as:
select*
from C a
Left join B b on b.id=a.id
Where A.name=' Zhang San '；
It is understood that this interactive interface can also be shown other information, such as: be used for indicating execution
The button of this SQL query statement, for indicating the information of input report name, for indicating current shape
The information (such as: editing mode) etc. of state, this is all rational.
Further, since service needed, we to do some special inquiries, but data base itself does not carry
For this function, therefore we need self-defining function (some data bases provide UDF interface, can make by oneself
Justice function), such as we need to do the inquiry of the field Chinese fuzzy matching in 2 tables, and we are the most self-defined
One function SIMILARITY_SUITED, SQL is as follows:
SELECT T1.*
FROM TABLE_A T1
LEFT JOIN TABLE_B T2 ON T2.ID=T1.ID
WHERE SIMILARITY_SUITED(T1.NAME,T2.NAME)；
Reason for this is that the target data set that traditional report tool is chosen by the way of pulling, can only
The function enough using this data base to point out processes, and does not support the inquiry that some are special, if in tradition
Report tool in realize above-mentioned query function, then need the language using this report tool to encode.
So the embodiment of the present invention by loading the self-defining function needing to use in SQL statement, then can complete phase
The complicated inquiry answered is to reach the purpose of quick search and user-friendly.
Further, it is determined that the field attribute corresponding with default view pattern, described field attribute at least wraps
Include geometric size, geometric coordinate, color parameter information, show directional information；
Obtain the field attribute value of the view pattern of user's input, generate target report according to described field attribute value
Table sample formula；Form by described target data set Yu described target report style combination producing view shape.
Specifically, the such as interface alternation figure shown in Fig. 4, if user to be generated be block diagram, then may be used
To be selected the view pattern of block diagram by this interface, such as the height of block diagram, width, color etc., additionally
Can also select this block diagram is horizontal layout, or the vertically direction such as layout.Meanwhile, at this interactive interface
In, it is also possible to comprise other informations for last block diagram shape, such as whether can pull, supply
User selects.
It should be noted that described view pattern at least includes grid form, Cross Report, block diagram, folding
Line chart, pie chart, scatterplot.For the report form template of multi-form, all there is the configuration that corresponding parameter is arranged
Selecting for user, the form of the view shape therefore ultimately produced more is fitted the needs of user.
Thered is provided in the embodiment of the present invention is the report generation mode of complete list configuration, can configure complexity
SQL statement and dynamic queries function is provided, support disparate databases own special function, development process
Realize zero code development.The loading display of form uses JSP based on third party's assembly (jQgrid and Echarts)
The data of SQL query are directly assembled in corresponding template aobvious by the mode of template with the Show Styles of configuration
Show, superior performance.
For the process of the above-mentioned report generation that more describes in a systematic way, the embodiment of the present invention provides such as further
Lower block diagram is illustrated.
Step one, the passwords such as user passes through web page login system, input username and password enter system.
Step 2, by form configuration template input SQL statement and query statement, system background resolves above-mentioned
Instruction, obtains target data set.
Step 3, opens report form template, configures accordingly according to the configuration item in report form template, is not required to
Configuration item to be configured just can retain default value, the report style of combination configuration then and target data set
Generate final form.
Step 4, by the form result of above-mentioned generation to be saved in configuration database and to be loaded into internal memory.
Based on identical technology design, the embodiment of the present invention also provides for a kind of report generating system, and this system can
Perform said method embodiment.The system that the embodiment of the present invention provides is as it is shown in figure 5, include: acquiring unit
501, unit 502, signal generating unit 503 are determined, wherein:
Acquiring unit 501, for according to the generation report request of user, obtain corresponding form configuration template and
Data source；
Determine unit 502, for the SQL SQL by dynamically generating from described data source
Determine target data set, wherein, the SQL of described dynamic generation be inputted by described user query argument,
Querying condition that user configures on described form configuration template and stsndard SQL statement are assemblied to form；
Signal generating unit 503, for carrying out at visualization described target data set according to the view pattern preset
Reason, generates the form of view shape.
Further, described determine unit 502 specifically for by resolve described user input query argument
Determine the field in described data source, and determine, according to described querying condition, the form unit that described field is corresponding
The scope of lattice；Target data set is determined according to the filling data in described form cell.
Further, described querying condition also includes that parameter replaces configuration, described determines that unit 502 is additionally operable to:
Replace the field in original SQL statement in described form configuration template；Resolve the SQL after replacing, determine
Field in described data source；And determine form cell corresponding to described field according to described querying condition
Scope；Target data set is determined according to the filling data in described form cell.
Further, described signal generating unit 503 is specifically for word corresponding to view pattern that determine with preset
Section attribute, described field attribute at least includes geometric size, geometric coordinate, color parameter information, displaying side
To information；
Obtain the field attribute value of the view pattern of user's input, generate target report according to described field attribute value
Table sample formula；
Form by described target data set Yu described target report style combination producing view shape.
Wherein, described view pattern at least includes grid form, Cross Report, block diagram, broken line graph, cake
Figure, scatterplot.
The present invention is with reference to method, equipment (system) and computer program according to embodiments of the present invention
Flow chart and/or block diagram describe.It should be understood that can by computer program instructions flowchart and/
Or flow process in each flow process in block diagram and/or square frame and flow chart and/or block diagram and/or
The combination of square frame.These computer program instructions can be provided to general purpose computer, special-purpose computer, embedded
The processor of datatron or other programmable data processing device is to produce a machine so that pass through computer
Or the instruction that the processor of other programmable data processing device performs produces for realizing at flow chart one stream
The device of the function specified in journey or multiple flow process and/or one square frame of block diagram or multiple square frame.
These computer program instructions may be alternatively stored in and can guide computer or other programmable data processing device
In the computer-readable memory worked in a specific way so that be stored in this computer-readable memory
Instruction produces the manufacture including command device, and this command device realizes at one flow process of flow chart or multiple stream
The function specified in journey and/or one square frame of block diagram or multiple square frame.
These computer program instructions also can be loaded in computer or other programmable data processing device, makes
Sequence of operations step must be performed to produce computer implemented place on computer or other programmable devices
Reason, thus the instruction performed on computer or other programmable devices provides for realizing flow chart one
The step of the function specified in flow process or multiple flow process and/or one square frame of block diagram or multiple square frame.
Although preferred embodiments of the present invention have been described, but those skilled in the art once know base
This creativeness concept, then can make other change and amendment to these embodiments.So, appended right is wanted
Ask and be intended to be construed to include preferred embodiment and fall into all changes and the amendment of the scope of the invention.
Obviously, those skilled in the art can carry out various change and modification without deviating from this to the present invention
Bright spirit and scope.So, if the present invention these amendment and modification belong to the claims in the present invention and
Within the scope of its equivalent technologies, then the present invention is also intended to comprise these change and modification.
Claims (10)
1. a report form generation method, it is characterised in that the method includes:
Generation report request according to user, obtains corresponding form configuration template and data source；
From described data source, target data set is determined by the SQL SQL dynamically generated,
Wherein, the SQL of described dynamic generation is that the query argument that inputted by described user, user join at described form
Put in template the querying condition of configuration and stsndard SQL statement is assemblied to form；
According to default view pattern, described target data set is carried out visualization processing, generate view shape
Form.
2. the method for claim 1, it is characterised in that the described SQL by dynamically generating from
Described data source determines target data set, including:
The field in described data source is determined by resolving the query argument of described user input, and according to described
Querying condition determines the scope of form cell corresponding to described field；
Target data set is determined according to the filling data in described form cell.
3. the method for claim 1, it is characterised in that described querying condition includes that parameter is replaced and joins
Putting, the described SQL by dynamically generating determines target data set from described data source, also includes:
Replace the field in original SQL statement in described form configuration template；
Resolve the SQL after replacing, determine the field in described data source；And determine according to described querying condition
The scope of the form cell that described field is corresponding；
Target data set is determined according to the filling data in described form cell.
4. the method for claim 1, it is characterised in that according to default view pattern to described mesh
Mark data acquisition system carries out visualization processing, generates the form of view shape, including:
Field attribute corresponding to view pattern determined and preset, described field attribute at least include geometric size,
Geometric coordinate, color parameter information, displaying directional information；
Obtain the field attribute value of the view pattern of user's input, generate target report according to described field attribute value
Table sample formula；
Form by described target data set Yu described target report style combination producing view shape.
5. the method as described in any one of Claims 1 to 4, it is characterised in that described view pattern at least wraps
Purse rope lattice form, Cross Report, block diagram, broken line graph, pie chart, scatterplot.
6. a report generating system, it is characterised in that this system includes:
Acquiring unit, for the generation report request according to user, obtains corresponding form configuration template sum
According to source；
Determine unit, determine from described data source for the SQL SQL by dynamically generating
Target data set, wherein, the SQL of described dynamic generation is query argument, the use inputted by described user
Querying condition that family configures on described form configuration template and stsndard SQL statement are assemblied to form；
Signal generating unit, for described target data set being carried out visualization processing according to the view pattern preset,
Generate the form of view shape.
7. system as claimed in claim 6, it is characterised in that described determine unit specifically for:
The field in described data source is determined by resolving the query argument of described user input, and according to described
Querying condition determines the scope of form cell corresponding to described field；
Target data set is determined according to the filling data in described form cell.
8. system as claimed in claim 6, it is characterised in that described querying condition also includes that parameter is replaced
Configuration, described determines that unit is additionally operable to:
Replace the field in original SQL statement in described form configuration template；
Resolve the SQL after replacing, determine the field in described data source；And determine according to described querying condition
The scope of the form cell that described field is corresponding；
Target data set is determined according to the filling data in described form cell.
9. system as claimed in claim 6, it is characterised in that described signal generating unit specifically for:
Field attribute corresponding to view pattern determined and preset, described field attribute at least include geometric size,
Geometric coordinate, color parameter information, displaying directional information；
Obtain the field attribute value of the view pattern of user's input, generate target report according to described field attribute value
Table sample formula；
Form by described target data set Yu described target report style combination producing view shape.
10. the system as described in any one of claim 6～9, it is characterised in that described view pattern is at least
Including grid form, Cross Report, block diagram, broken line graph, pie chart, scatterplot.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610217609.3A CN105843945A (en) | 2016-04-08 | 2016-04-08 | Report generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610217609.3A CN105843945A (en) | 2016-04-08 | 2016-04-08 | Report generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105843945A true CN105843945A (en) | 2016-08-10 |
Family
ID=56597937
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610217609.3A Pending CN105843945A (en) | 2016-04-08 | 2016-04-08 | Report generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105843945A (en) |
Cited By (67)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106445901A (en) * | 2016-09-28 | 2017-02-22 | 医渡云（北京）技术有限公司 | Method and device for designing case report form |
| CN106528514A (en) * | 2016-10-31 | 2017-03-22 | 山东鲁能软件技术有限公司 | Report generation system and method |
| CN106570117A (en) * | 2016-11-02 | 2017-04-19 | 国网山东省电力公司物资公司 | Form control system and method based on electric power material distributing system |
| CN106570118A (en) * | 2016-11-02 | 2017-04-19 | 国网山东省电力公司物资公司 | Report data processing system and method based on electric power material distribution mobile platform |
| CN106776769A (en) * | 2016-11-23 | 2017-05-31 | 天脉聚源（北京）科技有限公司 | A kind of method and device of dynamic generation chart |
| CN107391652A (en) * | 2017-07-17 | 2017-11-24 | 山东浪潮通软信息科技有限公司 | A kind of templating form interface defines system and method |
| CN107480168A (en) * | 2017-06-27 | 2017-12-15 | 石化盈科信息技术有限责任公司 | A kind of Cross Report based on LIMS realizes system |
| CN107491431A (en) * | 2017-08-31 | 2017-12-19 | 精硕科技（北京）股份有限公司 | List method to set up and device |
| CN107609109A (en) * | 2017-09-13 | 2018-01-19 | 山东浪潮云服务信息科技有限公司 | A kind of report form generation method, device and system |
| CN107798026A (en) * | 2016-09-05 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN108009213A (en) * | 2017-11-13 | 2018-05-08 | 深圳市海云天教育测评有限公司 | A kind of method and device of Mass production Word document |
| CN108038180A (en) * | 2017-12-07 | 2018-05-15 | 国网四川省电力公司信息通信公司 | The method that a kind of power supply region gathered data visualizes |
| CN108132945A (en) * | 2016-12-01 | 2018-06-08 | 百度在线网络技术（北京）有限公司 | For generating the method and apparatus of report |
| CN108170713A (en) * | 2017-11-30 | 2018-06-15 | 东软集团股份有限公司 | The method, apparatus and storage medium and electronic equipment of data displaying |
| CN108170655A (en) * | 2017-12-26 | 2018-06-15 | 平安科技（深圳）有限公司 | Production method, device, terminal device and the storage medium of Visual Report Forms |
| CN108334321A (en) * | 2017-01-18 | 2018-07-27 | 阿里巴巴集团控股有限公司 | The presentation device of program code, method and device |
| CN108536342A (en) * | 2017-03-02 | 2018-09-14 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN108647316A (en) * | 2018-05-10 | 2018-10-12 | 北京中电普华信息技术有限公司 | Data processing method and device |
| CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
| CN108694179A (en) * | 2017-04-06 | 2018-10-23 | 北京宸瑞科技股份有限公司 | Personage's view analysis system based on attribute extraction and method |
| CN108804402A (en) * | 2017-04-28 | 2018-11-13 | 北京京东尚科信息技术有限公司 | Report generating system based on big data platform and method |
| CN108829653A (en) * | 2018-05-04 | 2018-11-16 | 山东中创软件工程股份有限公司 | A kind of generation method of report, device, equipment and medium |
| CN108984506A (en) * | 2018-08-01 | 2018-12-11 | 北京中电普华信息技术有限公司 | A kind of generation method and device of configurable intelligent report forms |
| CN109033173A (en) * | 2018-06-21 | 2018-12-18 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of multidimensional index data |
| CN109165238A (en) * | 2018-06-21 | 2019-01-08 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of cyclical indicator data |
| CN109213776A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109388400A (en) * | 2018-10-29 | 2019-02-26 | 深圳同耕科技股份有限公司 | A kind of automatic production of HTML page method and device |
| CN109460542A (en) * | 2018-01-15 | 2019-03-12 | 安徽七禾软件有限公司 | A kind of grain and oil report form generation method and system |
| CN109492056A (en) * | 2018-10-24 | 2019-03-19 | 江苏满运软件科技有限公司 | A kind of method and system of business intelligence data inquiry |
| CN109739906A (en) * | 2018-11-21 | 2019-05-10 | 深圳市佰仟金融服务有限公司 | A kind of report form generation method and system |
| CN109783426A (en) * | 2018-12-14 | 2019-05-21 | 深圳壹账通智能科技有限公司 | Acquire method, apparatus, computer equipment and the storage medium of data |
| CN109800255A (en) * | 2018-12-29 | 2019-05-24 | 北京奇安信科技有限公司 | A kind of generation method of Visual Report Forms, system, equipment and medium |
| WO2019109485A1 (en) * | 2017-12-08 | 2019-06-13 | 平安科技（深圳）有限公司 | Echarts tool-based chart making method, apparatus and device, and medium |
| CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
| CN110019395A (en) * | 2017-11-30 | 2019-07-16 | 北京神州泰岳软件股份有限公司 | A kind of implementation method and device for inquiring ElasticSearch |
| CN110222321A (en) * | 2019-04-16 | 2019-09-10 | 中国平安人寿保险股份有限公司 | Report form generation method, device, computer installation and computer readable storage medium |
| CN110232178A (en) * | 2019-05-29 | 2019-09-13 | 北京中亦安图科技股份有限公司 | Report generation method and device |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN110413974A (en) * | 2019-07-26 | 2019-11-05 | 北京恒华伟业科技股份有限公司 | Form template configuration and device, table deriving method and device |
| CN110442595A (en) * | 2019-07-26 | 2019-11-12 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of general SQL report data collection building |
| CN110472207A (en) * | 2018-05-10 | 2019-11-19 | 北京京东尚科信息技术有限公司 | List generation method and device |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN110851173A (en) * | 2019-11-18 | 2020-02-28 | 中国银行股份有限公司 | Report generation method and device |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| WO2020083358A1 (en) * | 2018-10-25 | 2020-04-30 | 北京数安鑫云信息技术有限公司 | Visualized service data operating system, method, device and medium |
| CN111126026A (en) * | 2019-12-17 | 2020-05-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111126019A (en) * | 2019-11-28 | 2020-05-08 | 泰康保险集团股份有限公司 | Report generation method and device based on mode customization and electronic equipment |
| CN111143433A (en) * | 2019-12-10 | 2020-05-12 | 中国平安财产保险股份有限公司 | Method and device for counting data of data bins |
| CN111177231A (en) * | 2019-12-20 | 2020-05-19 | 中国建设银行股份有限公司 | Report generation method and report generation device |
| CN111176634A (en) * | 2020-01-17 | 2020-05-19 | 天阳宏业科技股份有限公司 | Method and device for configurable embeddable high-tube view |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
| CN111291543A (en) * | 2018-11-21 | 2020-06-16 | 北京国双科技有限公司 | Data display method and device, storage medium and processor |
| CN111552712A (en) * | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method and device and computer equipment |
| CN111625219A (en) * | 2020-05-22 | 2020-09-04 | 杭州指令集智能科技有限公司 | BO component processing method, device and equipment |
| CN111967234A (en) * | 2020-07-29 | 2020-11-20 | 深圳市麦谷科技有限公司 | Visual report generation method and device, terminal equipment and storage medium |
| CN112434100A (en) * | 2020-11-20 | 2021-03-02 | 航天信息股份有限公司企业服务分公司 | Method and system for realizing dynamic display of columns and multiple conditions and dynamic multi-latitude query |
| CN112667716A (en) * | 2020-12-30 | 2021-04-16 | 京东数字科技控股股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112667665A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Method and device for generating SCADA control system report and electronic equipment |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN113448980A (en) * | 2021-06-18 | 2021-09-28 | 青岛海尔科技有限公司 | Method and device for generating SQL (structured query language) statement and electronic equipment |
| CN113535791A (en) * | 2020-04-14 | 2021-10-22 | 北京一起教育信息咨询有限责任公司 | Data generation method and device and electronic equipment |
| CN115544130A (en) * | 2022-11-30 | 2022-12-30 | 广州天维信息技术股份有限公司 | Performance report generation method and device, storage medium and computer equipment |
| CN117252180A (en) * | 2023-11-16 | 2023-12-19 | 太平金融科技服务（上海）有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN117251457A (en) * | 2023-11-20 | 2023-12-19 | 昆山华东信息科技有限公司 | Grid report making method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| EP2690563A1 (en) * | 2012-07-23 | 2014-01-29 | BRANDAD Systems AG | Method and device for reporting on data of documents generated from templates |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
-
2016
- 2016-04-08 CN CN201610217609.3A patent/CN105843945A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2690563A1 (en) * | 2012-07-23 | 2014-01-29 | BRANDAD Systems AG | Method and device for reporting on data of documents generated from templates |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
Cited By (85)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798026A (en) * | 2016-09-05 | 2018-03-13 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN106445901B (en) * | 2016-09-28 | 2019-09-27 | 医渡云（北京）技术有限公司 | Case report form design method and device |
| CN106445901A (en) * | 2016-09-28 | 2017-02-22 | 医渡云（北京）技术有限公司 | Method and device for designing case report form |
| CN106528514A (en) * | 2016-10-31 | 2017-03-22 | 山东鲁能软件技术有限公司 | Report generation system and method |
| CN106570117A (en) * | 2016-11-02 | 2017-04-19 | 国网山东省电力公司物资公司 | Form control system and method based on electric power material distributing system |
| CN106570118A (en) * | 2016-11-02 | 2017-04-19 | 国网山东省电力公司物资公司 | Report data processing system and method based on electric power material distribution mobile platform |
| CN106570118B (en) * | 2016-11-02 | 2020-08-07 | 国网山东省电力公司物资公司 | Report data processing system and method based on electric power material allocation mobile platform |
| CN106776769A (en) * | 2016-11-23 | 2017-05-31 | 天脉聚源（北京）科技有限公司 | A kind of method and device of dynamic generation chart |
| CN108132945A (en) * | 2016-12-01 | 2018-06-08 | 百度在线网络技术（北京）有限公司 | For generating the method and apparatus of report |
| CN108334321A (en) * | 2017-01-18 | 2018-07-27 | 阿里巴巴集团控股有限公司 | The presentation device of program code, method and device |
| CN108536342A (en) * | 2017-03-02 | 2018-09-14 | 腾讯科技（深圳）有限公司 | A kind of data query method and device |
| CN108536342B (en) * | 2017-03-02 | 2022-11-08 | 腾讯科技（深圳）有限公司 | Data query method and device |
| CN108694179A (en) * | 2017-04-06 | 2018-10-23 | 北京宸瑞科技股份有限公司 | Personage's view analysis system based on attribute extraction and method |
| CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
| CN108804402A (en) * | 2017-04-28 | 2018-11-13 | 北京京东尚科信息技术有限公司 | Report generating system based on big data platform and method |
| CN107480168A (en) * | 2017-06-27 | 2017-12-15 | 石化盈科信息技术有限责任公司 | A kind of Cross Report based on LIMS realizes system |
| CN109213776A (en) * | 2017-06-30 | 2019-01-15 | 北京神州泰岳软件股份有限公司 | A kind of report form showing method and device |
| CN107391652A (en) * | 2017-07-17 | 2017-11-24 | 山东浪潮通软信息科技有限公司 | A kind of templating form interface defines system and method |
| CN107491431A (en) * | 2017-08-31 | 2017-12-19 | 精硕科技（北京）股份有限公司 | List method to set up and device |
| CN107609109A (en) * | 2017-09-13 | 2018-01-19 | 山东浪潮云服务信息科技有限公司 | A kind of report form generation method, device and system |
| CN108009213A (en) * | 2017-11-13 | 2018-05-08 | 深圳市海云天教育测评有限公司 | A kind of method and device of Mass production Word document |
| CN108170713A (en) * | 2017-11-30 | 2018-06-15 | 东软集团股份有限公司 | The method, apparatus and storage medium and electronic equipment of data displaying |
| CN110019395A (en) * | 2017-11-30 | 2019-07-16 | 北京神州泰岳软件股份有限公司 | A kind of implementation method and device for inquiring ElasticSearch |
| CN108038180A (en) * | 2017-12-07 | 2018-05-15 | 国网四川省电力公司信息通信公司 | The method that a kind of power supply region gathered data visualizes |
| WO2019109485A1 (en) * | 2017-12-08 | 2019-06-13 | 平安科技（深圳）有限公司 | Echarts tool-based chart making method, apparatus and device, and medium |
| CN108170655A (en) * | 2017-12-26 | 2018-06-15 | 平安科技（深圳）有限公司 | Production method, device, terminal device and the storage medium of Visual Report Forms |
| CN109460542A (en) * | 2018-01-15 | 2019-03-12 | 安徽七禾软件有限公司 | A kind of grain and oil report form generation method and system |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN108829653A (en) * | 2018-05-04 | 2018-11-16 | 山东中创软件工程股份有限公司 | A kind of generation method of report, device, equipment and medium |
| CN110472207A (en) * | 2018-05-10 | 2019-11-19 | 北京京东尚科信息技术有限公司 | List generation method and device |
| CN108647316A (en) * | 2018-05-10 | 2018-10-12 | 北京中电普华信息技术有限公司 | Data processing method and device |
| CN109165238A (en) * | 2018-06-21 | 2019-01-08 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of cyclical indicator data |
| CN109033173A (en) * | 2018-06-21 | 2018-12-18 | 深圳市彬讯科技有限公司 | It is a kind of for generating the data processing method and device of multidimensional index data |
| CN109165238B (en) * | 2018-06-21 | 2022-09-09 | 土巴兔集团股份有限公司 | Data processing method and device for generating period index data |
| CN108984506A (en) * | 2018-08-01 | 2018-12-11 | 北京中电普华信息技术有限公司 | A kind of generation method and device of configurable intelligent report forms |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN109271411B (en) * | 2018-09-28 | 2023-08-29 | 中国平安财产保险股份有限公司 | Report generation method, report generation device, computer equipment and storage medium |
| CN109271411A (en) * | 2018-09-28 | 2019-01-25 | 中国平安财产保险股份有限公司 | Report form generation method, device, computer equipment and storage medium |
| CN109492056A (en) * | 2018-10-24 | 2019-03-19 | 江苏满运软件科技有限公司 | A kind of method and system of business intelligence data inquiry |
| WO2020083358A1 (en) * | 2018-10-25 | 2020-04-30 | 北京数安鑫云信息技术有限公司 | Visualized service data operating system, method, device and medium |
| CN109388400A (en) * | 2018-10-29 | 2019-02-26 | 深圳同耕科技股份有限公司 | A kind of automatic production of HTML page method and device |
| CN109388400B (en) * | 2018-10-29 | 2021-10-19 | 深圳同耕科技股份有限公司 | Automatic page generation method and device |
| CN111291543A (en) * | 2018-11-21 | 2020-06-16 | 北京国双科技有限公司 | Data display method and device, storage medium and processor |
| CN109739906A (en) * | 2018-11-21 | 2019-05-10 | 深圳市佰仟金融服务有限公司 | A kind of report form generation method and system |
| CN111291543B (en) * | 2018-11-21 | 2023-08-25 | 北京国双科技有限公司 | Data display method and device, storage medium and processor |
| CN109783426A (en) * | 2018-12-14 | 2019-05-21 | 深圳壹账通智能科技有限公司 | Acquire method, apparatus, computer equipment and the storage medium of data |
| CN109800255A (en) * | 2018-12-29 | 2019-05-24 | 北京奇安信科技有限公司 | A kind of generation method of Visual Report Forms, system, equipment and medium |
| CN109992589A (en) * | 2019-04-11 | 2019-07-09 | 北京启迪区块链科技发展有限公司 | Method, apparatus, server and the medium of SQL statement are generated based on visual page |
| CN109992589B (en) * | 2019-04-11 | 2020-04-10 | 北京启迪区块链科技发展有限公司 | Method, device, server and medium for generating SQL (structured query language) statements based on visual page |
| CN110222321A (en) * | 2019-04-16 | 2019-09-10 | 中国平安人寿保险股份有限公司 | Report form generation method, device, computer installation and computer readable storage medium |
| CN110232178A (en) * | 2019-05-29 | 2019-09-13 | 北京中亦安图科技股份有限公司 | Report generation method and device |
| CN110298023B (en) * | 2019-07-04 | 2023-08-25 | 中原银行股份有限公司 | Report splicing method and system |
| CN110298023A (en) * | 2019-07-04 | 2019-10-01 | 中原银行股份有限公司 | A kind of joining method and system of report |
| CN110413974A (en) * | 2019-07-26 | 2019-11-05 | 北京恒华伟业科技股份有限公司 | Form template configuration and device, table deriving method and device |
| CN110442595B (en) * | 2019-07-26 | 2022-07-22 | 南京南瑞继保电气有限公司 | Method and device for constructing universal SQL report data set |
| CN110442595A (en) * | 2019-07-26 | 2019-11-12 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of general SQL report data collection building |
| CN110717319B (en) * | 2019-09-24 | 2023-10-20 | 车智互联（北京）科技有限公司 | Self-service report generation method, device, computing equipment and system |
| CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联（北京）科技有限公司 | Self-service report generation method and device, computing equipment and system |
| CN110851173B (en) * | 2019-11-18 | 2023-11-14 | 中国银行股份有限公司 | Report generation method and device |
| CN110851173A (en) * | 2019-11-18 | 2020-02-28 | 中国银行股份有限公司 | Report generation method and device |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN111126019B (en) * | 2019-11-28 | 2024-01-05 | 泰康保险集团股份有限公司 | Report generation method and device based on mode customization and electronic equipment |
| CN111126019A (en) * | 2019-11-28 | 2020-05-08 | 泰康保险集团股份有限公司 | Report generation method and device based on mode customization and electronic equipment |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
| CN111143433A (en) * | 2019-12-10 | 2020-05-12 | 中国平安财产保险股份有限公司 | Method and device for counting data of data bins |
| CN111259643B (en) * | 2019-12-10 | 2023-11-28 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphic report |
| CN111126026B (en) * | 2019-12-17 | 2021-10-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111126026A (en) * | 2019-12-17 | 2020-05-08 | 叮当快药科技集团有限公司 | Method and tool for generating visual report form by analyzing SQL statement |
| CN111177231B (en) * | 2019-12-20 | 2023-09-22 | 中国建设银行股份有限公司 | Report generation method and report generation device |
| CN111177231A (en) * | 2019-12-20 | 2020-05-19 | 中国建设银行股份有限公司 | Report generation method and report generation device |
| CN111176634A (en) * | 2020-01-17 | 2020-05-19 | 天阳宏业科技股份有限公司 | Method and device for configurable embeddable high-tube view |
| CN113535791A (en) * | 2020-04-14 | 2021-10-22 | 北京一起教育信息咨询有限责任公司 | Data generation method and device and electronic equipment |
| CN111552712A (en) * | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method and device and computer equipment |
| CN111625219A (en) * | 2020-05-22 | 2020-09-04 | 杭州指令集智能科技有限公司 | BO component processing method, device and equipment |
| CN111967234A (en) * | 2020-07-29 | 2020-11-20 | 深圳市麦谷科技有限公司 | Visual report generation method and device, terminal equipment and storage medium |
| CN112434100A (en) * | 2020-11-20 | 2021-03-02 | 航天信息股份有限公司企业服务分公司 | Method and system for realizing dynamic display of columns and multiple conditions and dynamic multi-latitude query |
| CN112667716A (en) * | 2020-12-30 | 2021-04-16 | 京东数字科技控股股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112667665A (en) * | 2020-12-31 | 2021-04-16 | 新奥数能科技有限公司 | Method and device for generating SCADA control system report and electronic equipment |
| CN113448980A (en) * | 2021-06-18 | 2021-09-28 | 青岛海尔科技有限公司 | Method and device for generating SQL (structured query language) statement and electronic equipment |
| CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
| CN115544130A (en) * | 2022-11-30 | 2022-12-30 | 广州天维信息技术股份有限公司 | Performance report generation method and device, storage medium and computer equipment |
| CN117252180A (en) * | 2023-11-16 | 2023-12-19 | 太平金融科技服务（上海）有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN117252180B (en) * | 2023-11-16 | 2024-02-23 | 太平金融科技服务（上海）有限公司 | Report generation method and device, electronic equipment and storage medium |
| CN117251457A (en) * | 2023-11-20 | 2023-12-19 | 昆山华东信息科技有限公司 | Grid report making method and device |
| CN117251457B (en) * | 2023-11-20 | 2024-03-12 | 昆山华东信息科技有限公司 | Grid report making method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105843945A (en) | Report generation method and system | |
| US10152560B2 (en) | Graph database querying and visualization | |
| CN111542813B (en) | Object model using heterogeneous data to facilitate building data visualizations | |
| US11093553B2 (en) | Graph database visualization by node and edge type | |
| WO2019109485A1 (en) | Echarts tool-based chart making method, apparatus and device, and medium | |
| US20220300572A1 (en) | Interactive geographical map | |
| CN109033260B (en) | Knowledge graph interactive visual query method based on RDF | |
| CN107111639B (en) | Building reports | |
| CN108780518A (en) | Web interface generation and test are carried out using artificial neural network | |
| Han et al. | Situational data integration with data services and nested table | |
| KR101773574B1 (en) | Method for chart visualizing of data table | |
| CN103268327B (en) | Mixing method for visualizing towards high-dimensional service data | |
| CN104090769B (en) | The figure methods of exhibiting and device of a kind of business datum | |
| CN110532280A (en) | SQL statement method for visualizing and device | |
| Cava et al. | Clustervis: visualizing nodes attributes in multivariate graphs | |
| US20230134235A1 (en) | Applying a Visual Analytics Intent Language to Generate Data Visualizations | |
| US20210152648A1 (en) | Techniques for analyzing the proficiency of users of software applications in real-time | |
| Widjaja et al. | Modeling coordinated multiple views of heterogeneous data cubes for urban visual analytics | |
| CN112527250A (en) | Software development platform based on visualization | |
| CN104199882B (en) | A kind of acquisition methods of structural knowledge and its body based on the customization of intelligent masterplate | |
| CN116305895A (en) | Product model generation method, device, computer equipment and storage medium | |
| US20130262417A1 (en) | Graphical Representation and Automatic Generation of Iteration Rule | |
| KR101910179B1 (en) | Web-based chart library system for data visualization | |
| Yuan et al. | Towards the next-generation GIS: A geometric algebra approach | |
| US11567967B2 (en) | Applying a visual analytics intent language to infer ambiguous or underspecified intent |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160810 |