CN107491427A - Data sheet processing method and processing device - Google Patents

Data sheet processing method and processing device Download PDF

Info

Publication number
CN107491427A
CN107491427A CN201710428838.4A CN201710428838A CN107491427A CN 107491427 A CN107491427 A CN 107491427A CN 201710428838 A CN201710428838 A CN 201710428838A CN 107491427 A CN107491427 A CN 107491427A
Authority
CN
China
Prior art keywords
component
report component
target report
target
layout
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
Application number
CN201710428838.4A
Other languages
Chinese (zh)
Inventor
梁福坤
刘海宇
王贺冬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Xiaodu Information Technology Co Ltd
Original Assignee
Beijing Xiaodu Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Xiaodu Information Technology Co Ltd filed Critical Beijing Xiaodu Information Technology Co Ltd
Priority to CN201710428838.4A priority Critical patent/CN107491427A/en
Publication of CN107491427A publication Critical patent/CN107491427A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/95—Retrieval from the web
    • G06F16/957—Browsing optimisation, e.g. caching or content distillation
    • G06F16/9577—Optimising the visualization of content, e.g. distillation of HTML documents
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/451—Execution arrangements for user interfaces

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Computer Interaction (AREA)
  • Data Mining & Analysis (AREA)
  • User Interface Of Digital Computer (AREA)
  • Document Processing Apparatus (AREA)

Abstract

The embodiment of the present application provides a kind of data sheet processing method and processing device.Method includes：Present graphical interface, graphic interface include the report component that can be dragged and layout panel, so that user lays target report component on layout panel；Operated in response to component Configuration of the user on graphic interface, obtain the related information of the layout information and target report component between target report component；According to the layout information between target report component and the related information of target report component, report description (RD) file is generated；Report description (RD) file is rendered, with output data form.The embodiment of the present application operation is relatively easy, more friendly, flexible in terms of report component is laid, and is advantageous to improve report generation efficiency.

Description

