report formatting

[swetham]

Hi,
I have a report in this format,

cp1 reg1 tr1
SNO Name tot 2010-05-01 2010-05-02 2010-05-03
001 abc 8 1 3 4
002 def 5 1 1 3
total 13 2 4 7

cp2 reg2 tr2
SNO Name tot 2010-05-01 2010-05-03
003 hgt 5 1 4
004 rty 4 1 3
total 9 2 7

I have 3 groups cp,reg,tr, i placed the crosstab in "tr" group. in row field i wrote a formula for sno as




the column dates will be given by user as startdate and enddate. In first group data is there for 01,02,03 dates and in next group data is there only for 01, 03.

Now my problem is i want the crosstab as

SNO Name 2010-05-01 2010-05-02 2010-05-03 total

cp1 reg1 tr1
001 abc 1 3 4 8
002 dff 1 1 3 5
tot 2 4 7 13

cp2 reg2 tr2
001 fgh 1 0 4 5
002 rty 1 0 3 4
tot 2 0 7 9

a) the sno,name,etc heading i want to repeat once only
b) sno should be starting from 1 in every group
c) If data is not present dat should be zero.

CAn anyone please help me?

Thanks,
sweish

 

[swetham]

Can anyone please help me? it is very urgent.

 

[swetham]

someone please help me

 

[TeyBrady]

http://www.tek-tips.com/viewthread.cfm?qid=1567016

 

[swetham]

i did not understand the example in the link. can u explain it clearly as i am new to crystal reports?