How will the datawindow will the merger take a new name, would be shown to other datawindow, also can add a button, according to
For example datawindow is as follows:
Use two DataWindow
The first Datawindw1 put
Our communications
Company office 1 20 to 30
Company office two 20 to 30
Hr 20 to 30

After the merger
Our communications
Company office 40 to 60
Hr 20 to 30

CodePudding user response:

Dec ld_information, ld_communication

Select sum (paid), sum (communications) into: ld_information, ld_communication from the Table where the Name in (' 1 'company office,' 2 'company office)

CodePudding user response:

Either in the data source, data merging
Either group in the dw

CodePudding user response:

Find organization table company's office at the next lower level is the office 1, 2, 3, n
Then take the superior coding

CodePudding user response:

With regular use grouping, no law, if the content of the is fixed, your code

CodePudding user response:

A, using SQL
Dec ld_information, ld_communication

Select sum (paid), sum (communications) into: ld_information, ld_communication from Table group by department

Two, with a group, a type of data warehouse, grouping set by department, according to the information costs and communications summary which can be,

CodePudding user response:

Search, SQL transform