Data sheet processing method and processing device
Technical field
The application is related to Internet technical field, more particularly to a kind of data sheet processing method and processing device.
Background technology
Data sheet has directly perceived and understandable advantage in terms of display data, therefore is obtained extensively in all trades and professions General application.Data sheet is the transmission carrier of data, and data can be embodied in data sheet by report component, such as table Lattice, line chart, sector diagram, block diagram etc..In general, application scenarios are different, the arrangement form between these report components Can be different.Wherein, the arrangement form between report component can be described as the layout of data sheet.
In the prior art, it is necessary to which form configuration personnel utilize programming language, such as HTML (HyperText Markup Language, HTML) writes configuration file corresponding to data sheet, and the configuration file is mainly used in Layout between associating between the data content of configuration data form, data content and report component and report component.So Afterwards, by configuration file solidification in the machine, data sheet is finally generated according to configuration file by machine.
, it is necessary to which form configuration personnel grasp certain programming skill during available data report generation, go to write number According to configuration file corresponding to form, and configuration information changes and will remodify configuration file every time, generates datagram The process of table is comparatively laborious, and mode not enough close friend, underaction, the report generation for generating data sheet are less efficient.
The content of the invention
The embodiment of the present application provides a kind of data sheet processing method and processing device, to provide a user a kind of friendly, spirit Report generation mode living, simplify data sheet generating process, improve data sheet formation efficiency.
The embodiment of the present application provides a kind of data sheet processing method, including：
Present graphical interface, the graphic interface includes the report component that can be dragged and layout panel, for user Target report component is laid on the layout panel；
Operated in response to component Configuration of the user on the graphic interface, obtain the target report component it Between layout information and the target report component related information；
According to the layout information between the target report component and the related information of the target report component, generation Report description (RD) file；
The report description (RD) file is rendered, with output data form.
In an optional embodiment, it is being operated in response to component Configuration of the user on the graphic interface Before, methods described also includes：
Drag operation in response to the user to report component, it is determined that being drawn to by the user on the layout panel Report component, as the target report component.
In an optional embodiment, operate, obtain in response to component Configuration of the user on the graphic interface The related information of the layout information and the target report component between the target report component is taken, including：
Operated in response to the component edits of the user, edit the related information of the target report component；
Operated in response to the distributing adjustment of the user, adjust the layout between the target report component；
Operation is submitted in configuration in response to the user, obtains the layout information between the target report component and institute State the related information of target report component.
In an optional embodiment, editor's entrance of the target report component is included on the graphic interface；
Operated in response to the component edits of the user, edit the related information of the target report component, including：
Trigger action in response to the user to editor's entrance, the target report component is shown to the user Corresponding information editing's page；
In response to edit operation of the user on described information edit page, the target that the user is inputted The data query sentence and/or style information of report component, the related information as the target report component.
In an optional embodiment, operated in response to the distributing adjustment of the user, adjust the target report component Between layout, including：
In response to dragging of the user to the target report component and/or zoom operations, the target form is adjusted The position of component and/or size.
In an optional embodiment, according to the layout information between the target report component and the target form The related information of component, report description (RD) file is generated, including：
Request or form preview request are sent in response to the form of the user, is obtained between the target report component The related information of layout information and the target report component；
HTML is done to the related information of the layout information between the target report component and the target report component Label mapping, to generate the report description (RD) file of html format.
In an optional embodiment, layout information and the target report between the target report component is obtained Before the related information of table component, methods described also includes：
In a manner of structured storage, the layout information between the target report component and the target form group are stored The related information of part.
In an optional embodiment, in a manner of structured storage, the layout letter between the target report component is stored The related information of breath and the target report component, including：
The related information of the target report component is stored to the component table of the structuring into the relevant database；
Layout information between the target report component is stored into relevant database in the layout table of structuring.
In an optional embodiment, request or form preview request are sent in response to the form of the user, obtains institute The related information of the layout information and the target report component between target report component is stated, including：
Request or form preview request are sent in response to the form of the user, from the layout table and the component table The related information of the layout information and the target report component between the target report component is read respectively.
In an optional embodiment, the layout information between the target report component is stored to relevant database In the layout table of middle structuring, including：
Layout information between the target report component is disassembled as Report layouts ID, the target report component ID, the position of the target report component and size, it is corresponding to store into the layout table；
The related information of the target report component is stored to the component table of the structuring into the relevant database, wrapped Include：
The related information of the target report component is disassembled into the ID of the target report component, the target form group The attribute and property value of part, corresponding storage is into the component table.
In an optional embodiment, the form, which sends request or form preview request, includes the target report component Between the Report layouts ID that disassembles out of layout information；
Read respectively from the layout table and the component table layout information between the target report component and The related information of the target report component, including：
The Report layouts ID of request or the carrying of form preview request is sent according to the form, is read from the layout table The position and size of the ID of the target report component and the target report component；
According to the ID of the target report component, read from the component table target report component attribute and Property value.
In an optional embodiment, to the layout information between the target report component and the target form group The related information of part does html tag mapping, to generate the report description (RD) file of html format, including：
The report component that the ID of the target report component is identified, it is defined as the report description (RD) file of the html format In html tag；
By the attribute and property value of the target report component, the content and/or pattern of the html tag are mapped as；
By the position of the target report component and size, the attribute of the html tag, the attribute instruction are mapped as The html tag corresponds to position and the size of HTML unit lattice.
In an optional embodiment, the attribute and attribute of the target report component will be read in the component table Value, the content and/or pattern of the html tag are mapped as, including：
If the attribute of the target report component includes data attribute, the data query sentence as property value is inquired Result data fill the position of the content of the html tag defined in report description (RD) file to the html format；
If the attribute of the target report component includes Style Attributes, the style information as property value is filled to generation The position of the CSS file patterns of the label association of the html tag defined in the report description (RD) file of the html format.
In an optional embodiment, before request or form preview request is sent in response to the form of the user, Methods described also includes：
In response to the component preview operation of the user, analog storage treats layout letter corresponding to the target report component of preview Breath, to treat Report layouts ID corresponding to the target report component of preview described in acquisition；
According to Report layouts ID corresponding to the target report component for treating preview, the target form of preview is treated described in acquisition The related information of layout information corresponding to component and the target report component for treating preview；
According to layout information corresponding to the target report component for treating preview and the target form group for treating preview The related information of part, formation component describe file；
File is described to the component to render, to export the component level for including the target report component for treating preview Data sheet according to.
In an optional embodiment, in response to the component preview operation of the user, analog storage treats the target of preview Layout information corresponding to report component, to treat Report layouts ID corresponding to the target report component of preview described in acquisition, including：
User terminal where receiving the graphic interface is constructed and sent for the target report component for treating preview Layout information；
Layout information corresponding to the target report component for treating preview is disassembled as Report layouts ID, described treats preview The ID of target report component, the position of the target report component for treating preview and size, it is corresponding to store into the layout table.
In an optional embodiment, according to Report layouts ID corresponding to the target report component for treating preview, obtain The related information of layout information and the target report component for treating preview corresponding to the target report component for treating preview, Including：
Receive the component preview request that the user terminal is sent, the component preview request, which carries, described treats preview The Report layouts ID that layout information corresponding to target report component is disassembled out；
The Report layouts ID carried according to the component preview request, the mesh of preview is treated described in reading from the layout table Mark the ID of report component, the position of the target report component for treating preview and size；
According to the ID of the target report component for treating preview, read from the component table described in treat the target report of preview The attribute and property value of table component；
According to layout information corresponding to the target report component for treating preview and the target form group for treating preview The related information of part, formation component describe file, including：
According to the position of the target report component for treating preview and size and the target report component for treating preview Attribute and property value, formation component describes file.
The embodiment of the present application also provides a kind of data sheet processing unit, including：
Display module, for present graphical interface, the graphic interface includes report component and the layout that can be dragged Panel, so that user lays target report component on the layout panel；
Acquisition module, for being operated in response to component Configuration of the user on the graphic interface, described in acquisition The related information of layout information and the target report component between target report component；
Generation module, for according to the layout information between the target report component and the target report component Related information, generate report description (RD) file；
Rendering module, for being rendered to the report description (RD) file, with output data form.
In an optional embodiment, described device also includes：
Determining module, for the drag operation in response to the user to report component, it is determined that being drawn to by the user Report component on the layout panel, as the target report component.
In an optional embodiment, the acquisition module is specifically used for：
Operated in response to the component edits of the user, edit the related information of the target report component；
Operated in response to the distributing adjustment of the user, adjust the layout between the target report component；
Operation is submitted in configuration in response to the user, obtains the layout information between the target report component and institute State the related information of target report component.
In an optional embodiment, editor's entrance of the target report component is included on the graphic interface；
The acquisition module is specifically used for：Trigger action in response to the user to editor's entrance, to the use Family shows information editing's page corresponding to the target report component；And in response to the user in described information edit page On edit operation, the data query sentence and/or style information of the target report component that the user is inputted, as The related information of the target report component.
In an optional embodiment, the acquisition module is specifically used for：
In response to dragging of the user to the target report component and/or zoom operations, the target form is adjusted The position of component and/or size.
In an optional embodiment, the generation module is specifically used for：
Request or form preview request are sent in response to the form of the user, is obtained between the target report component The related information of layout information and the target report component；
HTML is done to the related information of the layout information between the target report component and the target report component Label mapping, to generate the report description (RD) file of html format.
In an optional embodiment, described device also includes：
Memory module, in a manner of structured storage, store layout information between the target report component and The related information of the target report component.
In an optional embodiment, the memory module is specifically used for：
The related information of the target report component is stored to the component table of the structuring into the relevant database；
Layout information between the target report component is stored into relevant database in the layout table of structuring.
In an optional embodiment, layout information of the generation module between the target report component is obtained with And the target report component related information when, be specifically used for：
Request or form preview request are sent in response to the form of the user, from the layout table and the component table The related information of the layout information and the target report component between the target report component is read respectively.
In an optional embodiment, the memory module is specifically used for：
Layout information between the target report component is disassembled as Report layouts ID, the target report component ID, the position of the target report component and size, it is corresponding to store into the layout table；
The related information of the target report component is disassembled into the ID of the target report component, the target form group The attribute and property value of part, corresponding storage is into the component table.
In an optional embodiment, the form, which sends request or form preview request, includes the target report component Between the Report layouts ID that disassembles out of layout information；
The generation module between the target report component is read respectively from the layout table and the component table Layout information and the target report component related information when, be specifically used for：
The Report layouts ID of request or the carrying of form preview request is sent according to the form, is read from the layout table The position and size of the ID of the target report component and the target report component；
According to the ID of the target report component, read from the component table target report component attribute and Property value.
In an optional embodiment, the generation module to the layout information between the target report component and When the related information of the target report component does html tag mapping, it is specifically used for：
The report component that the ID of the target report component is identified, it is defined as the report description (RD) file of the html format In html tag；
By the attribute and property value of the target report component, the content and/or pattern of the html tag are mapped as；
By the position of the target report component and size, the attribute of the html tag, the attribute instruction are mapped as The html tag corresponds to position and the size of HTML unit lattice.
In an optional embodiment, the generation module will read the target report component in the component table Attribute and property value, when being mapped as the content and/or pattern of the html tag, it is specifically used for：
If the attribute of the target report component includes data attribute, the data query sentence as property value is inquired Result data fill the position of the content of the html tag defined in report description (RD) file to the html format；
If the attribute of the target report component includes Style Attributes, the style information as property value is filled to generation The position of the CSS file patterns of the label association of the html tag defined in the report description (RD) file of the html format.
In an optional embodiment, described device also includes：
Component storage module, for the component preview operation in response to the user, analog storage treats the target report of preview Layout information corresponding to table component, to treat Report layouts ID corresponding to the target report component of preview described in acquisition；
The acquisition module is additionally operable to：According to Report layouts ID corresponding to the target report component for treating preview, obtain The related information of layout information and the target report component for treating preview corresponding to the target report component for treating preview；
The generation module is additionally operable to：According to layout information corresponding to the target report component for treating preview and described The related information of the target report component of preview is treated, formation component describes file；
The rendering module is additionally operable to：File is described to the component to render, and preview is treated comprising described with output The component level data sheet of target report component.
In an optional embodiment, the component storage module is specifically used for：
User terminal where receiving the graphic interface is constructed and sent for the target report component for treating preview Layout information；
Layout information corresponding to the target report component for treating preview is disassembled as Report layouts ID, described treats preview The ID of target report component, the position of the target report component for treating preview and size, it is corresponding to store into the layout table.
In an optional embodiment, the acquisition module is corresponding for obtaining the target report component for treating preview Layout information and described when the related information of the target report component of preview, be specifically used for：
Receive the component preview request that the user terminal is sent, the component preview request, which carries, described treats preview The Report layouts ID that layout information corresponding to target report component is disassembled out；
The Report layouts ID carried according to the component preview request, the mesh of preview is treated described in reading from the layout table Mark the ID of report component, the position of the target report component for treating preview and size；
According to the ID of the target report component for treating preview, read from the component table described in treat the target report of preview The attribute and property value of table component；
The generation module is specifically used for when formation component describes file：According to the target form group for treating preview The attribute and property value of the position of part and size and the target report component for treating preview, formation component describe file.
A kind of electronic equipment, including one or more memories and one or more processing is also disclosed in the embodiment of the present application Device；One or more of memories are used to store one or more computer instruction, one or more computer instruction The step that can be realized during one or more of computing devices in any of the above-described embodiment of the method.
A kind of computer-readable recording medium for being stored with computer program, the computer is also disclosed in the embodiment of the present application Program can realize the step in any of the above-described embodiment of the method when being computer-executed.
In the embodiment of the present application, data sheet processing unit provides a user graphic interface, is wrapped on graphic interface The report component that can be dragged and layout panel are included, user drags report component to layout panel, and on graphic interface Carry out component Configuration and operate the layout operation that can be completed to report component, without writing configuration file corresponding to data sheet, And position and/or the size of report component need to be only adjusted when the layout of report component changes every time by graphic interface , operation is relatively easy, more friendly, flexible in terms of report component is laid, and is advantageous to improve report generation efficiency.
Brief description of the drawings
Accompanying drawing described herein is used for providing further understanding of the present application, forms the part of the application, this Shen Schematic description and description please is used to explain the application, does not form the improper restriction to the application.In the accompanying drawings：
Fig. 1 a are the schematic flow sheet for the data sheet processing method that the embodiment of the application one provides；
Fig. 1 b are the schematic diagram that report component is laid out in the layout panel that the embodiment of the application one provides；
Fig. 2 a are the page of data query sentence corresponding to the user configuration target report component of the embodiment of the application one offer The schematic diagram in face；
Fig. 2 b- Fig. 2 d are the page of the style information for the user configuration target report component that the embodiment of the application one provides Schematic diagram；
Fig. 3 is the component table that another embodiment of the application provides and the schematic diagram for realizing structure of layout table；
Fig. 4 a are the structural representation that the data sheet that the another embodiment of the application provides generates system；
Fig. 4 b are a kind of schematic diagram for the graphic interface that the another embodiment of the application provides；
Fig. 4 c are the schematic diagram of the layout between report component in the layout panel that the another embodiment of the application provides；
Fig. 4 d are that the attribute of target report component and property value arrive in the component table that the another embodiment of the application provides The code schematic diagram of the content of html tag and/or the mapping process of pattern；
Fig. 4 e be in the layout component that the another embodiment of the application provides the position of target report component and size to HTML The position of label and the code schematic diagram of the mapping process of size；
Fig. 4 f are the effect diagram for the form of display data in a browser that the another embodiment of the application provides；
Fig. 4 g are the effect diagram of display data form in mailbox that the another embodiment of the application provides；
Fig. 5 a are the method for report form preview component in data sheet generating process that the another embodiment of the application provides Schematic flow sheet；
Fig. 5 b are the schematic diagram for the preview effect of component exhibiting in a browser that the another embodiment of the application provides；
Fig. 6 is the structural representation for the data sheet processing unit that the another embodiment of the application provides.
Embodiment
To make the purpose, technical scheme and advantage of the application clearer, below in conjunction with the application specific embodiment and Technical scheme is clearly and completely described corresponding accompanying drawing.Obviously, described embodiment is only the application one Section Example, rather than whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not doing Go out under the premise of creative work the every other embodiment obtained, belong to the scope of the application protection.
In actual applications, many scenes will use data sheet.Data sheet mainly can with form and figure etc. Carry out intuitively display data depending on changing component.The type and pattern of data sheet are various, common are financial data form, sale number According to form, operation data form etc..In some scenes, data sheet uses mainly for data sheet provider oneself.Another In some scenes, data sheet uses mainly for data sheet party in request, and in this scene, data providing can be according to pre- The data content first appointed and Report layouts, generate data sheet and be sent to data sheet party in request.
No matter data sheet be for data sheet provider oneself using or for data sheet party in request use, also no matter It is what kind of data sheet, the problem of all suffering from generating data sheet.The application following examples provide generation data The method of form, relatively easy with operating, layout configuration aspect is more friendly, flexible, is easy to the advantages such as personalization, is advantageous to Improve report generation efficiency.
Fig. 1 a are the schematic flow sheet for the data sheet processing method that the embodiment of the application one provides.As shown in Figure 1a, institute The method of stating comprises the following steps：
101st, present graphical interface, the graphic interface include the report component that can be dragged and layout panel, for User lays target report component on layout panel.
102nd, operated in response to component Configuration of the user on graphic interface, obtain the layout between target report component The related information of information and target report component.
103rd, according to the layout information between target report component and the related information of target report component, form is generated File is described.
104th, report description (RD) file is rendered, with output data form.
In the present embodiment, referring to step 101, when generating data sheet, to user's present graphical interface, the figure Change report component and layout panel that interface includes dragging.Report component includes but is not limited to：Figure and form；Figure can be with It is line chart, sector diagram, block diagram etc..These report components are the form of expression of the data content in data sheet.Range of distribution Plate is the subregion in graphic interface, for laying report component for user.
What deserves to be explained is the present embodiment does not limit the way of realization of graphic interface, every can include can drag Report component and layout panel styles be applied to the embodiment of the present application.
Based on the graphic interface of step 101 displaying, in the report component that user be able to can drag from graphic interface The report component for selecting oneself to need, and the report component needed for oneself can be dragged into cloth according to the Report layouts' demand of oneself Suitable position in situation plate.For ease of describing and distinguishing, the report component that user is dragged in layout panel is referred to as target Report component.The report component that target report component i.e. user generated data form need.To data report form processing device For, drag operation of the user to report component is may be in response to, determines the report component that user is drawn on layout panel, as Target report component.
In data sheet, report component is the form of expression of data content.To ensure the expression effect of report component, In the present embodiment, in addition to allowing user to drag report component to layout panel, also allow user to dragging to layout panel On target report component carry out configuration operation, referred to as component Configuration operates.
Alternatively, said modules configuration operation includes：Configure the operation of the related information of target report component, referred to as group Part edit operation.The related information of the target report component is primarily referred to as the information related to target report component, such as can With the information for the data content for needing to show including target report component, target report component display data content can also be included Required style information etc..Wherein, the information of data content that target report component needs to show can be data content in itself, It can also be the chained address of data content, can also be the data query sentence etc. for obtaining data content.
Alternatively, user can also further adjust target report after target report component to be dragged to layout panel The position of table component and/or size.Therefore, said modules configuration operation can also include：Between configuration target report component The operation of layout, referred to as distributing adjustment operate.Here distributing adjustment operation is primarily referred to as user and adjusts the mesh being laid out on panel Mark the position of report component and/or the process of size.Wherein, target can be adjusted flexibly according to the layout requirements of oneself in user The position of report component and/or size.
In actual application, user can only configure target report component when carrying out said modules configuration operation Related information (i.e. executive module edit operation), or only configure target report component between layout (i.e. perform layout adjust Whole operation).Certainly, user can also both configure the related information (i.e. executive module edit operation) of target report component, match somebody with somebody again Put the layout (performing distributing adjustment operation) between target report component.
In the case of user's executive module edit operation simultaneously and distributing adjustment operate：Data sheet processing unit can ring It should be operated in the component edits of user, edit the related information of target report component, operated, adjust in response to the distributing adjustment of user Layout between whole target report component；Then, the configuration in response to user, which is submitted, operates, between acquisition target report component The related information of layout information and target report component.
What deserves to be explained is the situation of above-mentioned user executive module edit operation simultaneously and distributing adjustment operation, in reality During implementation, it can be that user often pulls a target report component to panel is laid out, just edit the association of the target report component Information, after so having edited multiple target report components, then edit the layout between target report component；Or or Multiple target report components are disposably pulled to layout panel, then edit the layout between target report component, then enter one by one The related information of edlin target report component.
Alternatively, user is in the layout between editing target report component, can by drag target report component, with Change the position of target report component；By being zoomed in and out to target report component, to change the size of target report component.It is right For data sheet processing unit, dragging and/or zoom operations of the user to target report component are may be in response to, adjusts target report The position of table component and/or size.Or
Alternatively, user can change target report in the layout between editing target report component by configuration interface The position coordinates of table component, to change the position of target report component；By configuration interface, the height of modification target report component is wide Parameter or scaling, to change the size of target report component.
Alternatively, user can pass through the related information of information editing's page editing target report component.It is for example, graphical Include editor's entrance of target report component on interface.It can be button, icon or setting options etc. to edit entrance.Based on this, User can be operated by editing entrance triggering to the component edits of target report component.For example, user can click on or touch-control Editor's entrance, operated with the component edits triggered to target report component.For data report form processing device, it can ring Should in user to edit entrance trigger action, to user show target report component corresponding to information editing's page, for The related information that family passes through information editing's page editing target report component；And then in response to user on information editing's page Edit operation, by user input target report component data query sentence and/or style information, as target form group The related information of part.
Alternatively, above- mentioned information edit page can be one or more, for example, it may be independently of graphic interface The page or the page being embedded in graphic interface.As shown in Figure 2 a, it is corresponding to user configuration target report component The page of data query sentence.For example, user can double-click target report component, hence into information editing's page shown in Fig. 2 a Face, data query sentence corresponding to target report component, such as SQL statement are then inputted in information editing's page.Fig. 2 a Shown in SQL statement it is merely illustrative.Further, it is the style information of user configuration target report component as shown in Fig. 2 b- Fig. 2 d The page, by configuring the pattern of target report component, be conducive to provide data sheet more attractive in appearance.For example, user can be with Font, font size, color, background colour, frame, line thickness in configuration target report component etc..Further, can also configure is It is no a form component be assembled into annex, whether procession transposition etc..As can be seen here, graphic interface, form group are passed through The configuration of part, the configuration of assembly layout, the configuration of component pattern can realize visualization.
, can be in response to user in graphic interface as described in step 102 from the perspective of data sheet processing unit On component Configuration operation, obtain target report component between layout information and target report component related information.Extremely This, the configuration of report component and the configuration process of layout terminate.In the configuration process, user only need to be on graphic interface Shirtsleeve operation, such as dragging, zoom operations, input etc. are carried out, without writing configuration file corresponding to Report layouts, operates phase To simple, personalized layout flexibly, conveniently, efficiently and is more easily realized.
As shown in Figure 1 b, it is a kind of schematic diagram for assembly layout that user configures on layout panel.In group described in Fig. 1 b In part layout, row polymerization device assembly (table-rows-aggregator), the left side cloth of second row are laid with the left of first row Provided with row iteration device assembly (table-rows-iterator), and；3rd arrangement sets a data text (text), occupies the One row and second row right part are provided with sector diagram (chart-builder：pie).Row iteration device assembly, row shown in Fig. 1 b is poly- Clutch component, data text, sector diagram etc. are all the visualization components in data sheet.
For data report form processing device, layout information and target form group between target report component is obtained , it is necessary to according to the layout information between target report component and the related information of target report component after the related information of part Data sheet is generated, report description (RD) file is generated, as described in step 103.Report description (RD) file refers to the text for describing data sheet Part, this document can not only embody the layout of data sheet, and can point to the data content needed for data sheet.To needing For the equipment of display data form, different programming languages can be typically supported, report description (RD) file can use different volumes Cheng Yuyan is realized.For example, report description (RD) file can be the file realized using java language, the text realized using c# language The file that part, the file realized using c language are either realized using html language.
With continued reference to step 104, by being rendered to report description (RD) file, with output data form.Rendering here It is primarily referred to as the related information by report description (RD) file loaded targets report component and target report component, and reasonable arrangement Layout between target report component, and then the process of data sheet is presented.
In the present embodiment, by providing a user graphic interface, the form group that can be dragged is included on graphic interface Part and layout panel, user drags report component to layout panel, and component Configuration operation is carried out on graphic interface The layout operation to report component can be completed, without writing configuration file corresponding to data sheet, and each report component Layout position and/or the size of report component need to be only adjusted when changing by graphic interface, operation is relatively simple It is single, it is more friendly, flexible in terms of report component is laid, be advantageous to improve report generation efficiency.
, will after the configuration of report component and assembly layout is completed in above-described embodiment or following embodiments It is related to the displaying of data sheet.In a kind of application scenarios, user needs preview data form, now needs in the exhibition of user side Show data sheet.In another application scenarios, user can click on send button, and data sheet is sent into data sheet needs The side of asking, now need in data sheet party in request side display data form.Either which kind of application scenarios, display data form Process be primarily related to according to before configuration report component between layout and report component related information generation The process of data sheet.
In an optional embodiment, a kind of process of display data form includes：Form transmission in response to user please Ask or form preview request, obtain the related information of the layout information and target report component between target report component；Root According to the layout information between target report component and the related information of target report component, report description (RD) file is generated；And then Report description (RD) file is rendered, with output data form.
Wherein, supporting the programming language of data sheet has many kinds, such as java, c#, c with HTML etc..Wherein, HTML languages Speech is to use a kind of most common, most extensive and most advantageous language, therefore preferentially uses HTML in embodiments herein Language realizes data sheet.Based on this, when needing display data form, request or report can be sent in response to the form of user Table preview request, obtain the related information of the layout information and target report component between target report component；To target report The related information of layout information and target report component between table component does html tag mapping, to generate html format Report description (RD) file；And then the report description (RD) file to html format renders, simultaneously output data form is generated.
In the present embodiment, there is corresponding relation between the report component on html tag and graphic interface.One kind report Table component can be mapped as a html tag.To be enriched relatively in view of the species of report component, therefore the application is implemented Example allows to be extended html tag, so that the report component on graphic interface can be mapped as a html tag, enters And the report description (RD) document structure tree data sheet based on html format.For example, it is directed to table-rows-iterator, table- The form groups such as rows-aggregator, figure (chart-builder) iteration print label (iterate-printer), text Part, corresponding html tag can be extended.When extending html tag, it is allowed to which the html tag for extension defines the data of oneself User behavior and organizational form, so as to support data query behavior with a greater variety and more flexible Method of Data Organization.Under Face illustrates the implication of the html tag extended corresponding to the report component of part by table 1：
Table 1
Based on the mapping relations between above-mentioned report component and html tag, to the layout information between target report component And the related information of target report component does html tag mapping, to generate the report description (RD) file of html format actually It is：Target report component is defined as the html tag in the report description (RD) file of html format, by the pass of target report component Join process of the information definition for the relevant information of corresponding html tag.If the related information of target report component includes data query Sentence, the then result data that can be inquired data query sentence are defined as the content of corresponding html tag；If target form The related information of component includes style information, then can by the style definitions of target report component be corresponding html tag sample Formula, such as the CSS files according to corresponding to the style information of target report component generates corresponding html tag.
After the report description (RD) file of html format is obtained, rendered by the report description (RD) file to html format Data sheet is can obtain, by exhibiting data reporting form to data sheet provider or data sheet party in request.It is it is alternatively possible to logical Cross browser, mail or form App display data forms.
In actual applications, the association of the layout information and target report component between using target report component is believed Before breath, the related information of the layout information and target report component between target report component can be stored, is so being needed When generating report description (RD) file, can be read directly into respective stored space layout information between target report component with And the related information of target report component.
In the embodiment of the present application, user is allowed to carry out additions and deletions to target report component and change the behaviour such as to look into based on graphic interface Make.The additions and deletions of front end change the related information looked into and can influence layout information and/or target report component between target report component, To coordinate the additions and deletions of front end to change and look into, layout information between target report component and described is stored using structured storage mode The related information of target report component is a kind of preferable storage mode.
In an optional embodiment, in a manner of structured storage, store target report component between layout information with And the related information of target report component includes：The layout table of structuring and the component of structuring are created in relevant database Table；In the layout table that layout information between target report component is stored into relevant database to structuring；By target report The related information of table component stores into relevant database the component table of structuring.Relevant database can use but unlimited In：Oracle, sqlserver etc..
Based on above-mentioned, when needing display data form, such as user triggers form and sends operation or form preview operation When, the form that may be in response to user sends request or form preview request, and target report is read respectively from layout table and component table The related information of layout information and target report component between table component；To the layout information between target report component with And the related information of target report component does html tag mapping, to generate the report description (RD) file of html format；It is and then right The report description (RD) file of html format renders, and generates simultaneously output data form.
Further, as shown in figure 3, one kind for component table and layout table realizes structure.Wherein, component table, its table name can It is designated as zr_visualize_comp tables, referred to as comp tables；Layout table, its table name can be designated as zr_visualize_layout, Referred to as layout tables.In component table and the table name of layout table, zr is the prefix of setting, and visualize is visual meaning Think, comp is the meaning of component, and layout is the meaning of layout.
Component table：It is mainly used in storing the related information of target report component.It is general for a complete report component Need to describe compared with multi information, these information all can be as the related information of report component.For example, a form has many category Property, (such as gauge outfit word, the data format of each row are displaying thousand points of positions or percentage for data query sentence, row metadata Form etc.), whether be converted to annex and annex name and whether procession transposition etc., pattern (width of form, gauge outfit The font size and color of table body, cell alignment, outer back gauge, interior filling etc.) etc..Similarly, figure (such as line chart, Block diagram or cake chart etc.), it can equally be related to the attributes such as data query sentence, xy axial directions word and pattern, title pattern.
In component table shown in Fig. 3, the ID of report component is stored with comp_id fields, each report component has one Globally unique ID；Data query sentence, row metadata/axial direction text that report component associates are stored with comp_key fields The attribute-names such as word, pattern；Specific data, i.e. property value corresponding to corresponding comp_key are stored with comp_data fields.Its In, a report component might have multiple attributes, therefore can correspond to multiple comp_key and comp_data combination.
Layout table：It is mainly used in storing the layout information between target report component.In layout table shown in Fig. 3, definition One from increase major key id fields, with the storage of layout_uuid fields can unique mark layout information Report layouts ID, one The corresponding layout_uuid field of layout information；Due to having wrapped up several report components in a layout information, therefore can be with Using comp_id as external key, and the form group included by the comp_id fields of comp tables come unique mark layout information Part.Wherein, layout_uuid and comp_id can be that (i.e. a layout information only wraps up a form group to man-to-man relation Part) or one-to-many relation (i.e. a layout information wraps up multiple report components).Alternatively, layout_uuid can Gone here and there with the alphanumeric mixing for being one 36, but not limited to this.Alternatively, layout_uuid can be as being subsequently generated The filename of the report description (RD) file of html format, naturally it is also possible to be used as the html format being subsequently generated by the use of from the integer for increasing id Report description (RD) file filename.
Further, in layout table shown in Fig. 3, with tetra- fields of x, y, width and height, form group is described respectively X-axis coordinate (or being x-axis offset), y-axis coordinate (or being y-axis offset), width and the height of part.Report component this Four attributes are that the graphical result pulled by front end user converts what is obtained.
In an optional embodiment, this four attributes can be with the following method by the graphical result of front end user dragging Conversion obtains：For being laid out panel, the xy coordinate-systems for the m*n being adapted to layout panel are created；M is that the unit that x-axis includes is carved The number of degree, n are the number for the unit scales that y-axis includes, and m, n are natural number；Based on the xy coordinate-systems, each mesh is obtained Mark x-axis coordinate, y-axis coordinate, width and the height of report component.
Still optionally further, the process of above-mentioned establishment xy coordinate-systems can be：It is determined that layout panel width and Short transverse is respectively x-axis and y-axis in xy coordinate-systems；The columns k specified on the width and width of panel will be laid out Ratio, as the value of the unit scales in xy coordinate-systems, wherein, m=k；Mark m*n side in xy coordinate-systems Lattice, the value of height/unit scales of n=layout panels；Coordinate value is assigned respectively for m*n grid, so as to obtain and be laid out The m*n of panel adaptation xy coordinate-systems.
Still optionally further, to each grid in the m*n grid, the side is identified based on the xy coordinate-systems The coordinate value of four points on lattice；From the coordinate value of four points on the grid, min coordinates value is selected as the grid Coordinate value.
Still optionally further, in the x-axis coordinate of each target report component of above-mentioned acquisition, y-axis coordinate, width and height During, coverage condition that can be according to target report component to the xy coordinate-systems medium square adjusts the target form Position and/or size of the component in panel is laid out.For example, with the minimum target of displacement, target report component is carried out Dragging and/or scaling so that target report component is located in q adjacent grids, and to the area coverage of q adjacent grids Reach setting ratio, q is natural number.By adjusting position and/or size of the target report component in panel is laid out, can make The dragging behavioral standard of user, be advantageous to carry out position of the target report component in panel is laid out and/or size accurate Identification and digitized conversion.
Based on the structure of the component table shown in Fig. 3, pass through the process of the related information of component table storage target report component Can be：By the related information of target report component disassemble into the ID of target report component, the attribute of target report component and Property value, corresponding storage is into component table.Specifically, distribute unique ID for target report component and store to comp_id Field；The related information of target report component is disassembled as attribute and property value, stored respectively to comp_key and comp_ In data fields.
Based on the structure of the layout table shown in Fig. 3, the layout information between target report component is stored by layout table Process can be：Layout information between target report component is disassembled as Report layouts ID, the ID of target report component, target The position of report component and size, it is corresponding to store into layout table.Specifically, unique form is distributed for target report component Layout ID is simultaneously stored into layout_uuid fields, and the target report that the layout information between target report component is wrapped up The ID of table component is stored into comp_id fields, is converted to obtain the x of each target report component by front end user drag operation Axle, y-axis coordinate, width and height, store respectively to tetra- fields of x, y, width and height.
Stored by the related information of the layout information between target report component and target report component to shown in Fig. 3 Layout table and component table after, Report layouts ID corresponding to the layout information between target report component can be obtained.It is based on This, when user, which triggers form, sends operation or form preview operation, form sends in request or form preview request and can carried Report layouts ID.For data report form processing device, the form that may be in response to user sends request or form preview request, root The Report layouts ID carried in request or form preview request is sent according to form, the ID of target report component is read from layout table And position and the size of target report component；Then, according to the ID of target report component, target form is read from component table The attribute and property value of component；Then, the report component ID of target report component identified, it is defined as the report of html format Table describes the html tag in file；By the attribute and property value of target report component, be mapped as html tag content and/ Or pattern；By the position of target report component and size, the attribute of html tag is mapped as, the attribute indicates the HTML marks The position of the corresponding HTML unit lattice of label and size, so as to obtain the report description (RD) file of html format；And then to html format Report description (RD) file renders, and generates simultaneously output data form.
Still optionally further, above-mentioned attribute and property value by target report component, it is mapped as the content of html tag And/or pattern, including：If the attribute of target report component includes data attribute, the data query sentence as property value is looked into The result data ask fills the position of the content of html tag defined in report description (RD) file to html format；If target report The attribute of table component includes Style Attributes, and the style information as property value is filled into the report description (RD) file of html format Define the position of the pattern of html tag.What deserves to be explained is except HTML defined in the report description (RD) file in html format Outside the pattern of label, the pattern of CSS document definition html tags can also be used.
In actual applications, the data sheet processing method that above-described embodiment provides can be implemented on autonomous device, such as PC, server or mobile phone etc..In addition, the data sheet processing method that the above embodiments of the present application provide also can be by Data sheet generates system to implement.As shown in fig. 4 a, the knot of system is generated for the data sheet that the embodiment of the application one provides Structure schematic diagram.As shown in fig. 4 a, the system includes user terminal 10, service end 20 and relevant database 30.Wherein, use Family terminal 10 is primarily referred to as data sheet provider, that is, needs to generate a side of data sheet.In realization, user terminal 10 will It can be communicated, and be needed with showing interface function with service end 20, such as can be browser or form APP etc., It is main to provide a user graphic interface, and support to interact operation with user.Service end 20 is located at network side or high in the clouds, is For client service, the main control logic and underlying services for providing data sheet generation.Relevant database 30 is main For storing information related to report component in report component processing procedure, for example, layout information between report component and Related information of report component etc..
Based on the system shown in Fig. 4 a, the generating process of data sheet includes：
Service end 20 is by user terminal 10 to user's present graphical interface, and user terminal 10 is to user's present graphical Interface, the graphic interface include the report component that can be dragged and layout panel, so that user lays on layout panel Target report component.
Alternatively, a kind of graphic interface is as shown in Figure 4 b.In fig. 4b, region shown in the square frame of upper left side sends for mail Information configuration area；Region shown in the square frame of upper right side is advanced setting area；Lower section square frame show layout panel and report component area； Region shown in dotted line frame is layout panel in the square frame of lower section, is report component area on the right side of layout panel, report component area includes The report component that can be dragged.
Drag operation of the user terminal 10 in response to user to report component, it is determined that being drawn to by user on layout panel Report component, as target report component.As shown in Figure 4 b, the report component being laid out in panel is drawn to layout panel for user On target report component.
For user, report component need to be only pulled to being laid out panel, and adjusts the layout between report component, configuration report The related information of table component.When completing final step operation, " preservation " (or other relevant buttons) can be clicked, is touched It is transported to and puts submission operation.For user terminal 10, component Configuration operation of the user on graphic interface is may be in response to, is obtained The related information of layout information and target report component between target report component, and submit behaviour in response to the configuration of user Make, the related information of the layout information and target report component between target report component is sent to service end 20.Such as Fig. 4 c Shown, the layout being laid out in panel between report component is the final assembly layout laid of user.
For service end 20, layout information and target between the target report component that user terminal 10 is sent are received The related information of report component；Then, the association of the layout information between target report component and target report component is believed Breath is stored into relational database 30 in the layout table of structuring and component table.For example, can be by between target report component The related information of layout information and target report component is stored into layout table and component table shown in Fig. 3.In addition, service end 20 Report layouts ID can be returned to user terminal 10, so that user terminal 10 understands the layout information between current goal report component And unique mark corresponding to the related information of target report component.
Further, when user needs the layout of preview data form, can click on shown in Fig. 4 b on graphic interface " preview template " button, so as to trigger form preview operation.Or when user needs data sheet being sent to data sheet need During the side of asking, " sending immediately " button on graphic interface shown in Fig. 4 b can be clicked on, operation is sent so as to trigger form.To with For family terminal 10, it may be in response to form of the user on graphic interface and send operation or form preview operation, to service end 20, which send form, sends request or form preview request, and carries Report layouts in form transmission request or form preview request ID.For service end 20, receive form and send request or form preview request.Then, service end 20 sends according to form and asked Ask or Report layouts ID that form preview request carries, target report component is read from the layout table of relevant database 30 The position and size of ID and target report component, and according to the ID of target report component, from the component of relevant database 30 The attribute and property value of target report component are read in table.
And then the report component that service end 20 identifies the ID of target report component, it is defined as html tag；By target report The attribute and property value of table component, it is mapped as the content and/or pattern of html tag；By the position of target report component and greatly It is small, position and the size of html tag are mapped as, so as to obtain the report description (RD) file of html format；And then to html format Report description (RD) file render, generate and output data form.As shown in figure 4d, it is target report component in a kind of component table Attribute and property value to the content of html tag and/or the mapping process of pattern.The mapping process is actually to one Label in file template corresponding to the report description (RD) file of html format correspondingly fills the attribute and category of target report component The process of property value.In above-mentioned file template, including some foundation codes, such as text (body), outermost layer are as container Div, it can also alternatively include uppermost CSS.What deserves to be explained is the CSS carried in file template typically defines acquiescence Pattern；If the attribute of target report component includes Style Attributes, can be mapped to during mapping in CSS, and The priority of these patterns can be higher, can override the default style of CSS definition originally.
Further, as shown in fig 4e, be in layout component the position of target report component and size to the position of html tag Put the mapping process with size.The position that square frame is identified in Fig. 4 e is redundant attributes corresponding to corresponding html tag.
By said process, the data sheet shown in a browser shown in Fig. 4 f can be obtained, or obtains Fig. 4 g institutes Show in data sheet shown in mailbox.It is worth explanation, Fig. 4 f and Fig. 4 g focus on the pattern or layout of data sheet, and The concrete numerical value being not concerned with data sheet.
In the above-described embodiments, in addition to allowing user to send datagram table to data sheet party in request, also support Line preview data form, this can allow user to learn the bandwagon effect of data sheet in time in order to be adjusted and optimize.
What deserves to be explained is during above-mentioned user's preview data form or the table that sends datagram, dependent on layout Report layouts ID corresponding to information.Based on this, when user's preview or send datagram table when, if target report corresponding to data sheet Layout information between table component saved mistake, it means that user terminal 10 has got Report layouts ID, then can be with Sent directly from local acquisition Report layouts ID and added to form preview request or form in asking and be sent to service end 20；If Layout information between target report component corresponding to data sheet be user just edit completion not yet preserve, it means that use Family terminal 10 not yet gets Report layouts ID, therefore needs that the layout information between target report component first is committed into service end 20, return to Report layouts ID after being preserved by service end 20, afterwards, can by Report layouts ID added to form preview request or Form sends in request and is sent to service end 20.
It is related to the operation of preview data form in the above-described embodiments, " preview " in above-described embodiment is form rank Preview, i.e., the related information of layout information and report component between the report component edited based on user, it is allowed to user The bandwagon effect of advance preview partial data form.In addition, the embodiment of the present application also provides a kind of preview of component-level Function, that is, allow the bandwagon effect of user's preview target report component after a certain target report component is laid, so may be used It is adjusted and optimizes with the report component wrong or unfavourable to laying.
The embodiment of the present application is all to can be achieved on component level for how to realize that the preview function of component-level does not limit The embodiment of other preview function is applied to the embodiment of the present application.Alternatively, for the preview realization side with form rank Case is mutually compatible, reaches the purpose of code reuse, reduces the change to bottom code, the embodiment of the present application provides the pre- of component-level Look at a kind of optional embodiment of function.The central principle of the optional embodiment is：Preview and report in view of component-level The other preview of table level is compared, and lacks the layout information between report component, and then lacks Report layouts ID, is then laid in user After target report component, in response to the component preview operation of user, can analog storage treat that the target report component of preview is corresponding Layout information, treat Report layouts ID corresponding to the target report component of preview to obtain, thus can be based on treating preview Report layouts ID corresponding to target report component, acquisition treat layout information corresponding to the target report component of preview and treat preview Target report component related information；Layout information and the mesh of preview is treated according to corresponding to the target report component for treating preview The related information of report component is marked, formation component describes file；File is described to component to render, and is included with output and is treated preview Target report component component level data sheet, so that user learns the bandwagon effect for the target report component for treating preview, just It is adjusted and optimizes in time.
Based on a kind of above-mentioned, optional embodiment of report form preview component bandwagon effect in data sheet generating process, As shown in Figure 5 a, comprise the following steps：
501st, user terminal is to user's present graphical interface, the graphic interface include the report component that can be dragged and Panel is laid out, so that user lays target report component on layout panel.
502nd, drag operation of the user terminal in response to user to report component, determine that user is dragged on layout panel Report component, as target report component.
503rd, user terminal operates in response to user for the component edits of above-mentioned target report component, obtains target form The related information of component.
504th, user terminal preserves operation in response to user for the editor of above-mentioned target report component, by target form group The related information of part sends service end.
505th, the related information of target report component is disassembled the ID for target report component, target report component by service end Attribute and property value, it is corresponding to store into the structural components table of relevant database.
506th, the ID of target report component is returned to user terminal by service end.
507th, user terminal is directed to the component preview operation of above-mentioned target report component in response to user, to treat the mesh of preview Mark report component structure arrangement information.
Wherein, the target report component for treating preview is the target report component that user asks preview.
For user perspective, the purpose of component preview operation be it is whether correct or rationally in order to verify report component, it is real On border and the layout of report component is not concerned with, as long as therefore report component is showed showing user.So can be with Flexibly, arbitrarily construction treats layout information corresponding to the target report component of preview.Construction treats that the target report component of preview is corresponding Layout information be actually construct tetra- parameters of x, y, width and height.
Alternatively, the upper left corner for being set in data sheet goes displaying to treat the target report component of preview, then can construct ginseng The value of x and y in number x, y, width and height are 0 (i.e. the upper left corner), and width and height are default value, such as 1 Unit, 2 units etc..Wherein, 1 unit represents how many pixel, and depending on concrete application demand, such as 1 unit can be with Represent 100px.In addition, width and height units would also vary from.
508th, layout information corresponding to the target report component for treating preview is sent to service end by user terminal, treats preview Layout information corresponding to target report component carries the ID for the target report component for needing preview.
509th, layout information corresponding to the target report component for treating preview is disassembled as Report layouts ID, treats preview by service end Target report component ID, treat preview target report component position and size, it is corresponding to store to relevant database In structured layout table.
510th, service end receives the component preview request that user terminal is sent, and the component preview request, which carries, needs preview Target report component corresponding to the Report layouts ID that disassembles out of layout information.
511st, the Report layouts ID that service end carries according to component preview request, the target for treating preview is read from layout table The ID of report component, treat preview target report component position and size.
512nd, service end is according to the ID of the target report component for treating preview, read from component table described in treat the target of preview The attribute and property value of report component.
513rd, position and size and the target report component for the treatment of preview of the service end according to the target report component for treating preview Attribute and property value, formation component describes file.
514th, service end describes file to component and rendered, to export the component for including the target report component for treating preview DBMS form.
Assuming that the target report component for treating preview is a form, then group as shown in Figure 5 b can be obtained by aforesaid operations Part DBMS form.In figure 5b, a part for component level data sheet is only shown.
In the present embodiment, the preview of component-level is introduced, is advantageous to the bandwagon effect that user learns report component in time, It is easy to be adjusted and optimize in time, is advantageous to improve the formation efficiency of data sheet；In addition, by being that automatic imitation storage is treated Report layouts ID corresponding to the target report component of preview is treated in layout information corresponding to the target report component of preview, acquisition, from And the preview implementation of form rank can be used to realize the preview of component-level, code reuse is realized, to bottom code Change relatively small, cost of implementation is relatively low.
It should be noted that the executive agent that above-described embodiment provides each step of method may each be same equipment, Or this method is also by distinct device as executive agent.For example the executive agent of step 101 to step 104 can be equipment A；Again for example, step 101 and 102 executive agent can be device A, and step 103 and 104 executive agent can be equipment B； Etc..
Fig. 6 is the structural representation for the data sheet processing unit that the another embodiment of the application provides.As shown in fig. 6, institute Stating device includes：Display module 61, acquisition module 62, generation module 63 and rendering module 64.
Display module 61, for present graphical interface, the graphic interface includes the report component and cloth that can be dragged Situation plate, so that user lays target report component on the layout panel.
Acquisition module 62, for being operated in response to component Configuration of the user on the graphic interface, obtain the mesh Mark the related information of the layout information and the target report component between report component.
Generation module 63, for according to the layout information between the target report component and the target report component Related information, generate report description (RD) file.
Rendering module 64, for being rendered to the report description (RD) file, with output data form.
In an optional embodiment, described device also includes：Determining module, in response to user to report component Drag operation, it is determined that the report component on the layout panel is drawn to by user, as target report component.
In an optional embodiment, acquisition module 62 is specifically used for：
Operated in response to the component edits of user, edit the related information of target report component；
Operated in response to the distributing adjustment of user, adjust the layout between target report component；
Operation is submitted in configuration in response to user, obtains layout information and target form group between target report component The related information of part.
In an optional embodiment, editor's entrance of target report component is included on the graphic interface.Based on this, Acquisition module 62 is specifically used for when editing the related information of target report component：In response to triggering of the user to editor's entrance Operation, information editing's page corresponding to target report component is shown to user；And in response to user on information editing's page Edit operation, by user input target report component data query sentence and/or style information, as target form group The related information of part.
In an optional embodiment, acquisition module 62 is specifically used in the layout between adjusting target report component： In response to dragging of the user to target report component and/or zoom operations, the position of adjustment target report component and/or size.
In an optional embodiment, generation module 63 is specifically used for：Request or form are sent in response to the form of user Preview request, obtain the related information of the layout information and target report component between target report component；To target form The related information of layout information and target report component between component does html tag mapping, to generate the report of html format Table describes file.
In an optional embodiment, described device also includes：Memory module, in a manner of structured storage, storing The related information of layout information and target report component between target report component.
In an optional embodiment, memory module is specifically used for：The related information of target report component is stored to pass It is the component table of structuring in type database；Layout information between target report component is stored and tied into relevant database In the layout table of structure.
In an optional embodiment, layout information and target of the generation module 63 between target report component is obtained During the related information of report component, it is specifically used for：Request or form preview request are sent in response to the form of user, from layout table And the related information of the layout information and target report component between target report component is read in component table respectively.
In an optional embodiment, memory module is specifically used for：Layout information between target report component is disassembled It is corresponding to store into layout table for Report layouts ID, the ID of target report component, the position of target report component and size；Will The related information of target report component disassembles into the attribute and property value of the ID of target report component, target report component, right It should store in component table.
In an optional embodiment, form, which sends request or form preview request, includes the cloth between target report component The Report layouts ID that office's information is disassembled out.Based on this, generation module 63 is reading target report respectively from layout table and component table During the related information of layout information and target report component between table component, it is specifically used for：
The Report layouts ID of request or the carrying of form preview request is sent according to form, target form is read from layout table The ID of component and position and the size of target report component；
According to the ID of target report component, the attribute and property value of reading target report component from component table.
In an optional embodiment, generation module 63 is to the layout information between target report component and target report When the related information of table component does html tag mapping, it is specifically used for：
The report component that the ID of target report component is identified, the HTML being defined as in the report description (RD) file of html format Label；
By the attribute and property value of target report component, the content and/or pattern of html tag are mapped as；
By the position of target report component and size, the attribute of html tag is mapped as, the attribute indicates the HTML Label corresponds to position and the size of HTML unit lattice.
In an optional embodiment, generation module 63 will read the attribute and category of target report component in component table Property value, when being mapped as the content and/or pattern of html tag, is specifically used for：
If the attribute of target report component includes data attribute, knot that the data query sentence as property value is inquired Fruit data fill the position of the content of html tag defined in report description (RD) file to html format；
If the attribute of target report component includes Style Attributes, the style information as property value is filled to the HTML The position of the pattern of the html tag defined in the report description (RD) file of form.
In an optional embodiment, described device also includes：Component storage module, it is pre- for the component in response to user Look at operation, analog storage treats layout information corresponding to the target report component of preview, to obtain the target report component for treating preview Corresponding Report layouts ID.Based on this, acquisition module 62 is additionally operable to：The form cloth according to corresponding to the target report component for treating preview Office ID, obtain the association letter for the target report component treated layout information corresponding to the target report component of preview and treat preview Breath.Correspondingly, generation module 63 is additionally operable to：Layout information and preview is treated according to corresponding to the target report component for treating preview The related information of target report component, formation component describe file.Correspondingly, rendering module 64 is additionally operable to：Text is described to component Part is rendered, to export the component level data sheet for including the target report component for treating preview.
In an optional embodiment, component storage module is specifically used for：Receiving graphic interface place user terminal is Treat the layout information that the target report component of preview is constructed and sent；Layout information corresponding to the target report component of preview will be treated Disassemble for Report layouts ID, the target report component for treating preview ID, treat preview target report component position and size, it is right It should store into layout table.
In an optional embodiment, acquisition module 62 is treating layout corresponding to the target report component of preview for obtaining When information and the related information when the target report component of preview, it is specifically used for：
The component preview request that user terminal is sent is received, component preview request carries the target report component for needing preview The Report layouts ID that corresponding layout information is disassembled out；
The Report layouts ID carried according to component preview request, the target report component for treating preview is read from layout table ID, treat preview target report component position and size；
According to the ID for the target report component for treating preview, the attribute for the target report component for treating preview is read from component table And property value.
In an optional embodiment, generation module 63 is specifically used for when formation component describes file：
According to the attribute of the position for the target report component for treating preview and size and the target report component for treating preview with And property value, formation component describe file.
The data sheet processing unit that the present embodiment provides, available for the flow for performing above-mentioned data sheet processing method, Its operation principle repeats no more, and refers to the description of above method embodiment.
The data sheet processing unit that the present embodiment provides, it can be the independent equipment for carrying out data sheet processing, also may be used Be with user terminal coordinate carry out data sheet processing server device.
The data sheet processing unit that the present embodiment provides, provides a user graphic interface, includes on graphic interface The report component and layout panel that can be dragged, user drag report component to layout panel, and enterprising in graphic interface The operation of row component Configuration can complete the layout operation to report component, without writing configuration file corresponding to data sheet, and And only need to be by the position of graphic interface adjustment report component and/or size i.e. when the layout of report component changes every time Can, operation is relatively easy, more friendly, flexible in terms of report component is laid, and is advantageous to improve report generation efficiency.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program Product.Therefore, the present invention can use the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware Apply the form of example.Moreover, the present invention can use the computer for wherein including computer usable program code in one or more The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.) The form of product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product Figure and/or block diagram describe.It should be understood that can be by every first-class in computer program instructions implementation process figure and/or block diagram Journey and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided The processors of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce A raw machine so that produced by the instruction of computer or the computing device of other programmable data processing devices for real The device for the function of being specified in present one flow of flow chart or one square frame of multiple flows and/or block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data processing devices with spy Determine in the computer-readable memory that mode works so that the instruction being stored in the computer-readable memory, which produces, to be included referring to Make the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented processing, so as in computer or The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one The step of function of being specified in individual square frame or multiple square frames.
In a typical configuration, computing device includes one or more processors (CPU), input/output interface, net Network interface and internal memory.
Internal memory may include computer-readable medium in volatile memory, random access memory (RAM) and/or The forms such as Nonvolatile memory, such as read-only storage (ROM) or flash memory (flash RAM).Internal memory is computer-readable medium Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method Or technology come realize information store.Information can be computer-readable instruction, data structure, the module of program or other data. The example of the storage medium of computer includes, but are not limited to phase transition internal memory (PRAM), static RAM (SRAM), moved State random access memory (DRAM), other kinds of random access memory (RAM), read-only storage (ROM), electric erasable Programmable read only memory (EEPROM), fast flash memory bank or other memory techniques, read-only optical disc read-only storage (CD-ROM), Digital versatile disc (DVD) or other optical storages, magnetic cassette tape, the storage of tape magnetic rigid disk or other magnetic storage apparatus Or any other non-transmission medium, the information that can be accessed by a computing device available for storage.Define, calculate according to herein Machine computer-readable recording medium does not include temporary computer readable media (transitory media), such as data-signal and carrier wave of modulation.
It should also be noted that, term " comprising ", "comprising" or its any other variant are intended to nonexcludability Comprising so that process, method, commodity or equipment including a series of elements not only include those key elements, but also wrapping Include the other element being not expressly set out, or also include for this process, method, commodity or equipment intrinsic want Element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that wanted including described Other identical element also be present in the process of element, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer program product. Therefore, the application can be using the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware Form.Deposited moreover, the application can use to can use in one or more computers for wherein including computer usable program code The shape for the computer program product that storage media is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.) Formula.
Embodiments herein is the foregoing is only, is not limited to the application.For those skilled in the art For, the application can have various modifications and variations.All any modifications made within spirit herein and principle, it is equal Replace, improve etc., it should be included within the scope of claims hereof.
The embodiment of the present application discloses A1, a kind of data sheet processing method, including：
Present graphical interface, the graphic interface includes the report component that can be dragged and layout panel, for user Target report component is laid on the layout panel；
Operated in response to component Configuration of the user on the graphic interface, obtain the target report component it Between layout information and the target report component related information；
According to the layout information between the target report component and the related information of the target report component, generation Report description (RD) file；
The report description (RD) file is rendered, with output data form.
In A2, the method as described in A1, operated in response to component Configuration of the user on the graphic interface Before, methods described also includes：
Drag operation in response to the user to report component, it is determined that being drawn to by the user on the layout panel Report component, as the target report component.
In A3, the method as described in A1, operate, obtain in response to component Configuration of the user on the graphic interface The related information of the layout information and the target report component between the target report component is taken, including：
Operated in response to the component edits of the user, edit the related information of the target report component；
Operated in response to the distributing adjustment of the user, adjust the layout between the target report component；
Operation is submitted in configuration in response to the user, obtains the layout information between the target report component and institute State the related information of target report component.
In A4, the method as described in A3, editor's entrance of the target report component is included on the graphic interface；
Operated in response to the component edits of the user, edit the related information of the target report component, including：
Trigger action in response to the user to editor's entrance, the target report component is shown to the user Corresponding information editing's page；
In response to edit operation of the user on described information edit page, the target that the user is inputted The data query sentence and/or style information of report component, the related information as the target report component.
In A5, the method as described in A3, operated in response to the distributing adjustment of the user, adjust the target report component Between layout, including：
In response to dragging of the user to the target report component and/or zoom operations, the target form is adjusted The position of component and/or size.
In A6, the method as described in any one of A1-A5, according to the layout information between the target report component and institute The related information of target report component is stated, generates report description (RD) file, including：
Request or form preview request are sent in response to the form of the user, is obtained between the target report component The related information of layout information and the target report component；
HTML is done to the related information of the layout information between the target report component and the target report component Label mapping, to generate the report description (RD) file of html format.
In A7, the method as described in A6, layout information and the target between the target report component is obtained Before the related information of report component, methods described also includes：
In a manner of structured storage, the layout information between the target report component and the target form group are stored The related information of part.
In A8, the method as described in A7, in a manner of structured storage, the layout letter between the target report component is stored The related information of breath and the target report component, including：
The related information of the target report component is stored to the component table of the structuring into the relevant database；
Layout information between the target report component is stored into relevant database in the layout table of structuring.
In A9, the method as described in A8, request or form preview request are sent in response to the form of the user, obtains institute The related information of the layout information and the target report component between target report component is stated, including：
Request or form preview request are sent in response to the form of the user, from the layout table and the component table The related information of the layout information and the target report component between the target report component is read respectively.
In A10, the method as described in A9, the layout information between the target report component is stored to relational data In storehouse in the layout table of structuring, including：
Layout information between the target report component is disassembled as Report layouts ID, the target report component ID, the position of the target report component and size, it is corresponding to store into the layout table；
The related information of the target report component is stored to the component table of the structuring into the relevant database, wrapped Include：
The related information of the target report component is disassembled into the ID of the target report component, the target form group The attribute and property value of part, corresponding storage is into the component table.
In A11, the method as described in A10, the form, which sends request or form preview request, includes the target form The Report layouts ID that layout information between component is disassembled out；
Read respectively from the layout table and the component table layout information between the target report component and The related information of the target report component, including：
The Report layouts ID of request or the carrying of form preview request is sent according to the form, is read from the layout table The position and size of the ID of the target report component and the target report component；
According to the ID of the target report component, read from the component table target report component attribute and Property value.
In A12, the method as described in A11, to the layout information between the target report component and the target report The related information of table component does html tag mapping, to generate the report description (RD) file of html format, including：
The report component that the ID of the target report component is identified, it is defined as the report description (RD) file of the html format In html tag；
By the attribute and property value of the target report component, the content and/or pattern of the html tag are mapped as；
By the position of the target report component and size, the attribute of the html tag, the attribute instruction are mapped as The html tag corresponds to position and the size of HTML unit lattice.
In A13, the method as described in A12, the attribute and category of the target report component will be read in the component table Property value, the content and/or pattern of the html tag are mapped as, including：
If the attribute of the target report component includes data attribute, the data query sentence as property value is inquired Result data fill the position of the content of the html tag defined in report description (RD) file to the html format；
If the attribute of the target report component includes Style Attributes, the style information as property value is filled to described The position of the pattern of the html tag defined in the report description (RD) file of html format.
In A14, the method as described in A10, in response to the user form send request or form preview request it Before, methods described also includes：
In response to the component preview operation of the user, analog storage treats layout letter corresponding to the target report component of preview Breath, to treat Report layouts ID corresponding to the target report component of preview described in acquisition；
According to Report layouts ID corresponding to the target report component for treating preview, the target form of preview is treated described in acquisition The related information of layout information corresponding to component and the target report component for treating preview；
According to layout information corresponding to the target report component for treating preview and the target form group for treating preview The related information of part, formation component describe file；
File is described to the component to render, to export the component level for including the target report component for treating preview Data sheet.
In A15, the method as described in A14, in response to the component preview operation of the user, analog storage treats the mesh of preview Layout information corresponding to report component is marked, to treat Report layouts ID corresponding to the target report component of preview described in acquisition, including：
User terminal where receiving the graphic interface is constructed and sent for the target report component for treating preview Layout information；
Layout information corresponding to the target report component for treating preview is disassembled as Report layouts ID, described treats preview The ID of target report component, the position of the target report component for treating preview and size, it is corresponding to store into the layout table.
In A16, the method as described in A15, according to Report layouts ID corresponding to the target report component for treating preview, obtain Take the association letter for treating layout information corresponding to the target report component of preview and the target report component for treating preview Breath, including：
Receive the component preview request that the user terminal is sent, the component preview request, which carries, described treats preview The Report layouts ID that layout information corresponding to target report component is disassembled out；
The Report layouts ID carried according to the component preview request, the mesh of preview is treated described in reading from the layout table Mark the ID of report component, the position of the target report component for treating preview and size；
According to the ID of the target report component for treating preview, read from the component table described in treat the target report of preview The attribute and property value of table component；
According to layout information corresponding to the target report component for treating preview and the target form group for treating preview The related information of part, formation component describe file, including：
According to the position of the target report component for treating preview and size and the target report component for treating preview Attribute and property value, formation component describes file.
B17, a kind of data sheet processing unit is also disclosed in the embodiment of the present application, including：
Display module, for present graphical interface, the graphic interface includes report component and the layout that can be dragged Panel, so that user lays target report component on the layout panel；
Acquisition module, for being operated in response to component Configuration of the user on the graphic interface, described in acquisition The related information of layout information and the target report component between target report component；
Generation module, for according to the layout information between the target report component and the target report component Related information, generate report description (RD) file；
Rendering module, for being rendered to the report description (RD) file, with output data form.
B18, the device as described in B17 also include：
Determining module, for the drag operation in response to the user to report component, it is determined that being drawn to by the user Report component on the layout panel, as the target report component.
In B19, the device as described in B17, the acquisition module is specifically used for：
Operated in response to the component edits of the user, edit the related information of the target report component；
Operated in response to the distributing adjustment of the user, adjust the layout between the target report component；
Operation is submitted in configuration in response to the user, obtains the layout information between the target report component and institute State the related information of target report component.
In B20, the device as described in B19, editor's entrance of the target report component is included on the graphic interface；
The acquisition module is specifically used for：Trigger action in response to the user to editor's entrance, to the use Family shows information editing's page corresponding to the target report component；And in response to the user in described information edit page On edit operation, the data query sentence and/or style information of the target report component that the user is inputted, as The related information of the target report component.
In B21, the device as described in B19, the acquisition module is specifically used for：
In response to dragging of the user to the target report component and/or zoom operations, the target form is adjusted The position of component and/or size.
In B22, the device as described in any one of B17-B21, the generation module is specifically used for：
Request or form preview request are sent in response to the form of the user, is obtained between the target report component The related information of layout information and the target report component；
HTML is done to the related information of the layout information between the target report component and the target report component Label mapping, to generate the report description (RD) file of html format.
B23, the device as described in B22 also include：
Memory module, in a manner of structured storage, store layout information between the target report component and The related information of the target report component.
In B24, the device as described in B23, the memory module is specifically used for：
The related information of the target report component is stored to the component table of the structuring into the relevant database；
Layout information between the target report component is stored into relevant database in the layout table of structuring.
In B25, the device as described in B24, layout letter of the generation module between the target report component is obtained During the related information of breath and the target report component, it is specifically used for：
Request or form preview request are sent in response to the form of the user, from the layout table and the component table The related information of the layout information and the target report component between the target report component is read respectively.
In B26, the device as described in B25, the memory module is specifically used for：
Layout information between the target report component is disassembled as Report layouts ID, the target report component ID, the position of the target report component and size, it is corresponding to store into the layout table；
The related information of the target report component is disassembled into the ID of the target report component, the target form group The attribute and property value of part, corresponding storage is into the component table.
In B27, the device as described in B26, the form, which sends request or form preview request, includes the target form The Report layouts ID that layout information between component is disassembled out；
The generation module between the target report component is read respectively from the layout table and the component table Layout information and the target report component related information when, be specifically used for：
The Report layouts ID of request or the carrying of form preview request is sent according to the form, is read from the layout table The position and size of the ID of the target report component and the target report component；
According to the ID of the target report component, read from the component table target report component attribute and Property value.
In B28, the device as described in B27, the generation module is to the layout information between the target report component And the related information of the target report component is specifically used for when doing html tag mapping：
The report component that the ID of the target report component is identified, it is defined as the report description (RD) file of the html format In html tag；
By the attribute and property value of the target report component, the content and/or pattern of the html tag are mapped as；
By the position of the target report component and size, the attribute of the html tag, the attribute instruction are mapped as The html tag corresponds to position and the size of HTML unit lattice.
In B29, the device as described in B28, the generation module will read the target form group in the component table The attribute and property value of part, when being mapped as the content and/or pattern of the html tag, it is specifically used for：
If the attribute of the target report component includes data attribute, the data query sentence as property value is inquired Result data fill the position of the content of the html tag defined in report description (RD) file to the html format；
If the attribute of the target report component includes Style Attributes, the style information as property value is filled to described The position of the pattern of the html tag defined in the report description (RD) file of html format.
B30, the device as described in B26 also include：
Component storage module, for the component preview operation in response to the user, analog storage treats the target report of preview Layout information corresponding to table component, to treat Report layouts ID corresponding to the target report component of preview described in acquisition；
The acquisition module is additionally operable to：According to Report layouts ID corresponding to the target report component for treating preview, obtain The related information of layout information and the target report component for treating preview corresponding to the target report component for treating preview；
The generation module is additionally operable to：According to layout information corresponding to the target report component for treating preview and described The related information of the target report component of preview is treated, formation component describes file；
The rendering module is additionally operable to：File is described to the component to render, and preview is treated comprising described with output The component level data sheet of target report component.
In B31, the device as described in B30, the component storage module is specifically used for：
User terminal where receiving the graphic interface is constructed and sent for the target report component for treating preview Layout information；
Layout information corresponding to the target report component for treating preview is disassembled as Report layouts ID, described treats preview The ID of target report component, the position of the target report component for treating preview and size, it is corresponding to store into the layout table.
In B32, the device as described in B31, the acquisition module is for obtaining the target report component for treating preview Corresponding layout information and described when the related information of the target report component of preview, is specifically used for：
Receive the component preview request that the user terminal is sent, the component preview request, which carries, described treats preview The Report layouts ID that layout information corresponding to target report component is disassembled out；
The Report layouts ID carried according to the component preview request, the mesh of preview is treated described in reading from the layout table Mark the ID of report component, the position of the target report component for treating preview and size；
According to the ID of the target report component for treating preview, read from the component table described in treat the target report of preview The attribute and property value of table component；
The generation module is specifically used for when formation component describes file：
According to the position of the target report component for treating preview and size and the target report component for treating preview Attribute and property value, formation component describes file.
The embodiment of the present application is also disclosed at C33, a kind of electronic equipment, including one or more memories and one or more Manage device；One or more of memories are used to store one or more computer instruction, and one or more computer refers to Make the step that can be realized during one or more of computing devices in any one of above-mentioned A1-A16 methods described.
D34, a kind of computer-readable recording medium for being stored with computer program, the meter is also disclosed in the embodiment of the present application Calculation machine program can realize the step in any one of above-mentioned A1-A16 methods described when being computer-executed.

