Crystal Report Server log files

[syncdba]

Hi,
I have created a Crystal Report in CRXI. The report is really slow. I need to debug the report & check the log file or trace file. Where I can check this? I'm BOXI as server. Can I check the file in Report Server or App Server?
Thanks in Advance.

 

[mocgp]

Slow reports can be caused by many things but the most common causes are formulas in the record selection criteria and subreports. If you have a formula in the report filter that is not getting translated to SQL, the client often has to read an entire table before it can process the formula. You can see what is being sent to the server by selecting Database/Show SQL Query. I would debug at this level before trying to extract the cause from a trace file.