My problem belongs to Reporting (I prefer it to be solved in VFP but I am afraid VFP can not handle it, Maybe Crystal Reports can do; that's why I am posting it under both VFP Reports & Crystal Reports. If I am breaking any rules, please delete/modify my mistakes)

I want to attach sample data with this message but could not find any way for it, hence, I am trying to explain as following. (if you found it difficult to understand, please let me know how can i send sample data files to you - by email or by uploading to some website or by giving you download address to download from ftp/http)

I have one table named data.dbf. it has two fieds:
type (character, 1)
amount (numeric)

table contains following data:
Type amount
R 10.00
R 20.00
R 30.00
R 40.00
R 50.00
P 60.00
P 70.00
P 80.00
P 90.00

Now, i want the report in following format:

CASH BOOK
04-APRIL-2004
--------------------------------------------------

RECEIPTS PAYMENTS
10.00 60.00
20.00 70.00
30.00 80.00
40.00 90.00
50.00
--------------------------------------------------
- all the data.amount for type="R" TO BE put in column RECEIPTS
- all the data.amount for type="P" TO BE put in column PAYMENTS

THAT'S ALL! VERY Easy to understand but very hard to implement for me.
I tried to develop this report in VFP - NO SUCCESS, I tried MUCH it in Crystal Reports also - but again - NO SUCCESS.

NOW, only hope is the great UT Community!