If you are using Crystal Report 2008 its possible
Create Formula
    in that
       previous({DATASOURCE_txt.Amt})

In Crosstab
    Select Date for Column

    In Summarized field
       Select field to summarize
       also select the formula filed.

  Place the Cross Tab in the Report.
    In Display String of the Previous formula in the CrossTab
use the following formula

if not (CurrentColumnIndex=1) then
(
    totext(
    currentfieldvalue-
    gridvalueat(CurrentRowIndex,CurrentColumnIndex,CurrentSummaryIndex-1)
    )
)

I think it will be confusing, if required I can send u the sample we did
      

Can I know which email address to send or can you make your email address public in the forum for some time.

Edited by venkatesha - 03 Jul 2008 at 10:47pm

Hi

Getting closer with this one.

i can see that you used the 'previous' but In my report I dont have any rows, just columns.

where I am stuck is that I am counting the number of transactions numbers and not actual values, so when it comes to using the 'previous' statement it for example does this

            01/01/2008      02/01/2008
Total:   1857                  2000
            1856                  1999

But how I want it to display is like this:

            01/01/2008      02/01/2008
Total:   1857                 2000
            0                       1857

Then if also possible

            01/01/2008      02/01/2008
Total:   1857                 2000
Prev     0                       1857
Diff       0                       143

Thanks