I'm in process of developing one report using CR.NET

My problem is, i have an unknown number of column.

I tried to use crosstab, however, i cant afford to miss some of the calculated field like a variance calculation for each column.

 

Would be much appreciate if any of the master can help me to sort this out.

 

This is the example of how the report will look like.

I have n number of column which i dont know how many until the report is generated in runtime.

i want to calculate the variance value against the total for Valn.

 

Item        Factor       Weight

                              = Factor/Sum(Factor)    Val1      Val2      Val3     Valn

--------     -------         ----------                       -----     -----      ------      ------

ABC           5                                                 4            3         5           2

DEF            3                                                5            2         3           2

FDD           4                                                 5            3         1           4

--------------------------------------------------------------------------------------------

TOTAL      12                                                14           8         9            8

                                 -----------------------------------------------------------------

Variance  To the Valn                                  Var1        Var2    Var3       Varn

--------------------------------------------------------------------------------------------

 

Please help