Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Previewing Crystal Reports after loading VFP7...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00575845
Message ID:
00622420
Vues:
34
Lisa,

Hi! I solved my problem about a week ago relative to the Crystal Report window appearing and then disappearing almost immediately when running a Crystal Report from a VFP form.

Here's what fixed my problem, maybe it will fix yours.
I had to run a program on the Control Panel called ODBC Administrator and go into the VFP Visual FoxPro table choice and either under Options or Configure or both I got to a screen that allowed me to uncheck a checkbox called "Fetch Data in Background". I unchecked the box and many of my problems went away.

Also, I double-checked and improved the way I pass parameters to Crystal from my VFP form which also helped. If the parameters that my Crystal Report wanted were passed incorrectly I would not see a Crystal Report flash and disappear, it would just stay on my VFP form.

Also, since I am using free tables in VFP, I have to set the directory/path to the free tables in the ODBC Admin under Control Panel or my Crystal Report window will flash and disappear. The bad thing about that is, the setting works with that one report, but reports that use other tables in other directories need to have the directory/path under ODBC Admin changed for each report. SO the way to solve that is to set up a separate Data Source Name (DSN) for each Crystal Report that requires a different location for VFP tables or DBCs. I am in the middle of this part right now, but I got some good examples on how to do it on the fly from within VFP, if I can figure it out! I also talked to Crystal tech support about it and they also clued me in.

If you want to see some examples of this check out some of my latest Third Party threads. Bernhart from Belgium sent me some good samples on how to do this. If you want some examples of passing parameters from VFP to Crystal for reports with start and end dates, I have some examples I could share.

Hope this helps. It ain't easy, but at least it's better than nothing.

All the best.
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform