Home > database >  How do I get Cross Tab dynamic column value?
How do I get Cross Tab dynamic column value?

Time:09-21

How do I get Cross Tab dynamic column value?
The EX students drop out classification statistics

Department of health factors don't grade class course factors, economic factors
School is a class 1 year 0 2
School year 0 5 b class 4
Higher vocational department 2 b class 1 year 1

Health factors in their economic factors for @ out_type dynamic

Because you want to deposit into EXCEL Numbers to deal with the
CROSS TAB. Can't use dw_1 geitemstring () way,
Excuse me, how can I get a third armor class dropped out a year classification "health factors" academic factors... Classification of words
With the statistical results of 1,0,2

CodePudding user response:

http://bbs.csdn.net/topics/330037833
As above, need to will be listed first static link as shown below

CodePudding user response:

Thank you

Consult
If grade class health factors schoolwork CrossTab field for sm_year economic factors, sm_sec, @ count_type

String ls_year, ls_sec
The integer li_x
The integer li_count_type_1 li_count_type_2, li_count_type_3

For li_x=1 to dw_1. Rowcount ()
Ls_year=dw_1. Getitemstring (li_x, "sm_year")
Ls_sec=dw_1. Getitemstring (li_x, "sm_sec")
Li_count_type_1=dw_1. Getitemnumber (li_x, "count_type")
Li_count_type_2=dw_1. Getitemnumber (li_x, "count_type_1")
Li_count_type_3=dw_1. Getitemnumber (li_x, "count_type_3")
Next

Such statistics can be obtained?
How do I know if the number is a type that the cause of the statistical results? (




CodePudding user response:

For instance, see your description is a little dizzy
  • Related