how to resolve a problem with crystal 8.5

[FILIPM]

Hi Smart Guys,

about thread184-748134 i put on tek-tips.

I'm still not reaching what I want.
It is working fine(printing) when I copy my file to a foxplus type.
otherwise I get an ODBC error.
I would really want to work with the visual file types.

My code in vfp7.0 sp1 is :
oCRApp = createobject("crystal.crpe.application&quot
oRep = oCRApp.OpenReport("test.rpt&quot
oRep.Printout(.F.) && .F. = no printer dialog

When I try to make a preview with the foxplus type file it seems to disappear directly.

Can anybody help me with the visual solution.
In my crystal report 8.5 designer it works very fine.
What am I doeing wrong ??

Question 2 : how do I distribuate this ? which files are needed ?
I found something on faq 184-608353 but this doesn't work at all

Help would be very appriciated !

Thanks

FILIP MERLIER

 

[craigber]

Don't use the CRPE. Use the RDC. There are white papers on my web site that show you how to do this. Also, I recommend that you use OLE DB instead of ODBC.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[FILIPM]

Hello Craig,

Another little question,
When I make my report with odbc in crystal design, how can I use them in a formset toolbar if You say i better not use ODBC.
It is necessary to make a form for every preview ?
I think I am asking silly questions but I don't know any better for the moment.

FILIP MERLIER

 

[craigber]

You should read the articles on my web site. You only need one preview form. Also, I wouldn't use a formset, but use individual forms. Formsets are too difficult to control and individual forms are considered "best practice".

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"