Crosstabbing using Activewidgets
I have recordset which returns in the following format:
Name Date Month Value
ABC 1/1 1 100
ABC 1/1 2 125
ABC 2/1 1 150
ABC 2/1 2 425
XYZ 1/1 1 50
XYZ 1/1 2 125
XYZ 2/1 1 140
XYZ 2/1 2 47
I have to show this as follows on my ASP page:
Name Date 1 2
ABC 1/1 100 125
1/2 150 425
XYZ 1/1 50 125
1/2 140 47
No. of Names and months can be 1 to n in number(dynamically generated).Please tell how can I do this crosstabbing using Activewidgets? I am using Oracle as back end.
Name Date Month Value
ABC 1/1 1 100
ABC 1/1 2 125
ABC 2/1 1 150
ABC 2/1 2 425
XYZ 1/1 1 50
XYZ 1/1 2 125
XYZ 2/1 1 140
XYZ 2/1 2 47
I have to show this as follows on my ASP page:
Name Date 1 2
ABC 1/1 100 125
1/2 150 425
XYZ 1/1 50 125
1/2 140 47
No. of Names and months can be 1 to n in number(dynamically generated).Please tell how can I do this crosstabbing using Activewidgets? I am using Oracle as back end.
June 6,