Avatar of BlakeMcKenna
BlakeMcKennaFlag for United States of America

asked on 

Is it possible to debug a Crystal Report while running?

I have a Crystal Report 10 that is running under a VB.Net application. The report will work for some criteria and not work for other criteria. The RecordSelectionFormula is very simple and I can actually view the values via the .Net app. However, once it goes into the CR, I can't track the data. Does CR have any kind of debug mode?

Thanks,
Blake
Visual Basic.NETCrystal Reports

Avatar of undefined
Last Comment
Mike McCracken
Avatar of Mike McCracken
Mike McCracken

Nothing that I know of.

What SQL is used?

What selection criteria?

mlmcc
Avatar of BlakeMcKenna
BlakeMcKenna
Flag of United States of America image

ASKER

I'm using SQL Server 2005.

crDOC.RecordSelectionFormula = "{tblBatchDetail.rowID} = " & mRowID

The mRowID has a valid value to. It only happens on a specific record.
What is the selection statement?  is this multiple tables that ar joined?

mlmcc
Avatar of BlakeMcKenna
BlakeMcKenna
Flag of United States of America image

ASKER

Yes, I have multiple tables. As far as the selection statement...I assume you mean the SQL Query that CR creates automatically. Here it is:

SELECT "tblBatchDetail"."supplier2", "tblBatchDetail"."terminalName", "tblBatchDetail"."terminalNumber", "tblBatchDetail"."splcCode", "tblBatchDetail"."carrierName", "tblBatchDetail"."carrierSCAC", "tblBatchDetail"."fein", "tblBatchDetail"."destCity", "tblBatchDetail"."destState", "tblBatchDetail"."bolNumber", "tblBatchDetail"."poNumber", "tblBatchDetail"."startLoadDateTime", "tblBatchDetail"."endLoadDateTime", "tblBatchDetail"."productDesc", "tblBatchDetail"."prodCode", "tblBatchDetail"."grossGallons", "tblBatchDetail"."netGallons", "tblBatchHeader"."batchDateTime", "tblConsignees"."AdventCustomerID", "tblConsignees"."AdventCustLocNumber", "tblConsignees"."AdventPricingVendor", "tblCarriers"."AdventCarrierCD", "tblConsignees"."consignee", "tblConsignees"."AdventInvSiteID", "tblConsignees"."AdventVendorLocationID", "tblProducts"."AdventProductCD"
 FROM   ((("VendorReports"."dbo"."tblConsignees" "tblConsignees" INNER JOIN "VendorReports"."dbo"."tblBatchDetail" "tblBatchDetail" ON "tblConsignees"."consignee"="tblBatchDetail"."destCustNumber") INNER JOIN "VendorReports"."dbo"."tblBatchHeader" "tblBatchHeader" ON (("tblConsignees"."supplier"="tblBatchHeader"."supplier") AND ("tblConsignees"."terminal"="tblBatchHeader"."terminal")) AND ("tblBatchDetail"."rowID"="tblBatchHeader"."rowID")) INNER JOIN "VendorReports"."dbo"."tblCarriers" "tblCarriers" ON (("tblBatchHeader"."supplier"="tblCarriers"."supplier") AND ("tblBatchHeader"."terminal"="tblCarriers"."terminal")) AND ("tblBatchDetail"."carrierName"="tblCarriers"."carrierCD")) INNER JOIN "VendorReports"."dbo"."tblProducts" "tblProducts" ON ("tblBatchHeader"."supplier"="tblProducts"."supplier") AND ("tblBatchHeader"."terminal"="tblProducts"."terminal")

If you run the report with no selection statement added do you get the records you are missing?

Since you use INNER JOINs corresponding records must exist in all tables.

mlmcc
Avatar of BlakeMcKenna
BlakeMcKenna
Flag of United States of America image

ASKER

I'm not real good with SQL especially INNER, OUTER, LEFT, and RIGHT joins. I have 3 lookup (cross-reference) tables that are joined by key fields and I'm not real sure if they are what's causing the problem.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Glad i could help

mlmcc
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo