profit & loss report query

Hi

I need to write a profit & loss statement report in Crystal. Can anyone provide me with a query that they have written that I can use? I have searched everywhere and been unable to find anything. I have tried querying from OACT and OJDT but I am getting completely different results than the SAP P&L report.

Thanks

Jack