Claims (10)

  1. A kind of 1. data sheet processing method, it is characterised in that including：
    Present graphical interface, the graphic interface includes the report component that can be dragged and layout panel, so that user is in institute State and lay target report component on layout panel；
    Operate, obtained between the target report component in response to component Configuration of the user on the graphic interface The related information of layout information and the target report component；
    According to the layout information between the target report component and the related information of the target report component, form is generated File is described；
    The report description (RD) file is rendered, with output data form.
  2. 2. according to the method for claim 1, it is characterised in that according to the layout information between the target report component with And the related information of the target report component, report description (RD) file is generated, including：
    Request or form preview request are sent in response to the form of the user, obtains the layout between the target report component The related information of information and the target report component；
    Html tag is done to the related information of the layout information between the target report component and the target report component Mapping, to generate the report description (RD) file of html format.
  3. 3. according to the method for claim 2, it is characterised in that the layout information between the target report component is obtained And before the related information of the target report component, methods described also includes：
    In a manner of structured storage, layout information between the target report component and the target report component are stored Related information.
  4. 4. according to the method for claim 3, it is characterised in that in a manner of structured storage, store the target form group The related information of layout information and the target report component between part, including：
    The related information of the target report component is stored to the component table of the structuring into the relevant database；
    Layout information between the target report component is stored into relevant database in the layout table of structuring.
  5. 5. according to the method for claim 4, it is characterised in that send request in response to the form of the user or form is pre- Look at request, obtain the related information of the layout information and the target report component between the target report component, including：
    Request or form preview request are sent in response to the form of the user, from the layout table and the component table respectively Read the related information of the layout information and the target report component between the target report component.
  6. 6. according to the method for claim 5, it is characterised in that store the layout information between the target report component Into relevant database in the layout table of structuring, including：
    Layout information between the target report component is disassembled as Report layouts ID, the ID of the target report component, institute Position and the size of target report component are stated, it is corresponding to store into the layout table；
    The related information of the target report component is stored to the component table of the structuring into the relevant database, including：
    The related information of the target report component is disassembled into the ID of the target report component, the target report component Attribute and property value, corresponding storage is into the component table.
  7. 7. according to the method for claim 6, it is characterised in that the form, which sends request or form preview request, includes institute State the Report layouts ID that the layout information between target report component is disassembled out；
    Read layout information between the target report component and described respectively from the layout table and the component table The related information of target report component, including：
    The Report layouts ID of request or the carrying of form preview request is sent according to the form, from the layout table described in reading The position and size of the ID of target report component and the target report component；
    According to the ID of the target report component, the attribute and attribute of the target report component are read from the component table Value.
  8. 8. according to the method for claim 6, it is characterised in that send request or form in the form in response to the user Before preview request, methods described also includes：
    In response to the component preview operation of the user, analog storage treats layout information corresponding to the target report component of preview, To treat Report layouts ID corresponding to the target report component of preview described in acquisition；
    According to Report layouts ID corresponding to the target report component for treating preview, the target report component of preview is treated described in acquisition The related information of corresponding layout information and the target report component for treating preview；
    According to layout information corresponding to the target report component for treating preview and the target report component for treating preview Related information, formation component describe file；
    File is described to the component to render, to export the component DBMS for including the target report component for treating preview Form.
  9. 9. according to the method for claim 8, it is characterised in that in response to the component preview operation of the user, simulation is deposited Layout information corresponding to the target report component of preview is treated in storage, to treat form corresponding to the target report component of preview described in acquisition ID is laid out, including：
    User terminal where receiving the graphic interface treats the layout that the target report component of preview is constructed and sent to be described Information；
    Layout information corresponding to the target report component for treating preview is disassembled as Report layouts ID, the target for treating preview The ID of report component, the position of the target report component for treating preview and size, it is corresponding to store into the layout table.
  10. A kind of 10. data sheet processing unit, it is characterised in that including：
    Display module, for present graphical interface, the graphic interface includes the report component that can be dragged and layout panel, So that user lays target report component on the layout panel；
    Acquisition module, for being operated in response to component Configuration of the user on the graphic interface, obtain the target The related information of layout information and the target report component between report component；
    Generation module, for the association according to the layout information between the target report component and the target report component Information, generate report description (RD) file；
    Rendering module, for being rendered to the report description (RD) file, with output data form.
