I have to create a report which would have been a snap in Cross tab, but its not possible to create it as it needs some columns which i cannot create in cross tab.

so seeking some help.

I have to show a report which looks like this

sn col1 col2  oct-10    nov-10   dec-10  jan-11  Feb-12  Mar-12  Apr-12 tot
                                   aa   bb   aa   bb aa   bb aa   bb  aa   bb  aa   bb
           cent
1   x     AA                    0     0    1     0    3    8    0    0      0    0    0     0   12
2   y     BB                    1     0    0     0    0    0    0    1      3     0   0     0    5
3   z     CC                    0     0    4     0    2    3    0    0      0     1   0     4   10
           east
4   u     DD                    0     0    1     0    3    8    0    0      0    0    0     0   12
5   v     EE                    1     0    0     0    0    0     0    1      3     0   0     0    5
6   w     FF                    0     0    4     0    2    3     0    0      0     1   0     4   10

tot1                              2     0   10    0   10  22   0    2      6     3   0     8   34
tot2                                2           10        33        2             9         8       34
tot3                            80   20 110  40  90  82   0   12    56   33  0    58 581
%of tot2 agaistn tot3
%of tot1 against tot3

the problem is , i have a lot of col2 for which there could be no data present in other tables. I am quite sure this is not very clear if someone would help i could explain more. i am new to crystal reports. i could make this if i was to use something like ASP or java or jsp. But crystal reports is a mystery to me. Please help. i am literally hanging by a thread on this one.

you could also try the hard way
first group on one of this not sure which"sn col1 col2 "
then create a formula for each date something like
if table.emount in date()to date() then table.emount
then create summaries from those formula fields by
using formulas(sum(newField,group) or right clicking on the
field >insert>summary... (place them into group header or footer)
for your totals
create multiple report footers(go report tab >section expert>select report footer
>click insert twice) then create your formulas for totals and place them there.

Hello Kostya,

this approach is not working. still struggling to get this report formatted. But thanks for the help.