[kshyamsundar]

I am creating a Crystal Report which has first 4 columns has known ones. Starting from Column 5 it has to be in dynamic number i.e. based upon the number of values returned from the database so many no. of columns must display starting from column 5.

Crosstab report is the ideal choice for this one. But I want the first 4 columns to print in each row on excel. Also subtotals and totals must be calculated where the value must be the sum of values in column 5,6,7... divided by column 3 value. Column 3 value is a count calculated by a formula used inside a crosstab.

Please let me know the solution to do the above.