CN109739906A - A kind of report form generation method and system - Google Patents
A kind of report form generation method and system Download PDFInfo
- Publication number
- CN109739906A CN109739906A CN201811391552.4A CN201811391552A CN109739906A CN 109739906 A CN109739906 A CN 109739906A CN 201811391552 A CN201811391552 A CN 201811391552A CN 109739906 A CN109739906 A CN 109739906A
- Authority
- CN
- China
- Prior art keywords
- report
- target
- allocation list
- newly
- 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.)
- Withdrawn
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application provides a kind of report form generation method and systems, which comprises obtains query structure query language SQL according to the target report coding in report query request；The query SQL is executed, obtains the target column configuration data comprising target report coding in target allocation list data and the column allocation list comprising target report coding in allocation list, wherein the target allocation list data include the customized SQL of target；It executes the customized SQL of the target and obtains target report data, target report is generated according to the target report data and target column configuration data, wherein the target column configuration data is used for post-processing object report page.
Description
Technical field
This application involves computer field more particularly to a kind of report form generation method and systems.
Background technique
In recent years, with E-Government, e-commerce and enterprise ERP (Enterprise Resource Planning,
Enterprise Resources Plan) fast development, the problems such as acquisitions of data, transmission, displaying, interaction becomes more and more important.Report is made
It is the important component of enterprise information system for the mode of a kind of information tissue and displaying, report has in all trades and professions
Very extensive purposes is the powerful for carrying out information browse, analysis, printing.
The conventional method of report generation is to pass through hand-coding SQL code and run code to inquire the number in database
According to realizing the display of statistical result.When proposing to count new field or new call format such as client, then need to write new generation
Code not only increases human cost in this way and also increases the time of report upgrading exploitation.
Summary of the invention
This application provides a kind of report form generation method and systems, can create online, modify report, to simplify report
Escalation process.
In a first aspect, the described method comprises the following steps this application provides a kind of report form generation method:
Query structure query language SQL is obtained according to the target report coding in report query request；
The query SQL is executed, target allocation list data and column comprising target report coding in allocation list is obtained and matches
Set the target column configuration data comprising target report coding in table, wherein the target allocation list data include that target is customized
SQL；
It executes the customized SQL of the target and obtains target report data, according to the target report data and target column
Configuration data generates target report, wherein the target column configuration data is used for post-processing object report page.
Optionally, before obtaining query SQL according to the report coding in report query request, the method is also wrapped
It includes: obtaining the trigger request of triggering target report hyperlink, wherein the target report hyperlink is with the shape of target report name
Formula is shown to be shown in page in Report List；Report query request is obtained according to the trigger request, wherein the report query is asked
It asks comprising the corresponding report coding of the target report hyperlink.
Optionally, before the trigger request for obtaining triggering target report hyperlink, the method also includes: it obtains newly-built
The newly-built report request that report page is submitted；It is inserted into a line in allocation list according to the newly-built report request and creates allocation list number
According to insertion a line creates column configuration data in column allocation list, wherein the newly-built allocation list data include newly-built report name
Claim, create report coding and create customized SQL, the newly-built column configuration data includes newly-built report coding and creates report
The page formatting of table, the newly-built report coding in the newly-built allocation list data and the newly-built report coding phase in column allocation list
Together；Newly-built report hyperlink is generated according to the newly-built report coding, wherein the newly-built report hyperlink is for obtaining triggering
The trigger request of target report hyperlink.
Optionally, which is characterized in that after generating the target report, the method also includes: by the target report
It is sent to report display platform, the report display platform is used to the target report display showing page in report, wherein institute
It states and shows that page includes browser WEB page or the application program page；It is put down alternatively, the target report is sent to report and is shown
Platform, the report display platform are used to receive the table downloading request of user and table are sent to user, the table downloading
Request includes form document format identification (FID)；Alternatively, periodically sending target report to subscriber mailbox.
Optionally, the allocation list is shown in allocation list maintenance page, and the allocation list maintenance page is used in the configuration
In the case that allocation list data in table need to modify, by safeguarding that progress page editing obtains modified on page in allocation list
Allocation list data；The column allocation list is shown in column allocation list maintenance page, and the column allocation list maintenance page is used in the column
In the case that column configuration data in allocation list needs to modify, by safeguarding that carrying out page editing on page is repaired in column allocation list
Column configuration data after changing.
Second aspect provides a kind of report generating system, the system comprises acquiring unit, the first execution unit and
Second execution unit,
The acquiring unit is used to obtain query structure according to the target report coding in report query request and look into
Ask language SQL；
First execution unit obtains the mesh comprising target report coding in allocation list for executing the query SQL
Mark the target column configuration data comprising target report coding in allocation list data and column allocation list, wherein the target configuration
Table data include the customized SQL of target；
Second execution unit obtains target report data for executing the customized SQL of the target, according to the mesh
It marks report data and target column configuration data generates target report, wherein the target column configuration data is used for post-processing object
Report page.
Optionally, the system also includes trigger unit, the trigger unit is used to request according to the report query
In report coding obtain query SQL before, obtain triggering target report hyperlink trigger request, wherein the target report
Table hyperlink is shown in the form of target report name to be shown in page in Report List；The trigger unit is also used to according to
Trigger request obtains report query request, wherein the report query request includes the corresponding report of the target report hyperlink
Table coding.
Optionally, the system also includes newly-built unit, the newly-built unit is used to obtain triggering target report hyperlink
Before the trigger request connect, the newly-built report request that newly-built report page is submitted is obtained；The newly-built unit is also used to according to institute
It states newly-built report request and is inserted into the newly-built allocation list data of a line in allocation list, the newly-built column configuration of a line is inserted into column allocation list
Data, wherein the newly-built allocation list data include newly-built report name, newly-built report coding and create customized SQL, institute
Stating newly-built column configuration data includes creating the page formatting of report coding and newly-built report, in the newly-built allocation list data
Newly-built report coding is identical as the newly-built report coding in column allocation list；The newly-built unit is also used to according to the newly-built report
Coding generates newly-built report hyperlink, wherein the newly-built report hyperlink is used to obtain the touching of triggering target report hyperlink
Hair request.
Optionally, the system also includes transmission unit, the transmission unit is used for after generating the target report,
The target report is sent to report display platform, the report display platform is used for the target report display in report
Show page, wherein the displaying page includes browser WEB page or the application program page；Alternatively, the transmission unit is used for
The target report is sent to report display platform, the report display platform is used to receive the table downloading request of user simultaneously
Table is sent to user, the table downloading request includes form document format identification (FID)；Alternatively, the transmission unit is for fixed
Phase sends target report to subscriber mailbox.
Optionally, the allocation list is shown in allocation list maintenance page, and the allocation list maintenance page is used in the configuration
In the case that allocation list data in table need to modify, by safeguarding that progress page editing obtains modified on page in allocation list
Allocation list data；The column allocation list is shown in column allocation list maintenance page, and the column allocation list maintenance page is used in the column
In the case that column configuration data in allocation list needs to modify, by safeguarding that carrying out page editing on page is repaired in column allocation list
Column configuration data after changing.
In the above method, by obtaining query structureization inquiry according to the target report coding in report query request
Language SQL then executes the query SQL and obtains the target allocation list data encoded in allocation list comprising target report and column
Target column configuration data comprising target report coding in allocation list finally executes the customized SQL of the target and obtains target report
Table data, to generate target report according to the target report data and target column configuration data.It can by the above method
It is stored in the database in the form of configuration information by by report data content information and page formatting information, to realize online
Newly-built, modification report, greatly simplifies report escalation process, when reducing the human cost and exploitation needed for reporting system upgrades
Between, meet the customer demand of report content flexibility and format mobilism.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of application for those of ordinary skill in the art without creative efforts, can be with
It obtains other drawings based on these drawings.
Fig. 1 is a kind of flow diagram of report form generation method provided by the present application；
Fig. 2 a is the schematic diagram of Report List page in a kind of report form generation method provided by the present application；
Fig. 2 b is the schematic diagram that report configuration page is created in a kind of report form generation method provided by the present application；
Fig. 2 c is the schematic diagram that report WEB shows page in a kind of report form generation method provided by the present application；
Fig. 2 d is the schematic diagram of column configuring maintenance page in a kind of report form generation method provided by the present application；
Fig. 3 is a kind of flow diagram of report form generation method provided by the present application；
Fig. 4 is a kind of structural schematic diagram of report generating system provided by the present application；
Fig. 5 is a kind of structural schematic diagram of processor provided by the present application.
Specific embodiment
The application is described in further detail below by specific embodiment combination attached drawing.In the following embodiments and the accompanying drawings
In, many datail descriptions are in order to enable the application can be better understood.However, those skilled in the art can be without lifting an eyebrow
Recognize, part of feature is dispensed in varied situations, or can be substituted by other methods.Certain
In the case of, the relevant some operations of the application are there is no display in the description or describe, this is the core in order to avoid the application
Center portion point is flooded by excessive description.To those skilled in the art, be described in detail these relevant operations be not must
It wants, they can completely understand relevant operation according to the general technology knowledge of description and this field in specification.
It should be appreciated that ought use in this specification and in the appended claims, term " includes " and "comprising" instruction
Described feature, entirety, step, operation, the presence of element and component, but be not precluded one or more of the other feature, entirety,
Step, operation, the presence or addition of element, component and/or its set.
It should be noted that the term used in the embodiment of the present application is only merely for the mesh of description specific embodiment
, it is not intended to be limiting the application." the one of the embodiment of the present application and singular used in the attached claims
Kind ", " described " and "the" are also intended to including most forms, unless the context clearly indicates other meaning.
The method and system of making loans of the embodiment of the present application can be applied in multiple fields, for example, bank, financing corporation, mutually
The point-to-point loan platform (Person-to-Person, P2P) of networking finance, auto financing company or guarantee corporation etc. may be implemented
The company etc. for borrowing or lending money operation, is not especially limited herein.
S101: query structure query language SQL is obtained according to the target report coding in report query request.
In the embodiment of the present application, it before obtaining query SQL according to the report coding in report query request, obtains
Take the trigger request of triggering target report hyperlink, wherein target report hyperlink exhibition in the form of target report name
Show and is shown in page in Report List；Report query request is obtained according to the trigger request, wherein the report query request packet
Containing the corresponding report coding of the target report hyperlink.For example: Fig. 2 a is Report List in a kind of report form generation method
The schematic diagram of page, by Fig. 2 a it is found that every a line has recorded the correlation for the report that one pre-sets in Report List displaying page
Information, when user needs to check target report, click function title one column in target statement heading, that is, obtain triggering target
The trigger request of report hyperlink, or target report hyperlink acquisition trigger request is triggered by clicking preview key, according to
Trigger request obtains the report query request comprising target report coding, can according to the target report coding in the inquiry request
To obtain query SQL, wherein report coding is the conditional parameter in query SQL, such as: it is requested to obtain mesh according to report query
Mark report is encoded to 001, then query SQL can be select*from allocation list where ' 001 ', that is to say, that configuring
The allocation list data that report is encoded to 001 are inquired in table, query SQL can also be select*from column allocation list where
' 001 ', that is to say, that the column configuration data that report is encoded to 001 is inquired in column allocation list, it should be appreciated that report shown in Fig. 2 a
Table list page is used only for for example, specific restriction can not be constituted.
In the embodiment of the present application, before the trigger request for obtaining triggering target report hyperlink, newly-built report is obtained
The newly-built report request that the page is submitted；It is inserted into a line in allocation list according to the newly-built report request and creates allocation list data,
It is inserted into a line in column allocation list and creates column configuration data, wherein the newly-built allocation list data include newly-built report name, new
It builds report coding and creates customized SQL, the newly-built column configuration data includes newly-built report coding and newly-built report
Page formatting, the newly-built report coding in the newly-built allocation list data are identical as the newly-built report coding in column allocation list；Root
Newly-built report hyperlink is generated according to the newly-built report coding, wherein the newly-built report hyperlink is for obtaining triggering target
The trigger request of report hyperlink.Such as: Fig. 2 b is that report configuration page is created in a kind of report form generation method provided by the present application
Schematic diagram, as shown in Figure 2 b, create report configuration page in configuration information mainly include two kinds, one is about report data
Information, such as data production method, data source etc., another kind is the information about report page, such as interface layout wind
Therefore lattice, displaying type, alignment thereof etc. obtain newly-built report request according to the configuration information in newly-built report configuration page,
Two class data of the newly-built report request are separately recorded in allocation list and column allocation list.The following table 1 is shown according to newly-built
Allocation list data are recorded in allocation list to report request and column configuration data is recorded in the field requirement of column allocation list, Ying Li
Solution, Fig. 2 b, table 1 and table 2 are used only for for example, specific restriction can not be constituted.
1 report of table configures literary name section requirement
The column configuration literary name section requirement of table 2
S102: executing the query SQL, obtain target allocation list data comprising target report coding in allocation list and
Target column configuration data comprising target report coding in column allocation list.
In the embodiment of the present application, the query SQL can also be inquired column and be matched with the configuration data in query configuration table
Set the column configuration data in table, wherein the allocation list data in allocation list correspond to target report coding, and the column in column allocation list are matched
It sets data and also corresponds to identical target report coding, it is to be understood that wanted since report page format can be multiple format
The format of combination is sought, so an allocation list data can be obtained in allocation list according to same target report coding, is being arranged
A plurality of column configuration data can be obtained in allocation list.
In the embodiment of the present application, the target allocation list data include the customized SQL of target, and the customized SQL is
The SQL set in newly-built report according to report demand, such as created in report page shown in Fig. 2 a, one column of data production method
The as described customized SQL, that is to say, that data needed for executing customized SQL and can obtaining the report, it should be appreciated that more than
Citing can not constitute specific restriction for illustrating.
S103: it executes the customized SQL of the target and obtains target report data, according to the target report data and mesh
It marks column configuration data and generates target report.
In the embodiment of the present application, the target column configuration data is used for post-processing object report page.That is, according to
After the customized SQL of target obtains target report data, the data are carried out to the wash with watercolours of report page using target column configuration data
Dye, to obtain target report.That is, target report can be and be determined by two parts data, a part can be report
Table data, a part can be statement form data, it is to be understood that if establishing entire target report in database
In, each user transfers report from database and needs to rewrite customized SQL acquisition report data, when statement form needs
When modification, it is necessary to rewrite customized SQL, therefore report generation method provided by the present application can be flexible according to user demand
Newly-built and modification report content, when user needs to transfer report, it is only necessary to which user shows that page click is built in advance in report
Vertical report name, when statement form needs to modify, it is only necessary to change the column configuration data in column allocation list.It is understood that
It is that the report in the application can be table, is also possible to chart, when user needs graphically output formats, only
Needing to change the displaying type in column allocation list can be obtained the diagrammatic form file of target report.
In the embodiment of the present application, after generating the target report, the method also includes: the target report is sent out
It send to report display platform, the report display platform is used to the target report display showing page in report, wherein described
Show that page includes browser WEB page or the application program page；It is put down alternatively, the target report is sent to report and is shown
Platform, the report display platform are used to receive the table downloading request of user and table are sent to user, the table downloading
Request includes form document format identification (FID)；Alternatively, periodically sending target report to subscriber mailbox.Such as Fig. 2 c is the application offer
A kind of report form generation method report WEB show page schematic diagram, as shown in Figure 2 c, according to the target report data and mesh
After marking column configuration data generation target report, the report is shown and is shown in page in report by report display platform, wherein report
It shows that page can also provide data screening function, such as raises the range screening of the Start Date of plan shown in Fig. 2 c, it can be with
Understand, report shown in Fig. 2 c shows that page is only used for for example, specific restriction can not be constituted, and the report shows flat
Report in platform shows that page can also provide the function that other do not show in Fig. 2 c such as table downloading.
In the embodiment of the present application, the allocation list is shown in allocation list maintenance page, and the allocation list maintenance page is used for
In the case that allocation list data in the allocation list need to modify, by safeguarding that carrying out page editing on page obtains in allocation list
Obtain modified allocation list data；The column allocation list is shown in column allocation list maintenance page, and the column allocation list maintenance page is used
In the case that the column configuration data in the column allocation list needs to modify, the page is carried out on page by safeguarding in column allocation list
Editor obtains modified column configuration data.Fig. 2 d is column configuring maintenance page in a kind of report form generation method provided by the present application
Schematic diagram, as shown in Figure 2 d, user is in the column configuration information for needing to modify report, such as needs for target report page to be aligned
When form modifying is Right Aligns, it is only necessary to page editing is carried out in column allocation list maintenance page, by the target report in column allocation list
Table encodes corresponding alignment thereof and is revised as Right Aligns, saves modified data i.e. and can reach modification target report page alignment
The purpose of format.It should be understood that column configuring maintenance page shown in Fig. 2 d is only used for for example, specific restriction can not be constituted.
Report form generation method provided by the present application is made by taking Fig. 3 as an example below and being illustrated, is used as shown in figure 3, obtaining
After the triggering information of target report link is triggered at family, encoded according to the triggering information acquisition target report, according to the target
After report coding obtains query SQL, execute in allocation list data and the column allocation list that the query SQL obtains in allocation list
Column configuration data after executing the customized SQL in allocation list data, is obtained target report data, is rendered using column configuration data
After target report data, target report is obtained.
In the above method, by obtaining query structureization inquiry according to the target report coding in report query request
Language SQL then executes the query SQL and obtains the target allocation list data encoded in allocation list comprising target report and column
Target column configuration data comprising target report coding in allocation list finally executes the customized SQL of the target and obtains target report
Table data, to generate target report according to the target report data and target column configuration data.It can by the above method
It is stored in the database in the form of configuration information by by report data content information and page formatting information, to realize online
Newly-built, modification report, greatly simplifies report escalation process, when reducing the human cost and exploitation needed for reporting system upgrades
Between, meet the customer demand of report content flexibility and format mobilism.
Fig. 4 is a kind of structural schematic diagram of report generating system provided by the present application, as shown in figure 4, provided by the present application
Report generating system includes acquiring unit 410, the first execution unit 420, the second execution unit 430, trigger unit 440, creates
Unit 450 and transmission unit 460
The acquiring unit 410 is used to obtain query structure according to the target report coding in report query request
Query language SQL.
In the embodiment of the present application, it is obtained and is looked into according to the report coding in report query request in acquiring unit 410
Ask SQL before, the trigger unit 440 be used for according to the report query request in report coding obtain query SQL it
Before, obtain the trigger request of triggering target report hyperlink, wherein the target report hyperlink is with the shape of target report name
Formula is shown to be shown in page in Report List；The trigger unit 440 is also used to obtain report query according to the trigger request and ask
It asks, wherein the report query request includes the corresponding report coding of the target report hyperlink.For example: Fig. 2 a is
The schematic diagram of Report List page in a kind of report form generation method, by Fig. 2 a it is found that Report List shows that every a line has recorded in page
The relevant information of one report pre-set, when user needs to check target report, in the column of click function title one
Target statement heading obtains the trigger request of triggering target report hyperlink, or triggers target by clicking preview key
Report hyperlink obtains trigger request, obtains the report query comprising target report coding according to trigger request and requests, according to institute
The target report coding stated in inquiry request can obtain query SQL, wherein and report coding is the conditional parameter in query SQL,
Such as: request acquisition target report to be encoded to 001 according to report query, then query SQL can be " select*from configuration
Table where ' 001 ' ", that is to say, that the allocation list data that report is encoded to 001 are inquired in allocation list, query SQL can be with
It is " select*from column allocation list where ' 001 ' ", that is to say, that the column that report is encoded to 001 are inquired in column allocation list
Configuration data, it should be appreciated that Report List page shown in Fig. 2 a is used only for for example, specific restriction can not be constituted.
In the embodiment of the present application, before the trigger request for obtaining triggering target report hyperlink, the system is also wrapped
Newly-built unit 450 is included, the newly-built unit 450 is used for before the trigger request for obtaining triggering target report hyperlink, is obtained
The newly-built report request that newly-built report page is submitted；The newly-built unit is also used to according to the newly-built report request in allocation list
Middle insertion a line creates allocation list data, and a line is inserted into column allocation list and creates column configuration data, wherein the newly-built configuration
Table data include newly-built report name, newly-built report coding and create customized SQL, and the newly-built column configuration data includes new
The page formatting of report coding and newly-built report is built, newly-built report coding and column allocation list in the newly-built allocation list data
In newly-built report coding it is identical；The newly-built unit 450 is also used to generate newly-built report according to the newly-built report coding super
Link, wherein the newly-built report hyperlink is used to obtain the trigger request of triggering target report hyperlink.Such as: Fig. 2 b is
The schematic diagram of report configuration page is created in a kind of report form generation method provided by the present application, as shown in Figure 2 b, creates report configuration
Configuration information in page mainly includes two kinds, and one is information about report data, such as data production method, data source etc.
Deng, another kind is the information about report page, such as interface layout style, displaying type, alignment thereof etc., therefore, root
Newly-built report request is obtained according to the configuration information in newly-built report configuration page, two class data of the newly-built report request are distinguished
It is recorded in allocation list and column allocation list.It should be understood that Fig. 2 b is used only for for example, specific restriction can not be constituted.
First execution unit 420 obtains in allocation list for executing the query SQL comprising target report coding
Target column configuration data comprising target report coding in target allocation list data and column allocation list, wherein the target is matched
Setting table data includes the customized SQL of target.
In the embodiment of the present application, query SQL can also inquire column allocation list with the configuration data in query configuration table
In column configuration data, wherein the allocation list data in allocation list correspond to target report coding, and the column in column allocation list configure number
It is encoded according to identical target report is also corresponded to, it is to be understood that since report page format can be multiple format requirement group
The format of conjunction configures so can obtain an allocation list data in allocation list according to same target report coding in column
A plurality of column configuration data can be obtained in table.
In the embodiment of the present application, the target allocation list data include the customized SQL of target, and the customized SQL is
The SQL set in newly-built report according to report demand, such as created in report page shown in Fig. 2 a, one column of data production method
The as described customized SQL, that is to say, that data needed for executing customized SQL and can obtaining the report, it should be appreciated that more than
Citing can not constitute specific restriction for illustrating.
Second execution unit 430 obtains target report data for executing the customized SQL of the target, according to described
Target report data and target column configuration data generate target report, wherein the target column configuration data is for rendering mesh
Mark report page.
In the embodiment of the present application, the target column configuration data is used for post-processing object report page.That is, according to
After the customized SQL of target obtains target report data, the data are carried out to the wash with watercolours of report page using target column configuration data
Dye, to obtain target report.That is, target report can be and be determined by two parts data, a part can be report
Table data, a part can be statement form data, it is to be understood that if establishing entire target report in database
In, each user, which transfers report from database and needs to rewrite customized SQL, obtains report data, when statement form or
When data source needs to modify, it is necessary to rewrite customized SQL, therefore report generation method provided by the present application can according to
Family demand and flexibly create and modify report content, when user needs to transfer report, it is only necessary to user report show
Page clicks the report name pre-established, when statement form needs to modify, it is only necessary to change the column configuration number in column allocation list
According to when report data source needs to modify, it is only necessary to change the configuration data in allocation list.It is understood that the application
In report can be table, be also possible to chart, when user need graphically output formats when, it is only necessary to change column
The diagrammatic form file of target report can be obtained in displaying type in allocation list.
In the embodiment of the present application, described the system also includes transmission unit 460 after generating the target report
Transmission unit 460 is used to for the target report being sent to report display platform, and the report display platform is used for the mesh
It marks report display and shows page in report, wherein the displaying page includes browser WEB page or the application program page；Alternatively,
The target report is sent to report display platform by transmission unit 460, and the report display platform is used to receive the table of user
Table is simultaneously sent to user by lattice downloading request, and the table downloading request includes form document format identification (FID)；Alternatively, sending single
Member 460 periodically sends target report to subscriber mailbox.Such as Fig. 2 c is a kind of report of report form generation method provided by the present application
WEB shows page schematic diagram, as shown in Figure 2 c, generates target report according to the target report data and target column configuration data
Afterwards, the report is shown and is shown in page in report by report display platform, wherein report shows that page can also provide data screening
Function, such as the range screening of the Start Date of plan is raised shown in Fig. 2 c, it is to be understood that report exhibition shown in Fig. 2 c
Show that page is only used for for example, specific restriction can not be constituted, the report in the report display platform shows that page can also mention
The function that other do not show in Fig. 2 c for table downloading etc..
In the embodiment of the present application, the allocation list is shown in allocation list maintenance page, and the allocation list maintenance page is used for
In the case that allocation list data in the allocation list need to modify, by safeguarding that carrying out page editing on page obtains in allocation list
Obtain modified allocation list data；The column allocation list is shown in column allocation list maintenance page, and the column allocation list maintenance page is used
In the case that the column configuration data in the column allocation list needs to modify, the page is carried out on page by safeguarding in column allocation list
Editor obtains modified column configuration data.Fig. 2 d is column configuring maintenance page in a kind of report form generation method provided by the present application
Schematic diagram, as shown in Figure 2 d, user is in the column configuration information for needing to modify report, such as needs for target report page to be aligned
When form modifying is Right Aligns, it is only necessary to page editing is carried out in column allocation list maintenance page, by the target report in column allocation list
Table encodes corresponding alignment thereof and is revised as Right Aligns, saves modified data i.e. and can reach modification target report page alignment
The purpose of format.It should be understood that column configuring maintenance page shown in Fig. 2 d is only used for for example, specific restriction can not be constituted.
In the above method, by obtaining query structureization inquiry according to the target report coding in report query request
Language SQL then executes the query SQL and obtains the target allocation list data encoded in allocation list comprising target report and column
Target column configuration data comprising target report coding in allocation list finally executes the customized SQL of the target and obtains target report
Table data, to generate target report according to the target report data and target column configuration data.It can by the above method
It is stored in the database in the form of configuration information by by report data content information and page formatting information, to realize online
Newly-built, modification report, greatly simplifies report escalation process, when reducing the human cost and exploitation needed for reporting system upgrades
Between, meet the customer demand of report content flexibility and format mobilism.
Fig. 5 is a kind of structure chart of server provided by the embodiments of the present application.As shown in figure 5, the service in the present embodiment
Device may include: one or more processors 501；One or more input equipments 502, one or more 503 Hes of output equipment
Memory 504.Above-mentioned processor 501, input equipment 502, output equipment 503 and memory 504 are connected by bus 505.It deposits
Reservoir 502 includes program instruction for storing computer program, the computer program, and processor 501 is for executing memory
The program instruction of 502 storages.
In the embodiment of the present application, alleged processor 501 can be central processing unit (Central Processing
Unit, CPU), which can also be other general processors, digital signal processor (Digital Signal
Processor, DSP), it is specific integrated circuit (Application Specific Integrated Circuit, ASIC), existing
At programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic device, discrete
Door or transistor logic, discrete hardware components etc..General processor can be microprocessor or the processor can also
To be any conventional processor etc..
Input equipment 502 may include that Trackpad, fingerprint adopt sensor (for acquiring the finger print information and fingerprint of user
Directional information), microphone etc., output equipment 503 may include display (LCD etc.), loudspeaker etc..
Memory 504 may include volatile memory, such as random access memory (Random Access
Memory,RAM)；Memory also may include nonvolatile memory, such as read-only memory (Read-Only Memory,
ROM), flash memory (Flash Memory), hard disk (Hard Disk Drive, HDD) or solid state hard disk (Solid-State
Drive, SSD), memory can also include the combination of the memory of mentioned kind.Memory 504 can be deposited using centralization
Storage can also use distributed storage, be not especially limited herein.It is understood that memory 504 is for storing computer
Program, such as: computer program instructions etc..In the embodiment of the present application, memory 504 can provide instruction to processor 501
And data.
In the specific implementation, processor 501, input equipment 502 described in the embodiment of the present application, output equipment 503, depositing
Reservoir 504, bus 505 can be performed in the first embodiment and second embodiment of report form generation method provided by the embodiments of the present application
Described implementation, details are not described herein.
In several embodiments provided herein, it should be understood that disclosed method and system can pass through it
Its mode is realized.For example, system embodiment described above is only schematical, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.In addition, shown or discussed phase
Coupling, direct-coupling or communication connection between mutually can be through some interfaces, the INDIRECT COUPLING or communication of system or unit
Connection is also possible to electricity, mechanical or other form connections.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit, some or all of unit therein can be selected to realize the embodiment of the present application side according to the actual needs
Case.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, is also possible to two or more units and is integrated in one unit.It is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, the technical solution of the application is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes the complete of each embodiment the method for the application
Portion or part steps.And storage medium above-mentioned includes: that USB flash disk, mobile hard disk, ROM, RAM, magnetic or disk etc. are various can be with
Store the medium of program code.
The above, the only specific embodiment of the application, but the protection scope of the application is not limited thereto, it is any
Those familiar with the art within the technical scope of the present application, can readily occur in various equivalent modifications or replace
It changes, these modifications or substitutions should all cover within the scope of protection of this application.Therefore, the protection scope of the application should be with right
It is required that protection scope subject to.
Claims (10)
1. a kind of report form generation method characterized by comprising
Query structure query language SQL is obtained according to the target report coding in report query request；
The query SQL is executed, target allocation list data and column allocation list comprising target report coding in allocation list are obtained
In comprising target report coding target column configuration data, wherein the target allocation list data include the customized SQL of target；
It executes the customized SQL of the target and obtains target report data, configured according to the target report data and target column
Data generate target report, wherein the target column configuration data is used for post-processing object report page.
2. the method according to claim 1, wherein being obtained according to the report coding in report query request
Before taking query SQL, the method also includes:
Obtain the trigger request of triggering target report hyperlink, wherein the target report hyperlink is with target report name
Form is shown to be shown in page in Report List；
Report query request is obtained according to the trigger request, wherein the report query request is super comprising the target report
Link corresponding report coding.
3. according to the method described in claim 2, it is characterized in that, obtain triggering target report hyperlink trigger request it
Before, the method also includes:
Obtain the newly-built report request that newly-built report page is submitted；
It is inserted into a line in allocation list according to the newly-built report request and creates allocation list data, is inserted into a line in column allocation list
Create column configuration data, wherein the newly-built allocation list data are including newly-built report name, newly-built report coding and create certainly
SQL is defined, the newly-built column configuration data includes the page formatting of newly-built report coding and newly-built report, the newly-built configuration
Newly-built report coding in table data is identical as the newly-built report coding in column allocation list；
Newly-built report hyperlink is generated according to the newly-built report coding, wherein the newly-built report hyperlink is for obtaining touching
Send out the trigger request of target report hyperlink.
4. according to claim 1 to method described in 3 any claims, which is characterized in that after generating the target report,
The method also includes:
The target report is sent to report display platform, the report display platform is for existing the target report display
Report shows page, wherein the displaying page includes browser WEB page or the application program page；Alternatively,
The target report is sent to report display platform, the table downloading that the report display platform is used to receive user is asked
It asks and table is sent to user, the table downloading request includes form document format identification (FID)；Alternatively,
Target report is periodically sent to subscriber mailbox.
5. according to claim 1 to method described in 3 any claims, which is characterized in that
The allocation list is shown in allocation list maintenance page, and the allocation list maintenance page is for the allocation list in the allocation list
In the case that data need to modify, by safeguarding that carrying out page editing on page obtains modified allocation list data in allocation list；
The column allocation list is shown in column allocation list maintenance page, and the column allocation list maintenance page is used in the column allocation list
Column configuration data need to modify in the case where, pass through and safeguard that carrying out page editing on page obtains modified column in column allocation list
Configuration data.
6. a kind of report generating system, which is characterized in that including acquiring unit, the first execution unit and the second execution unit,
The acquiring unit, which is used to obtain query structureization according to the target report coding in report query request, inquires language
Say SQL；
First execution unit obtains the target comprising target report coding in allocation list and matches for executing the query SQL
Set the target column configuration data comprising target report coding in table data and column allocation list, wherein the target allocation list number
According to including the customized SQL of target；
Second execution unit obtains target report data for executing the customized SQL of the target, according to the target report
Table data and target column configuration data generate target report, wherein the target column configuration data is used for post-processing object report
The page.
7. system according to claim 6, which is characterized in that the system also includes trigger unit, the trigger unit
For obtaining triggering target report hyperlink before obtaining query SQL according to the report coding in report query request
Trigger request, wherein the target report hyperlink shown in the form of target report name Report List show page in；
The trigger unit is also used to obtain report query request according to the trigger request, wherein the report query request
Include the corresponding report coding of the target report hyperlink.
8. system according to claim 7, which is characterized in that the system also includes newly-built unit, the newly-built unit
It is asked for before the trigger request for obtaining triggering target report hyperlink, obtaining the newly-built report that newly-built report page is submitted
It asks；
The newly-built unit is also used to be inserted into a line in allocation list according to the newly-built report request and creates allocation list data,
It is inserted into a line in column allocation list and creates column configuration data, wherein the newly-built allocation list data include newly-built report name, create
Report encodes and creates customized SQL, and the newly-built column configuration data includes the page of newly-built report coding and newly-built report
Face format, the newly-built report coding in the newly-built allocation list data are identical as the newly-built report coding in column allocation list；
The newly-built unit is also used to generate newly-built report hyperlink according to the newly-built report coding, wherein the newly-built report
Table hyperlink is used to obtain the trigger request of triggering target report hyperlink.
9. according to system described in claim 6 to 8 any claim, which is characterized in that single the system also includes sending
Member, the transmission unit are used for after generating the target report, and the target report is sent to report display platform, institute
Report display platform is stated for the target report display to be shown page in report, wherein the displaying page includes browser WEB
The page or the application program page；Alternatively,
The transmission unit is used to for the target report being sent to report display platform, and the report display platform is for receiving
Table is simultaneously sent to user by the table downloading request of user, and the table downloading request includes form document format identification (FID)；Or
Person,
The transmission unit is for periodically sending target report to subscriber mailbox.
10. according to system described in claim 6 to 8 any claim, which is characterized in that
The allocation list is shown in allocation list maintenance page, and the allocation list maintenance page is for the allocation list in the allocation list
In the case that data need to modify, by safeguarding that carrying out page editing on page obtains modified allocation list data in allocation list；
The column allocation list is shown in column allocation list maintenance page, and the column allocation list maintenance page is used in the column allocation list
Column configuration data need to modify in the case where, pass through and safeguard that carrying out page editing on page obtains modified column in column allocation list
Configuration data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811391552.4A CN109739906A (en) | 2018-11-21 | 2018-11-21 | A kind of report form generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811391552.4A CN109739906A (en) | 2018-11-21 | 2018-11-21 | A kind of report form generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109739906A true CN109739906A (en) | 2019-05-10 |
Family
ID=66356996
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811391552.4A Withdrawn CN109739906A (en) | 2018-11-21 | 2018-11-21 | A kind of report form generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109739906A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110321335A (en) * | 2019-06-18 | 2019-10-11 | 中国平安财产保险股份有限公司 | Modeling data method for down loading, device, electronic equipment and computer storage medium |
| CN110471956A (en) * | 2019-08-13 | 2019-11-19 | 浪潮云信息技术有限公司 | A kind of statistics display systems and method suitable for government affairs application |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
| CN112905558A (en) * | 2020-12-30 | 2021-06-04 | 银盛通信有限公司 | Report system implementation method and system based on database configuration |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN105893634A (en) * | 2016-06-17 | 2016-08-24 | 中国银行股份有限公司 | Method and device for generating report |
| US20160364445A1 (en) * | 2015-06-15 | 2016-12-15 | Sap Se | Database view generation |
-
2018
- 2018-11-21 CN CN201811391552.4A patent/CN109739906A/en not_active Withdrawn
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| US20160364445A1 (en) * | 2015-06-15 | 2016-12-15 | Sap Se | Database view generation |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN105893634A (en) * | 2016-06-17 | 2016-08-24 | 中国银行股份有限公司 | Method and device for generating report |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110321335A (en) * | 2019-06-18 | 2019-10-11 | 中国平安财产保险股份有限公司 | Modeling data method for down loading, device, electronic equipment and computer storage medium |
| CN110321335B (en) * | 2019-06-18 | 2023-09-22 | 中国平安财产保险股份有限公司 | Modeling data downloading method and device, electronic equipment and computer storage medium |
| CN110471956A (en) * | 2019-08-13 | 2019-11-19 | 浪潮云信息技术有限公司 | A kind of statistics display systems and method suitable for government affairs application |
| CN111259643A (en) * | 2019-12-10 | 2020-06-09 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphical report |
| CN111259643B (en) * | 2019-12-10 | 2023-11-28 | 深圳市远行科技股份有限公司 | Method and equipment for generating graphic report |
| CN112905558A (en) * | 2020-12-30 | 2021-06-04 | 银盛通信有限公司 | Report system implementation method and system based on database configuration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11803893B2 (en) | Graph processing service component in a catalog service platform | |
| US20240171459A1 (en) | System and method for configuring an adaptive computing cluster | |
| US9800675B2 (en) | Methods for dynamically generating an application interface for a modeled entity and devices thereof | |
| CN109739906A (en) | A kind of report form generation method and system | |
| EP2238533B1 (en) | Managing component programs within a service application | |
| US10846706B2 (en) | Method and apparatus for autonomous services composition | |
| US20160132808A1 (en) | Portfolios and portfolio sharing in a catalog service platform | |
| US9104483B2 (en) | System and method for automating and scheduling remote data transfer and computation for high performance computing | |
| CN102810057A (en) | Log recording method | |
| WO2013090555A1 (en) | Pneuron distributed analytics | |
| US8930885B2 (en) | Reconfiguring a model | |
| US9361325B2 (en) | Governing information | |
| WO2014165967A1 (en) | Method and system for managing cloud portals, and billing system therefor | |
| CN113196231A (en) | Techniques for decoupling access to infrastructure models | |
| US20080163083A1 (en) | Tailored object | |
| CN115668128A (en) | Automating adoption of cloud services | |
| US8392566B1 (en) | Computer executable services | |
| Nguyen et al. | A feature-based framework for developing and provisioning customizable web services | |
| CN108304591A (en) | A kind of method for customizing of label, system and terminal device | |
| Yao et al. | Building architectures for data‐intensive science using the ADAGE framework | |
| WO2016077483A1 (en) | Catalog service platform for deploying applications and services | |
| US20130275265A1 (en) | Business to business integration services marketplace | |
| WO2016176162A1 (en) | Extensibility bundles for a cloud and devices suite | |
| Jelliti et al. | A model based framework supporting ITIL service IT management | |
| US10489404B2 (en) | Macrocosm monitor service platform |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20190510 |
|
| WW01 | Invention patent application withdrawn after publication |