CN112036118B - Configurable data report dynamic display method and system - Google Patents
Configurable data report dynamic display method and system Download PDFInfo
- Publication number
- CN112036118B CN112036118B CN202010630267.4A CN202010630267A CN112036118B CN 112036118 B CN112036118 B CN 112036118B CN 202010630267 A CN202010630267 A CN 202010630267A CN 112036118 B CN112036118 B CN 112036118B
- Authority
- CN
- China
- Prior art keywords
- data
- report
- data report
- cell
- change
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 38
- 230000008859 change Effects 0.000 claims abstract description 108
- 238000012545 processing Methods 0.000 claims abstract description 26
- 238000011049 filling Methods 0.000 claims abstract description 8
- 230000006870 function Effects 0.000 claims description 119
- 238000011068 loading method Methods 0.000 claims description 13
- 239000011159 matrix material Substances 0.000 claims description 12
- 230000008569 process Effects 0.000 claims description 8
- 238000001914 filtration Methods 0.000 claims description 4
- 238000004321 preservation Methods 0.000 claims description 4
- 238000007792 addition Methods 0.000 description 2
- 230000001351 cycling effect Effects 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000009191 jumping Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/106—Display of layout of documents; Previewing
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Digital Computer Display Output (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a configurable dynamic data report presentation method and a configurable dynamic data report presentation system, which belong to the field of computer system data processing and solve the technical problems of flexible configuration of a data report presentation mode by a user, flexible storage of presented data and convenience in data acquisition. The method comprises the following steps: configuring basic elements and a data report form display mode; constructing a data set according to the configured basic elements; carrying out change processing on the data report form according to the configured basic elements and the configured data report form display mode, and filling the data to be displayed into the changed data report form; and storing each piece of data after presentation and the corresponding data position information as one piece of data. The system comprises a background configuration module, a report analysis module, a storage analysis module and a database.
Description
Technical Field
The invention belongs to the field of computer system data processing, in particular to a configurable dynamic data report presentation method and a system thereof
Background
In the current enterprise-level application, data is dominant, but a common list and form is difficult to complete a large data volume of presentation work, so that a data report form is needed to complete the work.
When the common data report displays data, the selected data report is a fixed header, namely the number of data columns displayed in the data report is preset, so that dynamic expansion of rows and columns in the data report cannot be realized in a configuration mode. And the common data report forms have certain difficulty in storing data, often the data report forms and the data are stored together, and the data cannot be extracted and used independently.
Based on the problems, how to realize the flexible construction of the display mode of the data report by the user in a configuration mode, and the flexible storage of the data after the display of the data is completed, thereby being convenient for the extraction and the utilization of the data and being the technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a configurable dynamic data report display method and a system aiming at the defects, so as to solve the problems of how to realize flexible configuration of a data report display mode by a user, how to flexibly store the displayed data and convenient data acquisition.
The technical scheme adopted for solving the technical problems is as follows:
a configurable data report dynamic display method comprises the following steps:
configuring basic elements and a data report display mode, wherein the display mode of data can be controlled by configuring the basic elements, the display mode of the data comprises data display rules, data classification and data position information, and the display mode of the data report can be configured to control the type of an expansion area in the data report, wherein the type of the expansion area in the data report comprises a change cell, a line change cell, a column change cell and a fixed cell;
Constructing a data set according to the configured basic elements, wherein the data set comprises data to be displayed;
carrying out change processing on the data report form according to the configured basic elements and the configured data report form display mode, and filling the data to be displayed into the changed data report form;
and storing each piece of data after presentation and the corresponding data position information as one piece of data.
Further, the base elements include:
the module is used for dividing function frameworks, data objects, parameter objects and coding objects of different categories;
the function frame is used for identifying the names of the data access tables, the association relation among the data access table names is configurable, and the function frame belongs to a certain template;
the data object is used for identifying the name of a fetch field and the data type in the data table, the data object belongs to a certain function frame, and each function frame can define a plurality of data objects;
the parameter object is used as a filtering condition when a user acquires data, the parameter object belongs to a certain function frame, and each function frame can define a pair of parameter objects;
and the coding object is used as a grouping condition when a user groups or groups the data, the coding object belongs to a certain function framework, and one function framework can define a plurality of coding objects.
Further, the configuring the base element is preceded by setting a configurable base element, including:
creating a basic element information table, wherein the basic element information table comprises a module information table, a function frame table, a data object table, a parameter object table and a data list object table;
and creating a flexible function, wherein the data information corresponding to the basic element information table is stored in the object information of the flexible function in a key value pair mode, and the flexible function can be loaded by a data display configuration interface.
Further, configuring the basic elements and configuring the display mode of the data report, including:
loading flexible functions on a data display configuration interface, acquiring basic elements, configuring the basic elements according to configuration rules to generate a data result set, wherein each unit of the data result set is marked with data display rules, data classification and data position information corresponding to data to be displayed, and the configuration rules can form an access SQL statement for acquiring and formatting the data to be displayed;
traversing the data result set, and splitting the data result set into data matrixes;
configuring a display mode of a data report, wherein the display mode comprises configuration of a variation attribute of the data report, the variation attribute of the data report comprises a fixed table and a variation table, the data report with variation attribute of the variation table is a variation data report, configuration of a regional variation attribute of the variation data report, the regional variation attribute of the variation data report comprises a fixed region and an expansion region, configuration of an expansion region type of the expansion region, and the expansion region type of the variation data report comprises variation cells, line variation, column variation and fixed cells;
The formula type attribute of the data report cell is configured, an analysis formula is configured for the data report cell with the formula type attribute being an analysis formula, the analysis formula comprises a data matrix in a JSON format, a number-taking SQL statement and a display mode of the configured data report corresponding to the data report cell, and the analysis formula can be loaded by a data report foreground.
Further, the method for changing the data report table according to the configured basic element and the configured data report table display mode and filling the data to be displayed into the changed data report table comprises the following steps:
analyzing a data display mode of data to be displayed, generating a data result set, storing the data result set according to the change type of a corresponding data report cell, storing the data result set as data information if the data report cell is a fixed cell, and storing the data result set as change data information if the data report cell is a fixed cell;
judging the variation attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variation table, deleting the extension row and the extension column of the data report;
Judging the change type of the data report cell, inserting the data to be displayed into the corresponding data report cell according to the data information if the data report cell is a fixed cell, carrying out change processing on the data report cell according to the change data information if the data report cell is a change cell, and inserting the data to be displayed into the corresponding data report cell after the change processing.
Further, the method for performing change processing on the data report cell according to the change data information and inserting the data to be displayed into the corresponding data report cell after the change processing includes:
initializing a change area in a corresponding data report;
performing row and column expansion on the data report cells serving as the change cells;
changing the row coordinate rule name of the data report unit lattice and the row coordinate rule name of the change area in the data report;
circulating the data report cell and inserting the data to be displayed into the corresponding data report cell;
storing the change data information and the format information into data information;
merging the data report cells;
the editable state of all data report cells in the data report is modified.
Further, before carrying out change processing on the data report table according to the configured basic elements and the configured data report table display mode and filling the data to be displayed into the changed data report table, configuring a data report foreground, including:
configuring a background object, wherein the background object comprises a format preservation object, a change data list, an analysis formula list, a data object and a macro function, the format preservation object is used for storing format information, the change data list is used for storing change data information, and the analysis formula list is used for storing an analysis formula;
the configured data report foreground can acquire and display background data, wherein the background data comprises data to be displayed and an analysis formula.
Further, the configuration data report foreground further includes:
setting a form calculation mode of the data report, wherein the form calculation mode of the data report comprises single form calculation and list sleeve calculation, if the form calculation mode of the data report is single form calculation, executing the single form calculation, and if the form calculation mode of the data report is list sleeve calculation, circulating the data report and respectively executing the single form calculation on each data report form;
correspondingly, before judging the variation attribute of the data report, judging and selecting the form calculation mode of the data report.
Further, storing each presented data and the data position information corresponding to the presented data as one piece of data, wherein the data to be presented, the report number of the data report corresponding to the presented data and the row and column coordinates of the data report cell corresponding to the presented data are stored as one piece of data in a database.
A configurable data report dynamic presentation system, comprising:
the background configuration module is used for supporting a user to configure basic elements and a data report display mode, forming an analysis formula and analyzing and calculating data to be displayed;
the report analysis module is used for carrying out dynamic change processing on the data report according to the analysis formula and presenting the data to be displayed through the changed data report;
the storage analysis module is used for storing each piece of data after being displayed and the corresponding data position information as one piece of data;
the database is used for storing background data, and the background data comprises, but is not limited to, data to be displayed, analysis formulas and data generated by the storage analysis module.
Compared with the prior art, the configurable dynamic data report display method and system have the following beneficial effects:
1. The display mode of the data is controlled by the configuration elements, and the display mode of the data report can be configured, so that the unit cells in the data report can be dynamically expanded flexibly, and the data can be displayed in a mode which is hoped by a user;
2. after the data is displayed, the data and the data position information thereof are stored as a piece of data, and the data is not bound with the currently displayed data report, so that the user can flexibly process the data.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart diagram of a method for dynamic display of a configurable data report of embodiment 1;
FIG. 2 is a basic element configuration interface of a data display configuration interface in a configurable data report dynamic display method of embodiment 1;
FIG. 3 is a diagram of a data object configuration interface of FIG. 2;
fig. 4 is a conditional configuration interface of fig. 2.
Detailed Description
The invention further provides a configurable data report dynamic display method and a configurable data report dynamic display system by combining the attached drawings and the specific embodiments.
Example 1:
1-4, the configurable dynamic data report presentation method of the invention comprises the following steps:
Step S100, setting configurable basic elements, wherein the basic elements comprise modules, function frameworks, data objects, parameter objects and coding objects, and a user can control a data display mode through the configured basic elements so as to realize the configuration of the data display mode by the user.
The module is used for dividing function frameworks, data objects, parameter objects and coding objects of different categories; the function frame is used for identifying the names of the data access tables, the association relation among the data access table names is configurable, and the function frame belongs to a certain template; the data object is used for identifying the name of a fetch field and the data type in the data table, the data object belongs to a certain function frame, and each function frame can define a plurality of data objects; the parameter objects are used as filtering conditions when a user acquires data, the parameter objects belong to a certain function frame, and each function frame can define a pair of parameter objects; and the coding object is used as a grouping condition when a user groups or groups the data, the coding object belongs to a certain function framework, and one function framework can define a plurality of coding objects.
The base element set in step S100 can be loaded and acquired by the data presentation configuration interface, so that a user can acquire the base element and configure the base element, and based on this, setting the configurable base element includes the following procedures:
S101, creating a basic element storage table, wherein the basic element storage table comprises a module element storage table, a function framework storage table, a data object storage table, a parameter object storage table and a data column object storage table.
The structure of the module element storage table is shown in table 1, and the module element storage table can be subjected to operations of addition, deletion, modification and lookup.
Table 1:
the structure of the function frame memory table is shown in table 2, and the function frame memory table can be subjected to the operations of adding, deleting, modifying and searching.
Table 2:
the data object storage table is structured as in table 3, and can be added, deleted, modified and searched.
Table 3:
the structure of the parameter object storage table is shown in table 4, and the parameter object storage table can be subjected to the operations of adding, deleting, modifying and searching.
Table 4:
the structure of the data column object store table is shown in table 5, and the data column object store table can be subjected to addition, deletion, modification and search operations.
Table 5:
s102, creating a flexible function capable of being loaded by the data display configuration interface, wherein the data information corresponding to the basic element storage table is stored in the object information of the flexible function in a key value pair mode.
The object information of the flexible function is mainly divided into four-level structures, wherein a first-level object is a report template object (reportTemplateObj) which is a common object and is not described herein; the secondary object is a flexible function object (LhhsObject); the three-level objects are object lists, including a module list (MKList), a flexible function list (FuncList), a data object list (SjList), a parameter object list (CsList) and a data list object list (SjlList); the four-level objects are object sets and list sets, including a module set (MkCollect), a flexible function set (funccllect), a data object set (SjCollect), a parameter object set (CsCollect), and a data column object set (sjlncollect), and a module list set (mklistccollect), a flexible function list set (funcclouct), a data object list set (sjlistccollect), a parameter object list set (cslistccollect), and a data column object list set (sjlllistccollect).
The secondary object flexible function object LhhsObject is a set object of the outermost layer of the flexible function, a module set, a flexible function set, a data object set, a parameter object set and a data column set related to the flexible function are stored, the secondary set object is stored in the form of KEY VALUE pairs (KEY, VALUE), the KEY is the name of each set object, and the VALUE is the set object.
The three-level object module list MkList encapsulates the four-level object module set MkCollect and the module list set mklistmalect, and stores four-level object information in the form of KEY VALUE pairs (KEYs), which are "MkCollect" and "mklistmalect", respectively, and the VALUE is a four-level object.
The three-level object flexible function list funclst encapsulates a four-level object flexible function set funcllect and a flexible function list set FuncListCollect, and stores four-level object information in the form of KEY VALUE pairs (KEYs, VALUE), wherein KEYs are respectively "funcllect" and "FuncListCollect", and VALUE is a four-level object.
The three-level object data object list SjList encapsulates the four-level object data set SjCollect and the data list set sjlistmalect, and stores the four-level object information in the form of KEY VALUE pairs (KEYs), which are "SjCollect" and "sjlistmalect", respectively, and the VALUE is a four-level object.
The three-level object parameter list CsList encapsulates a four-level object parameter set CsCollect and a parameter list set cslistdollect, and stores four-level object information in the form of KEY VALUE pairs (KEYs), wherein KEYs are respectively "CsCollect" and "cslistdollect", and VALUEs are four-level objects.
The three-level object data column list sjlllist encapsulates a four-level object data column set sjllcollect and a data column list set MkListCollect, and stores four-level object information in the form of KEY-VALUE pairs (KEYs), which are "sjllcollect" and "sjlllistcollect", respectively, and VALUEs which are four-level objects.
The four-level set object module set MkCollect stores all module information corresponding to the data table NFROOMK, and stores the module information in the form of KEY VALUE pairs (KEYs, VALUEs), where KEYs are module numbers, and VALUEs are corresponding module objects.
The four-level set object flexible function set is a function collection, all flexible function information corresponding to the data table NFROOFUNC is stored, the flexible function information is stored in the form of KEY VALUE pairs (KEY, VALUE), the KEY is a character string formed by 'module number-function number', and the VALUE is a corresponding flexible function object.
The data object set sjcollection of the four-level collection object stores all data object information corresponding to the data table NFROOSJDX, and stores the data object information in the form of KEY VALUE pairs (KEYs, VALUEs), wherein KEYs are character strings consisting of module numbers, function numbers and data object numbers, and VALUEs are corresponding data objects.
The method comprises the steps that a four-level set object parameter object set CsCollet stores all parameter object information corresponding to a data table NFROOCS, and stores the parameter object information in a KEY VALUE pair (KEY, VALUE); KEY is a character string consisting of "module number-function number-parameter object number", and VALUE is a corresponding parameter object.
The four-level set object data column object set sjlnlect stores all data column object information corresponding to the data table NFROOSJL, and stores the data column object information in the form of KEY VALUE pairs (KEYs, VALUEs), wherein KEYs are character strings consisting of module numbers, function numbers and data column object numbers, and VALUEs are corresponding data column objects.
The four-level set object flexible function list set is a funclitlollect, stores flexible function lists under each module, and stores the flexible function lists in the form of KEY VALUE pairs (KEYs, VALUEs), wherein KEYs are module numbers, and VALUEs are lists formed by all flexible functions under corresponding modules.
A four-level set object data object list set sjlistmalect, storing the data object list under each module and function, and storing the data object list in the form of KEY VALUE pairs (KEYs, VALUEs); KEY is a string of "module number-function number" and VALUE is a list of all data objects under the corresponding module and function.
The four-level set object parameter object list set CsListCollect stores parameter object lists under each module and function, and stores the parameter object lists in the form of KEY VALUE pairs (KEY, VALUE), wherein KEY is a character string consisting of 'module number-function number', and VALUE is a list consisting of all parameter objects under corresponding modules and functions.
The four-level set object data column object list set sjlllistmalect stores the data column object list under each module and function, and stores the data column object list in the form of KEY VALUE pairs (KEYs, VALUEs). KEY is a string of "module number-function number" and VALUE is a list of all data column objects under the corresponding module and function.
The structure of the second-level object, the third-level object and the fourth-level object is shown in fig. 1, the flexible function object of the second-level object comprises the third-level object, the third-level object comprises a fourth-level object set and a fourth-level object list set, and the fourth-level object stores object information in a key value pair mode.
Step 200, configuring basic elements and a data report display mode, wherein the display mode of data is controlled by configuring the basic elements, the display mode of the data comprises data display rules, data classification and data position information, and the display mode of the data report is configured to control the type of an extended area in the data report, wherein the type of the extended area in the data report comprises a change cell, a line change cell, a column change cell and a fixed cell.
In step S200, the configuration basic elements and the data report display mode are executed on the data display configuration interface, and the steps of configuration basic elements are as follows: the data display configuration interface obtains and presents basic elements through loading flexible functions, a user can flexibly configure the basic elements according to configuration rules to generate a data result set, the data result set comprises a plurality of units, each unit corresponds to data to be displayed, each unit corresponds to data display rules, data classification and data position information of the data to be displayed, the configuration rules form an access SQL statement for obtaining and formatting the data to be displayed, and splitting processing is carried out on the data result set to form a data matrix in a JSON format for conveniently loading and obtaining data information in the data result set.
The method for configuring the display mode of the data report comprises the following steps: the method comprises the steps of configuring a data report, wherein the data report comprises variable attributes of the data report, the variable attributes of the data report comprise a fixed table and a variable table, the data report with variable attributes being the variable table is the variable data report, configuring regional variable attributes of the variable data report, the regional variable attributes of the variable data report comprise a fixed region and an extended region, configuring an extended region type of the extended region, and the extended region type of the variable data report comprises variable cells, line variable cells, column variable cells and fixed cells. The change type of the configured data report comprises a fixed cell and a change cell.
The method comprises the steps of configuring formula type attributes of data report cells, configuring an analysis formula for the data report cells with the formula type attributes being analysis formulas, wherein the analysis formula comprises a data matrix in a JSON format, a number-taking SQL statement, a change attribute of a configured data report and a change type of the configured data report cells, which correspond to the data report cells, and the analysis formula can be loaded by a data report foreground; the data report table can be subjected to change processing through an analysis formula. In conclusion, the dynamic change processing of the data report can be realized.
In this embodiment, a user obtains and configures a base element through a data display configuration interface, configures an analysis formula for a datagram table unit cell, so as to perform a change process on the datagram table through the analysis formula, and configures the base element and configures the analysis formula for the datagram table unit cell, including the following operation flows:
s210, configuring an analysis formula for a datagram table cell, which specifically comprises the following steps:
s211, checking whether the data report cell has a logic of an analysis formula: acquiring formula type attribute of the data report cell, and if the formula type attribute of the data report cell is an analysis formula, correspondingly analyzing the formula in the data report cell;
S212, double-clicking the data report cell under the analysis formula state to check whether an analysis formula is configured in the data report cell, if the analysis formula is configured in the data report cell, acquiring the analysis formula and loading the analysis formula into an analysis formula definition window, and if the analysis formula is not configured in the data report cell, inputting the analysis formula into the data report cell;
s213, selecting the data cells and clicking an analysis formula definition button to check whether an analysis formula is configured in the data report cells, if so, acquiring the analysis formula and loading the analysis formula into an analysis formula definition window, and if not, adding the analysis formula.
S220, configuring an analysis formula definition interface, wherein the analysis formula definition interface is shown in fig. 2, and the specific operation flow is as follows:
s221, when the analysis formula definition interface is configured, the following data are required to be acquired and loaded from the background: custom cover items, macro functions, object information of flexible functions (including all modules, flexible functions, data objects, data column objects, sets of parameter objects and list sets of current unit definitions);
S222, if the analysis formula is configured in the data report cell, acquiring the analysis formula contained in the data report cell, and performing the following operations:
s222-1, acquiring a module defined by an analysis formula, and pointing to a corresponding record in a module list;
the specific operation flow comprises the following steps: acquiring all module information from a module set (MKCollect) of a flexible function object (LhhsObject), and loading the module information into a module selection drop-down box of an interface, such as an area (1) in FIG. 2;
s222-2, acquiring a flexible function corresponding to an analysis formula, pointing to a corresponding record in a flexible function list, acquiring a function description, a fetch table and a default association condition of the flexible function, and displaying the function description, the fetch table and the default association condition in a dialog box;
the specific operation flow comprises the following steps: a first module is selected by default, a flexible function set corresponding to the module is obtained, and the flexible function set is loaded into a flexible function selection drop-down frame of an interface; acquiring function description, a fetch table and default association conditions of the flexible function, and displaying the function description, the fetch table and the default association conditions in a dialog box;
as in region (2) of fig. 2, according to the selected module and flexible function, obtaining a list of data column objects from a set of data column object lists (bmlistlollect) of flexible function objects (LhhsObject); the list of data column objects is cycled to see if there is a "data column name" object (data column number: "0000"), and if not, the object is added to the list. Displaying the list of data column objects in a dialog box, such as region (3) in fig. 2;
S222-3, acquiring a data column object list according to a module and a flexible function corresponding to an analysis formula, then acquiring a data column and a column data column of the analysis formula, circulating the data column object list, removing the data column and the column data column in the analysis formula from the data column object list, and then adding the data column and the column data column into a row list and a column list of a dialog box respectively;
the specific operation flow comprises the following steps:
as in region (3) of fig. 2, there are three lists associated with the data column object in the analytical formula definition interface: a list of data column objects, a list of rows and a list of columns, the data column objects being stored in the list in the form of: storing data column object information, whether data statistics and whether names are displayed or not in a key value pair mode;
when a data column object is added from the data column object list to the row/column list, the object is removed from the data column object list and added to the row/column list. When one data column object is removed from the row/column list, removing the data column object from the row/column list, and adding the object to the data column object list;
s222-4, acquiring data object information of an analysis formula, and loading the data object information into a data object list of a dialog box;
the specific operation flow comprises the following steps:
As in region (4) of fig. 2, the data objects of the analytical formula are shown in the data object list. Clicking the "add" or "edit" button on the left side of the data object list, entering an edit data object interface, as shown in fig. 3;
when entering the editing data object dialog box, according to the selected module and the flexible function, a data object list is obtained from a data object list set (SjListCollect) of a flexible function object (LhhsObject), and is loaded into the data object list in the editing data object dialog box. Loading the data name and the data object of the selected data object into the data name and the data expression of the dialog box respectively;
adding monitoring in a data object list, and respectively adding the data name and the data object of the selected item into a data name and a data expression of a dialog box when the items in the list are double-clicked;
monitoring of a 'determination' button, if yes, forming a data object by the edited data name and the data expression, and adding the data object into a data object list of an analysis formula definition interface; if the editing is performed, acquiring a data object list of an analysis formula definition interface, and changing selected data object information into an edited data name and data expression;
S222-5, acquiring a data column object display format of an analysis formula, and modifying the selected states of display row/column names and display row/column aliases under the data columns of the rows and columns;
s222-6, acquiring the condition of the analysis formula, and displaying the condition in a condition text box of the dialog box;
s222-7, acquiring a condition type of an analysis formula, and pointing to a corresponding record in a drop-down frame on the right side of the data area;
the specific operation flow is as follows:
as in region (5) of fig. 2, when the "guide" button is clicked, a "specified condition parameters" dialog is entered, as shown in fig. 4;
when entering a dialog box of a specified condition parameter under the condition of existing conditions, analyzing the existing condition text, generating a condition list, and loading the condition list into the dialog box;
when clicking the button after the comparison item, entering a dialogue box of 'flexible function condition parameter help', acquiring a parameter object list from a parameter object list set (CsListCollect) of a flexible function object (LhhsObject) according to the selected module and the flexible function, and displaying the parameter object list in the dialogue box for selection;
when clicking the button after the comparison value, entering a dialogue box for inquiring parameter help, acquiring all macro functions, and cover custom items to form a parameter list, and displaying the parameter list for selection in the dialogue box;
When the 'insert row' button is clicked, adding a row in the condition list, and when the 'delete row' button is clicked, deleting the selected row in the condition list;
when clicking the 'check' button, checking whether the assembled condition is legal or not, if not, prompting the reason, and if so, prompting that the check is passed;
when clicking the 'confirm' button, automatically executing 'check' operation, prompting the reason if not legal, generating a condition character string from the assembled condition if legal, and then assigning the character string to a condition text box of an analysis formula definition interface;
s230, generating an analysis formula, wherein the specific operation flow is as follows:
s231, when clicking a 'determination' button of the analysis formula definition interface, generating an analysis formula, and judging as follows:
the row and column data columns must both be defined and if not, prompt "please select row/column-! ";
the data column object "data column name", must be on either the row data column or column data column, if not, suggests that "data column name must be on the row or column-! ";
the data object must have been defined and if not, prompt please select data field-! ";
if a data column object selects ' display statistics row ', but no data object selects ' whether statistics is performed ', prompt ' please select data field to be counted-! ";
If the data object selects ' statistics ' and no data column object selects ' display statistics rows ', prompt ' please select data column field to display statistics rows-! ";
s232, if the judgment is passed, executing a process of storing an analysis formula;
s233, when the analysis formula is stored, the generated analysis formula information is stored in the rpFxgsObj object of the reportTemplateObj, and the specific information is stored in the following format:
module information: the module number selected in the module list;
flexible function information: the flexible function number selected in the flexible function list;
row data column information and column data column information: each data column object is represented by a character string consisting of a "display statistics row" check box, ", data column object number," and "display name" check box, "1" indicating check box check and "0" indicating check box unchecked. For example, "1,1001,0" indicates a data column object whose data column object number is "1001", an execution row is displayed, and a data column name is not displayed. Use among multiple data column objects "; "interval;
data column setting: the check boxes "display row name", "display row alias", "display column name", "display alias" constitute character strings, "1" indicating check, and "0" indicating unchecked. If the "0110" label indicates that the "display row alias" and the "display column name" are selected, the "display row name" and the "display column alias" are not selected;
The data object information is represented by a character string of whether to count a check box, a data object number, a data object result type, a data object name and a data object name combination. "1" indicates check box check, "0" indicates check box unchecked, and the result type "S" indicates a character string, "D" indicates a numerical value. If the score of ' 1$0004$D$represents that the data object number is ' 0004 ', the data is counted, the result type is a numerical value, and the data object name is ' score ';
conditions are as follows: character strings in the conditional dialog;
statistical type: english identification of selected mode in statistical type drop-down box (average: AVG, aggregate: SUM, MAX, MIN, quantity: COUNT, sub-meter: XJ)
S234, the structure of the analysis formula save table is shown in Table 6.
Table 6:
/>
and step S300, constructing a data set according to the configured basic elements, wherein the data set comprises data to be displayed, the data is stored in a database, and the data set can be loaded and acquired by a data report foreground for analyzing and presenting a data report.
Step S400, configuring a data report foreground, wherein the foreground comprises a configuration background object, the configured data report can acquire and display background data, and the background data comprises data to be displayed and an analysis formula. The background object comprises a macro function, an analysis formula list FxgsList, a format object Format SaveObject, a change data list BdzdList and a data object DataSaveObject, wherein the analysis formula list is used for storing an analysis formula, the format storage object is used for storing format information, and the change data list is used for storing change data information.
And S500, carrying out change processing on the data report according to the configured basic elements and the configured data report display mode, and filling the data to be displayed into the changed data report. The method specifically comprises the following operation flows:
step S510, analyzing a data display mode of data to be displayed, generating a data result set, storing the data result set according to the change type of the corresponding data report cell, if the data report cell is a fixed cell, storing the data result set as data information, and if the data report cell is a fixed cell, storing the data result set as change data information;
step S520, judging the variable attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variable table, deleting the extension row and the extension column of the data report;
and step S530, judging the change type of the data report cell, inserting the data to be displayed into the corresponding data report cell according to the data information if the data report cell is a fixed cell, carrying out change processing on the data report table according to the change data information if the data report cell is a change cell, and inserting the data to be displayed into the corresponding data report cell after the change processing.
Step S510 includes the following steps:
s511, loading an analysis formula, and acquiring data to be displayed according to the fetch SQL statement;
s512, creating a temporary data table, and temporarily storing data to be displayed through the temporary data table;
s513, analyzing the analysis formula and acquiring a data matrix in the JSON format;
s514, executing an insert statement;
s515, executing a select statement;
s516, generating a data result set dataMap;
s517, judging the change type of the data report cell corresponding to the analysis formula, if the change type of the data report cell is a fixed cell, storing the data result set dataMap into a data object DataSaveObject, and if the data report cell is a change cell, storing the data result set dataMap into a change data list BdzdList;
s518, deleting the temporary data table;
s519, acquiring and analyzing the data information in the change list and the format object to generate data column information;
s5110, loading the data object to the data report foreground.
In step S530, when the datagram table cell is a change cell, the datagram table is changed according to the change data information, and the data to be displayed is inserted into the corresponding data report after the change process, and the specific operation flow is as follows:
S531, initializing a change area in a corresponding data report;
s532, performing row and column expansion on the data report cell serving as the change cell;
s533, changing the row coordinate rule names of the data report unit cells and the row coordinate rule names of the change areas in the data report;
s534, circulating the data report cell and inserting the data to be displayed into the corresponding data report cell;
s535, storing the change data information and the format information into data information;
s536, merging data report cells;
s537, modifying the editable states of all the data report cells in the data report.
In this embodiment, the specific implementation steps of expanding rows and columns of the variable cells and inserting the data to be displayed into the expanded data report are given when the data report table is in the variable cell format, and the specific flow is as follows:
(1) Pointing to the data report according to the object information of the change data list BdzdList;
(2) Initializing coordinates of a data report variation area;
(3) Cycling each of the varying cells;
(4) Expanding rows and columns of the data report;
(5) Changing the scale names of the extension rows and the extension columns of the data report;
(6) Changing the row and column scale names of the changed data report;
(7) Acquiring data position information of data to be displayed, circulating the data report cells, and inserting the data to be displayed into the corresponding data report cells;
(8) Saving the change data information and the format information into a data object datasaveobject;
(9) Merging data report unit cells;
(10) The editable state of all the data report cells is modified.
Step S600, each presented data and the data position information corresponding to the presented data are stored as one piece of data to form a data table information table, and the structure of the data table information table is shown in table 7.
Table 7:
in step S600, the data to be displayed, the report number of the data report corresponding to the data to be displayed, and the row-column coordinates of the data report cell corresponding to the data to be displayed are stored as one piece of data in the database.
In step S600, when obtaining the data position information, the change type of the data report cell and the change attribute of the data report cell corresponding to the analysis display data are required to be judged and analyzed, and the specific operation flow is as follows:
step (1), circulating a data report;
step (2), cycling the data report unit cells subjected to the change treatment;
step (3), judging the change type of the data report cell, if the change type of the data report cell is a fixed cell, jumping out to execute, and if the change type of the data report cell is a change cell, executing the next step;
Step (4), judging the variable attribute of the data report, if the data report is a variable table, executing step (5), and if the data report is a fixed table, executing step (7);
step (5), judging an expansion area of the data report cell in the data report, if the data report cell is in a variable area in the data report, executing step (10), and if the data report cell is in a non-variable area in the data report, executing step (6);
step (6), acquiring a line scale of the data report cell, re-acquiring a line coordinate, acquiring a column scale of the data report cell, and re-acquiring a column coordinate;
step (7), acquiring row and column coordinates of the data report cells, namely, position coordinate information of the data report cells;
step (8), report data are obtained, wherein the report data comprise the number of a data report, row and column coordinates of data report cells and data to be displayed;
step (9), adding report data into the reportDataRootObject object, and then executing step (11);
step (10), acquiring a reportDataRootObject object, and then executing step (11);
step (11), transmitting the reportdatarootoobject object to a database;
And (12) storing the information in the reportDataRootObject object into an NRPRWBBSJ information table.
Example 2:
this example is a further improvement over example 1, and differs from example 1 in that: when the front data report platform is configured in the execution step S400, a data report computing mode is also configured, wherein the data report computing mode comprises single-table computing and table set computing, when the computing mode of the data report is single-table computing, the single-table computing is executed on the current data report, and when the computing mode of the data report is table set computing, all the data reports are circulated and the single-table computing is executed on each data report respectively.
Accordingly, when executing step S500, it is necessary to determine and select the calculation mode of the data report. The specific step S500 includes the following steps:
step S510, analyzing a data display mode of data to be displayed, generating a data result set, storing the data result set according to the change type of the corresponding data report cell, if the data report cell is a fixed cell, storing the data result set as data information, and if the data report cell is a fixed cell, storing the data result set as change data information;
Step S520, judging and selecting a form calculation mode of the data report;
step S530, judging the variable attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variable table, deleting the extension row and the extension column of the data report;
step S540, judging the change type of the data report cell, if the data report cell is a fixed cell, inserting the data to be displayed into the corresponding data report cell according to the data information, if the data report cell is a change cell, carrying out change processing on the data report cell according to the change data information, and inserting the data to be displayed into the corresponding data report cell after the change processing.
Example 3:
a configurable data report dynamic display system comprises a background configuration module, a report analysis module, a storage analysis module and a database.
The background configuration module is used for supporting a user to configure basic elements and a display mode of the data report, and forming an analysis formula according to the basic elements and the data display mode configured by the user. The background configuration module interacts with a user through a data display configuration interface, the user can select and configure basic elements and a display mode of a data report through the data display configuration interface, the background configuration module analyzes and calculates the configured basic elements and the display mode of the data report through an analysis and calculation unit and generates an analysis formula, and the background configuration module acquires data to be displayed from a database through the analysis and calculation unit and according to the configured basic elements to form a data set.
The background configuration module forms the configuration rules into an access SQL statement through an analysis and calculation unit, and the access SQL statement can be loaded and called by the report analysis module.
When a user configures basic elements through a data display configuration interface, the configured basic elements can be formed into a data result set through an analysis and calculation unit, the data result set is split to form a data matrix, each unit in the formed data matrix comprises data display rules, data classification and data position information corresponding to data to be displayed, and the analysis and calculation unit converts the data matrix into a JSON format data matrix which can be loaded by a report analysis module.
Meanwhile, the analysis and calculation unit of the background configuration module analyzes and processes the configuration rules, the data matrix and the display mode of the configured data report form to form an analysis formula which can be loaded by the report analysis module.
The report analysis module is connected with the database and used for displaying data through the data report.
The report analysis module interacts with the user through the data report foreground, presents the data report through the data report interface in the data report foreground and presents the data through the data report after the change processing.
The report analysis module acquires data to be displayed from the database through the calculation analysis module, analyzes the data to be displayed according to an analysis formula, and generates data information corresponding to the fixed cells and change data information corresponding to the change cells, so that calculation preparation before data report expansion is realized.
The report analysis module acquires an analysis formula, data information and change data information through a data report foreground, expands the data report according to the information and inserts the data to be displayed into the corresponding data report cell after the change processing.
The storage analysis module is connected with the database and used for storing each piece of data after being displayed and the corresponding data position information as one piece of data.
The database is used for storing background data, and the background data comprises data generated by a background analysis module, data generated by a report analysis module and data generated by a storage analysis module, such as a basic element information table, a data set, a data result set, a data matrix, a yarn taking SQL statement, an analysis formula and the like.
The configurable data report dynamic display system disclosed in the embodiment 1 can realize the configurable data report dynamic display method.
Example 4:
this example is a further improvement over example 3, and differs from example 3 in that: the report analysis module has a form calculation function, specifically, a calculation analysis unit of the report analysis calculation module is provided with a form calculation subunit, the form calculation mode of the data report can be judged through the form calculation subunit, and the form calculation mode of the data report is supported to be selected by a user, wherein the form calculation mode of the data report comprises form calculation and form sleeve calculation, the form calculation is to execute the calculation of a single data report, and the form sleeve calculation is to execute the form calculation on all the data reports respectively. Correspondingly, a form selection key is arranged in a data report interface of the data report foreground, and is a single-label calculation key and a list sleeve calculation key respectively, and a user selects single-label calculation by pressing the single-label calculation key and selects list sleeve calculation by pressing the list sleeve calculation key.
The configurable data report dynamic display system of the embodiment can realize the configurable data report dynamic display method disclosed in the embodiment 1 or the embodiment 2.
The present invention can be easily implemented by those skilled in the art through the above specific embodiments. It should be understood that the invention is not limited to the particular embodiments described above. Based on the disclosed embodiments, a person skilled in the art may combine different technical features at will, so as to implement different technical solutions. Other than the technical features described in the specification, all are known to those skilled in the art.
Claims (7)
1. A configurable data report dynamic display method is characterized by comprising the following steps:
configuring basic elements and a data report display mode, wherein the display mode of data can be controlled by configuring the basic elements, the display mode of the data comprises data display rules, data classification and data position information, and the display mode of the data report can be configured to control the type of an expansion area in the data report, wherein the type of the expansion area in the data report comprises a change cell, a line change cell, a column change cell and a fixed cell;
constructing a data set according to the configured basic elements, wherein the data set comprises data to be displayed;
carrying out change processing on the data report form according to the configured basic elements and the configured data report form display mode, and filling the data to be displayed into the changed data report form;
storing each piece of data after presentation and the corresponding data position information as one piece of data;
the basic elements include:
the module is used for dividing function frameworks, data objects, parameter objects and coding objects of different categories;
the function frame is used for identifying the names of the data access tables, the association relation among the data access table names is configurable, and the function frame belongs to a certain template;
The data object is used for identifying the name of a fetch field and the data type in the data table, the data object belongs to a certain function frame, and each function frame can define a plurality of data objects;
the parameter object is used as a filtering condition when a user acquires data, the parameter object belongs to a certain function frame, and each function frame can define a pair of parameter objects;
the coding object is used as a grouping condition when a user groups or groups data, the coding object belongs to a certain function framework, and one function framework can define a plurality of coding objects;
setting the configurable base element before configuring the base element, including:
creating a basic element information table, wherein the basic element information table comprises a module information table, a function frame table, a data object table, a parameter object table and a data list object table;
creating a flexible function, wherein the data information corresponding to the basic element information table is stored in the object information of the flexible function in a key value pair mode, and the flexible function can be loaded by a data display configuration interface;
configuring basic elements and configuring a data report display mode, wherein the method comprises the following steps:
loading flexible functions on a data display configuration interface, acquiring basic elements, configuring the basic elements according to configuration rules to generate a data result set, wherein each unit of the data result set is marked with data display rules, data classification and data position information corresponding to data to be displayed, and the configuration rules can form an access SQL statement for acquiring and formatting the data to be displayed;
Traversing the data result set, and splitting the data result set into data matrixes;
configuring a display mode of a data report, wherein the display mode comprises configuration of a variation attribute of the data report, the variation attribute of the data report comprises a fixed table and a variation table, the data report with variation attribute of the variation table is a variation data report, configuration of a regional variation attribute of the variation data report, the regional variation attribute of the variation data report comprises a fixed region and an expansion region, configuration of an expansion region type of the expansion region, and the expansion region type of the variation data report comprises variation cells, line variation, column variation and fixed cells;
the formula type attribute of the data report cell is configured, an analysis formula is configured for the data report cell with the formula type attribute being an analysis formula, the analysis formula comprises a data matrix in a JSON format, a number-taking SQL statement and a display mode of the configured data report corresponding to the data report cell, and the analysis formula can be loaded by a data report foreground.
2. The method for dynamically displaying a configurable data report according to claim 1, wherein the method for changing the data report according to the configured basic elements and the configured data report display mode and filling the data to be displayed into the changed data report comprises the steps of:
Analyzing a data display mode of data to be displayed, generating a data result set, storing the data result set according to the change type of a corresponding data report cell, storing the data result set as data information if the data report cell is a fixed cell, and storing the data result set as change data information if the data report cell is a fixed cell;
judging the variation attribute of the data report, if the data report is a fixed table, maintaining the state of the data report, and if the data report is a variation table, deleting the extension row and the extension column of the data report;
judging the change type of the data report cell, inserting the data to be displayed into the corresponding data report cell according to the data information if the data report cell is a fixed cell, carrying out change processing on the data report cell according to the change data information if the data report cell is a change cell, and inserting the data to be displayed into the corresponding data report cell after the change processing.
3. The method for dynamically displaying a configurable data report according to claim 2, wherein the step of performing a change process on the data report cells according to the change data information and inserting the data to be displayed into the corresponding data report cells after the change process comprises the steps of:
Initializing a change area in a corresponding data report;
performing row and column expansion on the data report cells serving as the change cells;
changing the row coordinate rule name of the data report unit lattice and the row coordinate rule name of the change area in the data report;
circulating the data report cell and inserting the data to be displayed into the corresponding data report cell;
storing the change data information and the format information as data information;
merging the data report cells;
the editable state of all data report cells in the data report is modified.
4. A method for dynamically displaying a configurable data report according to claim 2 or 3, wherein the step of configuring the foreground of the data report before the step of performing a change process on the data report according to the configured base element and the configured data report displaying mode and filling the data to be displayed into the changed data report comprises the steps of:
configuring a background object, wherein the background object comprises a format preservation object, a change data list, an analysis formula list, a data object and a macro function, the format preservation object is used for storing format information, the change data list is used for storing change data information, and the analysis formula list is used for storing an analysis formula;
The configured data report foreground can acquire and display background data, wherein the background data comprises data to be displayed and an analysis formula.
5. The method for dynamically displaying a configurable data report of claim 4, wherein configuring the data report foreground further comprises:
setting a form calculation mode of the data report, wherein the form calculation mode of the data report comprises single form calculation and list sleeve calculation, if the form calculation mode of the data report is single form calculation, executing the single form calculation, and if the form calculation mode of the data report is list sleeve calculation, circulating the data report and respectively executing the single form calculation on each data report form;
correspondingly, before judging the variation attribute of the data report, judging and selecting the form calculation mode of the data report.
6. The method for dynamically displaying a configurable data report according to claim 5, wherein storing each of the displayed data and the data location information corresponding thereto as a piece of data comprises storing the data to be displayed and the report number of the data report corresponding thereto, and the row and column coordinates of the data report cells corresponding thereto as a piece of data to the database.
7. A configurable data report dynamic presentation system, comprising:
the background configuration module is used for supporting a user to configure basic elements and a data report display mode, forming an analysis formula and analyzing and calculating data to be displayed;
the report analysis module is used for carrying out dynamic change processing on the data report according to the analysis formula and presenting the data to be displayed through the changed data report;
the storage analysis module is used for storing each piece of data after being displayed and the corresponding data position information as one piece of data;
the database is used for storing background data, and the background data comprises, but is not limited to, data to be displayed, analysis formulas and data generated by the storage analysis module;
the basic elements include:
the module is used for dividing function frameworks, data objects, parameter objects and coding objects of different categories;
the function frame is used for identifying the names of the data access tables, the association relation among the data access table names is configurable, and the function frame belongs to a certain template;
the data object is used for identifying the name of a fetch field and the data type in the data table, the data object belongs to a certain function frame, and each function frame can define a plurality of data objects;
The parameter object is used as a filtering condition when a user acquires data, the parameter object belongs to a certain function frame, and each function frame can define a pair of parameter objects;
the coding object is used as a grouping condition when a user groups or groups data, the coding object belongs to a certain function framework, and one function framework can define a plurality of coding objects;
the foreground and background configuration module for configuring the basic element is used for setting the configurable basic element, and comprises the following steps:
creating a basic element information table, wherein the basic element information table comprises a module information table, a function frame table, a data object table, a parameter object table and a data list object table;
creating a flexible function, wherein the data information corresponding to the basic element information table is stored in the object information of the flexible function in a key value pair mode, and the flexible function can be loaded by a data display configuration interface;
the report analysis module is used for carrying out change processing on the data report cells according to the change data information and inserting the data to be displayed into the corresponding data report cells after the change processing, and comprises the following steps:
initializing a change area in a corresponding data report;
performing row and column expansion on the data report cells serving as the change cells;
Changing the row coordinate rule name of the data report unit lattice and the row coordinate rule name of the change area in the data report;
circulating the data report cell and inserting the data to be displayed into the corresponding data report cell;
storing the change data information and the format information as data information;
merging the data report cells;
modifying the editable state of all data report cells in the data report;
the background configuration module is used for executing the following configuration basic elements and configuring the data report presentation mode:
loading flexible functions on a data display configuration interface, acquiring basic elements, configuring the basic elements according to configuration rules to generate a data result set, wherein each unit of the data result set is marked with data display rules, data classification and data position information corresponding to data to be displayed, and the configuration rules can form an access SQL statement for acquiring and formatting the data to be displayed;
traversing the data result set, and splitting the data result set into data matrixes;
configuring a display mode of a data report, wherein the display mode comprises configuration of a variation attribute of the data report, the variation attribute of the data report comprises a fixed table and a variation table, the data report with variation attribute of the variation table is a variation data report, configuration of a regional variation attribute of the variation data report, the regional variation attribute of the variation data report comprises a fixed region and an expansion region, configuration of an expansion region type of the expansion region, and the expansion region type of the variation data report comprises variation cells, line variation, column variation and fixed cells;
The formula type attribute of the data report cell is configured, an analysis formula is configured for the data report cell with the formula type attribute being an analysis formula, the analysis formula comprises a data matrix in a JSON format, a number-taking SQL statement and a display mode of the configured data report corresponding to the data report cell, and the analysis formula can be loaded by a data report foreground.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010630267.4A CN112036118B (en) | 2020-07-03 | 2020-07-03 | Configurable data report dynamic display method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010630267.4A CN112036118B (en) | 2020-07-03 | 2020-07-03 | Configurable data report dynamic display method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112036118A CN112036118A (en) | 2020-12-04 |
| CN112036118B true CN112036118B (en) | 2024-01-26 |
Family
ID=73579486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010630267.4A Active CN112036118B (en) | 2020-07-03 | 2020-07-03 | Configurable data report dynamic display method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112036118B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112434507B (en) * | 2020-12-10 | 2022-03-15 | 四川长虹电器股份有限公司 | Electronic bill generating method based on bill element configuration |
| CN112560413B (en) * | 2020-12-15 | 2023-08-04 | 中国人寿保险股份有限公司 | Report form expansion method, device and equipment based on configuration mode |
| CN114611478B (en) * | 2022-03-22 | 2022-11-11 | 广西电网有限责任公司 | Information processing method and system based on artificial intelligence and cloud platform |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| WO2017028611A1 (en) * | 2015-08-18 | 2017-02-23 | 中兴通讯股份有限公司 | Form implementation method and apparatus |
| CN111259104A (en) * | 2020-01-22 | 2020-06-09 | 山东浪潮通软信息科技有限公司 | Report data synchronization method and device capable of defining rules |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9501462B2 (en) * | 2013-12-02 | 2016-11-22 | G360Link, Inc. | Form object having form representation and grid representation of form |
-
2020
- 2020-07-03 CN CN202010630267.4A patent/CN112036118B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| WO2017028611A1 (en) * | 2015-08-18 | 2017-02-23 | 中兴通讯股份有限公司 | Form implementation method and apparatus |
| CN111259104A (en) * | 2020-01-22 | 2020-06-09 | 山东浪潮通软信息科技有限公司 | Report data synchronization method and device capable of defining rules |
Non-Patent Citations (2)
| Title |
|---|
| 基于B/S架构的动态报表设计及实现;李辉;陈玉石;;科学家(第09期);全文 * |
| 如何实现SAP ERP财务报表的灵活定制;成红伦;裴奇;范瑞辉;;电脑与电信(第11期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112036118A (en) | 2020-12-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112036118B (en) | Configurable data report dynamic display method and system | |
| US11380087B2 (en) | Data analyzing device | |
| US20020069197A1 (en) | Method and apparatus for categorizing information, and a computer product | |
| US10740378B2 (en) | Method for presenting information volume for each item in document group | |
| CN108664509B (en) | Method, device and server for ad hoc query | |
| JP5588811B2 (en) | Data analysis support system and method | |
| US20030182296A1 (en) | Association candidate generating apparatus and method, association-establishing system, and computer-readable medium recording an association candidate generating program therein | |
| CN111897836A (en) | Search system, method and storage medium | |
| EA003743B1 (en) | Computer automated system for management of engineering drawings | |
| JP5324677B2 (en) | Similar document search support device and similar document search support program | |
| US20050065947A1 (en) | Thesaurus maintaining system and method | |
| CN115936017A (en) | Main data management method supporting interface multiple languages and data multiple languages | |
| US20070255746A1 (en) | Method for Processing Associated Software Data | |
| CN114780589A (en) | Multi-table connection query method, device, equipment and storage medium | |
| CN112989153B (en) | Data processing method and device and computer equipment | |
| JPH07192010A (en) | Document processing unit | |
| US11645362B2 (en) | Data analyzing device | |
| JPH10232874A (en) | Information processing know-how sharing method | |
| CN115544985B (en) | Statistical chart making method, device, equipment and medium based on geographic computing language | |
| CN113220945B (en) | Method and system for field retrieval and path display of data blood edges | |
| CN112187550B (en) | Log analysis method based on density peak value multi-attribute clustering | |
| CN115860676A (en) | Automatic promotion recommending method and system for crop breeding materials | |
| CN113868286A (en) | Information query method, device, equipment and storage medium | |
| JP3501325B2 (en) | Graphic definition generation method and apparatus | |
| CN118113736A (en) | Method and device for improving data retrieval performance stability of airborne database |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20231228 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |