Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports and VFP interaction not working
Message
General information
Forum:
Visual FoxPro
Category:
Third party products
Title:
Crystal Reports and VFP interaction not working
Miscellaneous
Thread ID:
00616578
Message ID:
00616578
Views:
67
I pass parameters from VFP to Crystal. No errors, but empty report instead.

Here's how I pass parameters.
* Quarterly Top Shock Award Verification (First Pass)
IF THISFORM.cborpt.Value = "101"
	THISFORM.olecontrol1.ReportFileName = "c:\omdrpts\qtrtpshkveri1.rpt"
	THISFORM.olecontrol1.ParameterFields(0) = "Month;'10';TRUE"
	THISFORM.olecontrol1.ParameterFields(1) = "Year;'2001';TRUE"
	THISFORM.olecontrol1.ParameterFields(2) = "S_DATE;Date(2001,10,01);TRUE"
	THISFORM.olecontrol1.ParameterFields(3) = "e_date;Date(2001,12,31);TRUE"
	testout = THISFORM.olecontrol1.PrintReport
ENDIF
Crystal Report works when
I run report with no parameters passed from VFP and with Save Data with Report checked in Crystal.

Crystal Report does not work (empty report disappears after a few milliseconds) when
I run report with parameters passed from VFP and without Save Data with Report checked in Crystal.

Crystal Report does not work (empty report disappears after a few milliseconds) when
I run report with no parameters passed from VFP and without Save Data with Report checked in Crystal and I enter parameter values in Crystal.

SO I have concluded that either the parameters are not being passed correctly for Crystal to understand or the path to the database location is not the same in VFP and Crystal or the record selection formula in Crystal does not understand the parameters being passed to it.

Record Selection formula is inside Crystal Report, I did not pass one from VFP.

Questions
1. How can I interrupt process to check values being passed during passing time?
2. In Crystal parameters are entered for start date, end date as 10/01/2001 for example. But when I use in VFP parameter statement I have date in format as I appear above. Is that right or wrong?

Thanks for the help. I am really lost on this one. Have spent way too much time on this problem. Even called Crystal Tech Support and they sent me some samples in VB to help me try to figure this out. I even researched their website. I have several Crystal books and can't find the solution. I am doing everything the books say to do. I have double-checked everything several times.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Reply
Map
View

Click here to load this message in the networking platform