Vista - RE: How to trace what's Crystal Reports is doing?

04-13-2009

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...1-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/s.../bb896645.aspx

"Markus Betz" wrote:

Quote:

> 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
>

04-29-2009

hi i have a problem .if u solve it please send it tom y mail
jo_gourav@xxxxxx

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!.

04-29-2009

On Apr 14, 1:10*am, Eric Russell
<EricRuss...@xxxxxx> wrote:

Quote:

> 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/s.../bb896645.aspx
>
> "Markus Betz" wrote:

Quote:

> > Hello,

>

Quote:

> > 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.

>

Quote:

> > 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.

>

Quote:

> > TIA, Markus

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!.

04-13-2009	#1 (permalink)
Eric Russell n/a posts	RE: How to trace what's Crystal Reports is doing? 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...1-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/s.../bb896645.aspx "Markus Betz" wrote: Quote: > 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 >
My System Specs

04-29-2009	#2 (permalink)
hitomyfriends n/a posts	Re: How to trace what's Crystal Reports is doing? hi i have a problem .if u solve it please send it tom y mail jo_gourav@xxxxxx 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!.
My System Specs

04-29-2009	#3 (permalink)
hitomyfriends n/a posts	Re: How to trace what's Crystal Reports is doing? On Apr 14, 1:10*am, Eric Russell <EricRuss...@xxxxxx> wrote: Quote: > 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/s.../bb896645.aspx > > "Markus Betz" wrote: Quote: > > Hello, > Quote: > > 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. > Quote: > > 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. > Quote: > > TIA, Markus 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!.
My System Specs

Similar Threads
Thread	Forum
SetDataSource very slow in crystal reports	.NET General
crystal reports Vb2005	.NET General
Crystal Reports	.NET General
confused about crystal reports with .NET 2.0 and C#[need basicadvice]	.NET General
Crystal Reports Deployment Question	.NET General