Hi All,
I want to create this layout from IReport:
| Column A | Column B | Column C | Column D (D1) | Column D (D2) | Column D (D3) | Column Dn (Dynamic) |
| A1 | Total of all D value (D1+D2+D3+.... until Dn ) | Total of all D value (D1+D2+D3) | D1 Value | D2 Value | D3 Value | Dn Value |
| A2 | Total of all D value (D1+D2+D3+.... until Dn) | Total of all D value (D1+D2+D3) | D1 Value | D2 Value | D3 Value | Dn Value |
| A3 until An (Dynamic) | Total of all D value (D1+D2+D3+.... until Dn) | Total of all D value (D1+D2+D3) | D1 Value | D2 Value | D3 Value | Dn Value |
| Total | B Total | C Total | D1 Total | D2 Total | D3 Total | Dn (Dynamic) |
- Column A have a dynamic row under of it means it's value can be A1 .... until An.
- Column B count all of value from D1 .... until Dn
- Column C only count several column from D, means only count like D1 to D3
- All of Column D it's dynamic so it can shrink or grow depends on how much data in database, for column D header it's dynamic also the value can be (Column D1 to Column Dn) depends on how much data in database also
I'm using crosstab for this layout so i can easyly make Column A and all of Column D dynamic, but i dont know how to create Column B and Column C. I try to add another columnGroup and create new DataSet for this and then include it on crosstab subdataset but i got a message like Field not found, can crosstab have 2 dataset?
I'm right using crosstab for this problem? if i'm not what is your suggestion for this?
Thanks
