For a complex data window-CodePudding

data:
Id pname pdate detail
1 Tom 2017/4/1 morning
2 Tom 2017/4/30 morning
3 Tom 2017/5/1
in the afternoon
4 Jones 2017/4/30 morningFive Jim 2017/4/29 morning
The data window:
30 column, with greater than or equal to 30 days after today for column
Line: don't repeat name
Data area: the detail
The diagram below:

How to implement, thank you!

CodePudding user response:

A new passive data window, use the getitem with setitem include my you can put those values,

CodePudding user response:

Set up an empty datawindow structure (figure 1)
Read information to fill in again (figure 2)

(figure 1)

(figure 2)

CodePudding user response:

refer to the second floor eclat2299 response:

set up an empty datawindow structure (figure 1)
Read information to fill in again (figure 2)

(figure 1)

(figure 2)

Thank you very much! You this is what I want,
Figure 2 read data should be grouped by name before they are better?

CodePudding user response:

Quote: refer to the second floor eclat2299 response:

Set up an empty datawindow structure (figure 1)
Read information to fill in again (figure 2)
Can also consult: like excel, drag a week's data to post-election copied to any one week, thank you!
CodePudding user response:
Quote: refer to the second floor eclat2299 response:

Set up an empty datawindow structure (figure 1)
Read information to fill in again (figure 2)
Can fill in the information is too cumbersome stick your code up learning, thank you!
CodePudding user response:
The data retrieved first (given) in 30 days, according to the PNAME, PDATE sorting, crosstab,
CodePudding user response:
If simple implementation, cross table is a very good choice ~
CodePudding user response:
Establish a data window can choose line compiled
CodePudding user response:
If as screenshot data using cross table
CodePudding user response:
Can be done using dynamic data window
CodePudding user response:
Using cross report is ok
CodePudding user response:
Create Crosstab types of data window is ok
CodePudding user response:
Using cross table, and if the data needs to be sorted out with stored procedure + crosstab!
CodePudding user response:
Use crosstab good use crosstab is good it is good to use cross table use crosstab good use crosstab is good it is good to use cross table using cross table
CodePudding user response:
You can cross table
CodePudding user response:
This can be achieved by cross table
CodePudding user response:
Using cross table data window
CodePudding user response:
Stored procedure + temporary table, dynamic data window
CodePudding user response:
Will cross table the most simple, wouldn't cross table with the method I said above,