Crystal Reports Report debugging?

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Report debugging?

Post Reply

Post New Topic

Author	Message
cull Newbie Joined: 28 Mar 2008 Online Status: Offline Posts: 6	Topic: Report debugging? Posted: 04 Apr 2008 at 1:16pm
	Is there a way to "debug" or "trace" what happens when a report runs? It would be great to see what exact values the report sees when generates.
	IP Logged


Iago Groupie Joined: 01 Oct 2007 Location: United States Online Status: Offline Posts: 52	Posted: 04 Apr 2008 at 1:58pm
	Click on the database menu Then "Show SQL Query" and cut and past that into the query tool for your RDMS. If you do not have one try http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp
	IP Logged

cull Newbie Joined: 28 Mar 2008 Online Status: Offline Posts: 6	Posted: 04 Apr 2008 at 2:05pm
	I did that and my SQL query is fine. I suspect my problem is in passing parameters between my report and my subreports. It would be great to be able to see what exact values are being passed.
	IP Logged

Iago Groupie Joined: 01 Oct 2007 Location: United States Online Status: Offline Posts: 52	Posted: 04 Apr 2008 at 2:21pm
	If it is MS SQL server there is a tool (need to be sa) called profiler. It will record the queries sent to the SQL server. Other vendors have similar tools.
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum