How to trace what's Crystal Reports is doing?

[Markus Betz]

Hello,

I am replacing the data source of existing reports from an SQL database
to XML datasets (CR 10 in VS 2005). In principle this works fine, but
one the reports does not load any data.

Is there any way to monitor/trace/debug what Crystal Reports is doing or
what it is looking for? I am used to read logs or trace files to find
bugs, but Crystal Reports is a big black box and it does either work or
it does not, and it is hard to find out why.

TIA, Markus

 

[Markus Betz]

Using SQL Profiler, you can trace what stored procedures and SQL statements a
SPID is executing.
Step-By-Step: An introduction to SQL Server Profiler
http://articles.techrepublic.com.com/5100-10878_11-5054787.html

Also, there is a fabulous tool available for free from MS TechNet called
Process Monitor, that shows real-time file system, Registry and
process/thread activity. For example, it can show what files and registry
keys that the Crystal Reporting engine is hitting as it processes.
http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

All this does not help me monitoring CR reading from an XML dataset
already in memory.

CR only accepts System.Data.DataSet, so I cannot use a class of my own
to get in between.

Markus

 

[hitomyfriends]

hi i have a problem .if u solve it please send it tom y mail
(e-mail address removed)

i have a problem in crystal report. Taking too
much time to load .i saw what the report do behind .So i found this
how to solve this problem.
"Files\Common Files\Business Objects\2.7\Bin\crdb_ado_res_en.dll
NOT FOUND Attributes: Error"
so i can able to load the report fast i m using vb.net 2005 and as a
back end using Sql Server.
I use very simple report and two subreport in that it takes exactly
1.5 min to load .But in vb in very fast.
Please help!.

 

[hitomyfriends]

Using SQL Profiler, you can trace what stored procedures and SQL statements a
SPID is executing.
Step-By-Step: An introduction to SQL Server Profilerhttp://articles.techrepublic.com.com/5100-10878_11-5054787.html

Also, there is a fabulous tool available for free from MS TechNet called
Process Monitor, that shows real-time file system, Registry and
process/thread activity. For example, it can show what files and registry
keys that the Crystal Reporting engine is hitting as it processes.http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

i have a problem in crystal report. Taking too
much time to load .i saw what the report do behind .So i found this
how to solve this problem.
"Files\Common Files\Business Objects\2.7\Bin\crdb_ado_res_en.dll
NOT FOUND Attributes: Error"
so i can able to load the report fast i m using vb.net 2005 and as a
back end using Sql Server.
I use very simple report and two subreport in that it takes exactly
1.5 min to load .But in vb in very fast.
Please help!.