hi,
i have a problem in report designing.i need a reportto be like this:

Sno Date Paidwith Paid to For Cat Amt

xxxx xxxx xxxxxxx xxxxx xxxx xxx xxx.xx
xxxx xxxx xxxxxxx xxxxx xxxx xxx xxx.xx

Tot

wat i'm getting is like this:

sno date paidwith paidto for cat Amt

xxxxx xxxx xxxxxxx xxxxx xxxx xxx xxxx

Tot :

Sno date paidwith paidto for cat Amt

xxxx xxxxx xxxxxx xxxxx xxx xxx xxxxx

Tot :

Wat i get the result is for every record i'm getting the "tot". I don't want like that.I want all the records displayed continously and then at the end i need the "Total" to be calculated.wat i've to do to display records continously.
Thank u