CN201710428838.4A 2017-06-08 2017-06-08 Data sheet processing method and processing device Pending CN107491427A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710428838.4A CN107491427A (en) 2017-06-08 2017-06-08 Data sheet processing method and processing device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710428838.4A CN107491427A (en) 2017-06-08 2017-06-08 Data sheet processing method and processing device

Publications (1)

Publication Number Publication Date
CN107491427A true CN107491427A (en) 2017-12-19

Family

ID=60643341

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710428838.4A Pending CN107491427A (en) 2017-06-08 2017-06-08 Data sheet processing method and processing device

Country Status (1)

Country Link
CN (1) CN107491427A (en)

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108052676A (en) * 2017-12-28 2018-05-18 广东金赋科技股份有限公司 The collocation method and device of multi-data source data
CN108062298A (en) * 2018-01-02 2018-05-22 武汉斗鱼网络科技有限公司 Chart data generation method, device and readable storage medium storing program for executing
CN109145278A (en) * 2018-09-10 2019-01-04 深圳市泰洲科技有限公司 Report form generation method, device, computer equipment and storage medium
CN109783184A (en) * 2019-04-15 2019-05-21 南京孜博汇信息科技有限公司 User's customizing form generation method
CN110287472A (en) * 2019-06-28 2019-09-27 湖南御家科技有限公司 Report configuration method, system, equipment and computer readable storage medium
CN110941657A (en) * 2019-11-08 2020-03-31 支付宝(杭州)信息技术有限公司 Service data processing method and device
CN111476010A (en) * 2020-04-03 2020-07-31 智业软件股份有限公司 High-flexibility report method and system
CN112199928A (en) * 2020-10-16 2021-01-08 深圳无域科技技术有限公司 Report system based on machine learning and report generation method
CN112530026A (en) * 2019-09-17 2021-03-19 北京国双科技有限公司 Association method and device of components
CN112686017A (en) * 2020-12-29 2021-04-20 深圳前海微众银行股份有限公司 Mail report management method, system, device and computer storage medium
CN113138760A (en) * 2021-04-29 2021-07-20 北京百度网讯科技有限公司 Page generation method and device, electronic equipment and medium
CN113703886A (en) * 2021-07-21 2021-11-26 青岛海尔科技有限公司 User system behavior monitoring method, system, electronic equipment and storage medium
WO2022134115A1 (en) * 2020-12-26 2022-06-30 京东方科技集团股份有限公司 Data processing apparatus, method, and electrode device
CN116383544A (en) * 2023-06-05 2023-07-04 北京拓普丰联信息科技股份有限公司 Webpage report generation method, device, equipment and medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090070667A1 (en) * 2003-09-15 2009-03-12 Pic Web Services, Inc. Computer systems and methods for platform independent presentation design
CN101620591A (en) * 2009-08-12 2010-01-06 国网电力科学研究院 Method for designing module report form layout based on cell mode
CN104281447A (en) * 2014-09-01 2015-01-14 国家电网公司 Report form fast generating and issuing system and method
CN104636393A (en) * 2013-11-13 2015-05-20 航天信息股份有限公司 Self-adaptation report form establishing method based on user self-definition behavior analysis
CN106528514A (en) * 2016-10-31 2017-03-22 山东鲁能软件技术有限公司 Report generation system and method

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090070667A1 (en) * 2003-09-15 2009-03-12 Pic Web Services, Inc. Computer systems and methods for platform independent presentation design
CN101620591A (en) * 2009-08-12 2010-01-06 国网电力科学研究院 Method for designing module report form layout based on cell mode
CN104636393A (en) * 2013-11-13 2015-05-20 航天信息股份有限公司 Self-adaptation report form establishing method based on user self-definition behavior analysis
CN104281447A (en) * 2014-09-01 2015-01-14 国家电网公司 Report form fast generating and issuing system and method
CN106528514A (en) * 2016-10-31 2017-03-22 山东鲁能软件技术有限公司 Report generation system and method

Cited By (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108052676B (en) * 2017-12-28 2021-06-18 广东金赋科技股份有限公司 Configuration method and device for data of multiple data sources
CN108052676A (en) * 2017-12-28 2018-05-18 广东金赋科技股份有限公司 The collocation method and device of multi-data source data
CN108062298A (en) * 2018-01-02 2018-05-22 武汉斗鱼网络科技有限公司 Chart data generation method, device and readable storage medium storing program for executing
CN109145278A (en) * 2018-09-10 2019-01-04 深圳市泰洲科技有限公司 Report form generation method, device, computer equipment and storage medium
CN109783184A (en) * 2019-04-15 2019-05-21 南京孜博汇信息科技有限公司 User's customizing form generation method
CN109783184B (en) * 2019-04-15 2019-07-19 南京孜博汇信息科技有限公司 User's customizing form generation method
CN110287472B (en) * 2019-06-28 2022-12-09 湖南水羊科技有限公司 Report configuration method, system, equipment and computer readable storage medium
CN110287472A (en) * 2019-06-28 2019-09-27 湖南御家科技有限公司 Report configuration method, system, equipment and computer readable storage medium
CN112530026A (en) * 2019-09-17 2021-03-19 北京国双科技有限公司 Association method and device of components
CN110941657A (en) * 2019-11-08 2020-03-31 支付宝(杭州)信息技术有限公司 Service data processing method and device
CN110941657B (en) * 2019-11-08 2023-03-31 支付宝(杭州)信息技术有限公司 Service data processing method and device
CN111476010A (en) * 2020-04-03 2020-07-31 智业软件股份有限公司 High-flexibility report method and system
CN112199928A (en) * 2020-10-16 2021-01-08 深圳无域科技技术有限公司 Report system based on machine learning and report generation method
US11908049B2 (en) 2020-12-26 2024-02-20 Beijing Zhongxiangying Technology Co., Ltd. Data processing device and method, electronic apparatus for data visualization
WO2022134115A1 (en) * 2020-12-26 2022-06-30 京东方科技集团股份有限公司 Data processing apparatus, method, and electrode device
CN112686017A (en) * 2020-12-29 2021-04-20 深圳前海微众银行股份有限公司 Mail report management method, system, device and computer storage medium
CN113138760A (en) * 2021-04-29 2021-07-20 北京百度网讯科技有限公司 Page generation method and device, electronic equipment and medium
CN113138760B (en) * 2021-04-29 2024-03-12 北京百度网讯科技有限公司 Page generation method and device, electronic equipment and medium
CN113703886A (en) * 2021-07-21 2021-11-26 青岛海尔科技有限公司 User system behavior monitoring method, system, electronic equipment and storage medium
CN113703886B (en) * 2021-07-21 2023-06-20 青岛海尔科技有限公司 User system behavior monitoring method, system, electronic equipment and storage medium
CN116383544A (en) * 2023-06-05 2023-07-04 北京拓普丰联信息科技股份有限公司 Webpage report generation method, device, equipment and medium
CN116383544B (en) * 2023-06-05 2023-08-25 北京拓普丰联信息科技股份有限公司 Webpage report generation method, device, equipment and medium

Similar Documents

Publication Publication Date Title
CN107491427A (en) Data sheet processing method and processing device
US11640492B2 (en) System and method providing responsive editing and viewing, integrating hierarchical fluid components and dynamic layout
CN112506493B (en) Table configuration method, device, equipment and medium based on vue
US10997217B1 (en) Systems and methods for visualizing object models of database tables
WO2018205869A1 (en) Form self-defined method and device
US20220229976A1 (en) Infinite Canvas
CN111475163A (en) Method, device and equipment for generating code file of view template and storage medium
CN116225429A (en) Pulling type component frame-based ipage webpage type low-code development platform
CN107391467A (en) Report component layout information processing method and processing device
US20090282325A1 (en) Sparklines in the grid
JP2005531083A (en) Prototyping a graphical user interface
CN109933311A (en) A kind of information system creation method and relevant apparatus
US20140317563A1 (en) Generate field mapping
US20120011447A1 (en) Facilitating propagation of user interface patterns or themes
CN114035773A (en) Configuration-based low-code form development method, system and device
US20100057764A1 (en) Building custom dimension trees
KR101798149B1 (en) Chart visualization method by selecting some areas of the data table
CN112639791A (en) Multi-view master for graphic design
US11227105B1 (en) Method and apparatus for structured documents
US11556702B2 (en) Orchestration of crud operations for a hierarchical web service data model in a spreadsheet
US11475052B1 (en) Using visual cues to validate object models of database tables
KR20210122311A (en) Reversible data transformation
US20160314502A1 (en) System and method for streamlining the design and development process of multiple advertising units
CN108958611B (en) Information editing method and device
CN103309648A (en) System and method for making software in patterned way

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information

Address after: Building N3, building 12, No. 27, Chengzhong Road, Jiancai, Haidian District, Beijing 100096

Applicant after: Beijing Xingxuan Technology Co.,Ltd.

Address before: Room 202, 2 floors, 1-3 floors, No. 11 Shangdi Information Road, Haidian District, Beijing 100085

Applicant before: Beijing Xiaodu Information Technology Co.,Ltd.

CB02 Change of applicant information
RJ01 Rejection of invention patent application after publication

Application publication date: 20171219

RJ01 Rejection of invention patent application after publication