VFP 7.0 and Crystal Report preview report error 1

[bettyfurr]

I think I have my editing correct to preview my report.

I created my report in crystal report. Looks terrible. Still don't have the hang of moving the data, but that isn't this problem.

When I ran my preview form in the command window, it seemed to flash on the screen. I received a fatal error: exception code=C0000005 @ 07/08/03 10:26:22 PM.

I viewed the error log and that was the error in it. No help.

Please, can anyone steer me towards an answer? I think if I can get pass this and see a ugly report display, I will have all the learning curve underway.

 

[Mike Lewis]

Betty,

OK, I'll speak to you again tomorrow.

Thank you for hanging in here.

This is only until Craig gets back from vacation <g>.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[bettyfurr]

will do tonight. I will let you know. Have you seen this error before?

 

[craigber]

I'm back for a couple of days before leaving again ..


Does tcReportName contain the fully qualified filename (ie drive, letter, directory, filename, including the .RPT)?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports&quot;

 

[bettyfurr]

do form crystalpreview with &quot;C:\sil\cr_svds.rpt&quot;

When I am in debug with the set step on, I see the tcReportName has the fully qualified name in the parameter.

 

[bettyfurr]

I changed the report in crystal to save the data. reran in VFP the do form crystalpreview with &quot;C:\sil\cr_svds.rpt&quot;
and it did not crash. However, if I click the refresh button it crashes with C5 error.

Something is still not clicking, yet.

Please help.

 

[Mike Lewis]

Betty,

However, if I click the refresh button it crashes with C5 error.

That suggests that the problem lies in the way that the report is accessing the data.

Does the report use ODBC? Or OLE DB? Or is it accessing the tables natively? If ODBC, is the DSN set up correctly? Can you try using the DSN within VFP to check that it is OK? (I can talk you through this if necessary.)

Couple of other things worth checking: Make sure the tables (and DBC, if any) are not opened exclusively within VFP when you run the report. Make sure the DBC is valid (try running VALIDATE DATABASE on it).

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[bettyfurr]

Mike, the table is created through the command.

copy to filename fox2x

I reference the data in Crystal Report with the Xbase link.

 

[Mike Lewis]

Betty,

the table is created through the command.
copy to filename fox2x

OK, that rules out any ODBC issues.

What next? Have I asked what happens if you run the report in CR itself? And especially, if you refresh the report within CR?

I suppose the next step is to eliminate as many variables as possible. You could try to create a minimum report, using the same table, but perhaps with only one field. Try running it in CR and from VFP. If it works, gradually build it up towards the actual report you want. Whan (if) it crashes, that will tell you where the problem lies.

Betty, it's late afternoon where I am, and I'm about to close down for the day, so I might not manage to speak to you again before next week. I hope this problem won't spoil your weekend.

Mike



Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[bettyfurr]

In case you are still on-line.

It runs fine in Crystal. I can refresh. Print page 5, etc. no problem.

Thank you for your support/help. Have a great weekend!

 

[Mike Lewis]

Betty,

Yes, still here.

OK, I think it's still a good plan to create a minimum report and to build up grandually.

Also, you might double-check to make sure the table is not open in VFP before you call the report.

Right, I'm out the door ...

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[bettyfurr]

I put in one field and without the data saved with the form, I crash with c5. With the data save, I can not do a refresh.

I am going to uninstall everything tonight and start again.

I have the latest hot fix on Crystal. I am going to leave it off and see if that helps.

Thank you guys for your help. This can not be happening I know, but it is.

Betty

 

[Mike Lewis]

Betty,

I'm keeping my fingers crossed for you. I see that this has been going on for two weeks, and still no solution in sight. Let's hope we get it solved soon.

Mike.

Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[bettyfurr]

Amen to that. Sometimes it helps to say that.

 

[bettyfurr]

Your fingers crossed worked! The report ran without the data saved with the report and a refresh click did not crash VFP.

I removed VFP and Crystal. I installed VFP and SP1. Installed Crystal, no hotfix. First time: I installed VFP, Crystal, hot fix for Crystal, and VFP SP1. Maybe wrong order? Or bad hot fix on Crystal.

I don't know what cause the problem. I still don't have the warm and fuzzy over the solution because I truly did not find the problem.

Right now I am just so relieved that I can now concentrate on the getting that ugly report cleaned up and developing others.

I am going to keep my fingers crossed that the problem does not return.

Again, thank you guys, Mike and Craig for being there for support.

 

[craigber]

Whew! I'm glad you got things working.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports&quot;

 

[Mike Lewis]

Betty,

That's a relief ... although, as you said, it would have been nice to know exactly what caused the problem in the first place. I guess it must have been a corrupted DLL or somesuch.

Let's hope it stays fixed.

No doubt be speaking to you again soon.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk