CN107491427A - Data sheet processing method and processing device - Google Patents
Data sheet processing method and processing device Download PDFInfo
- 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
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
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)
- 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. 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. 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. 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. 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. 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. 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. 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. 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.
- 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.
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)
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)
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 |
-
2017
- 2017-06-08 CN CN201710428838.4A patent/CN107491427A/en active Pending
Patent Citations (5)
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)
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 |