VFP and Crystal XI Viewer

[johnjrd]

I have the following code which allows you to view a crystal report from VFP however
when it hits the Openreport command I get the following error message.


OLE IDispatch exception code 0 from Crystal Reports ActiveX Designer : Invalid TLV record

I've made sure that the correct dll and merge modules are installed on my machine as per the instructions at many of sites and read the following white paper on the BO support site c2014917

but still get this error

Any suggestions would be gratefully received

John

LOCAL oCR AS CRAXDRT.Application
LOCAL oRpt AS CRAXDRT.Report
LOCAL oDB AS CRAXDRT.Database
LOCAL ocDBT AS CRAXDRT.DatabaseTables
LOCAL oDBT AS CRAXDRT.DatabaseTable


oCR = CREATEOBJECT("CrystalRuntime.Application.11")oRpt = oCR.OpenReport("C:\temp\coursetest.RPT")

 

[craigber]

Invalid TLV Record usually indicates a needed runtime file is not included or not registered.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

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

 

[johnjrd]

Ive got the following dll files do you know of any others

craxdrt.dll
crviewer.dlll
crqe.dll
ufmanager.dll
atl.dll
msvcp60.dll
msvcrt.dll
riched20.dll

Have followed the whitepaper on the BO site titled
Report Desinger Component XI and have distributed these via the various merge modules using a msi file ive created

 

[Mike Lewis]

John,

The safest way to ensure that all the run time files are present is to use a merge module (I'm assuming your installation program is based on the Windows Installer [InstallShield Expresss is, for example]).

For Crystal XI Developer Edition, the merge modules are located in your "Program Files\Common Files\Merge Modules" folder. They have names like CrystalReports11_5_RDC_Runtime.msm.

If I remember right, the files needed for the report viewer are slightly different from those needed just to open and modify a report (not sure about that; Craig will confirm or otherwise).

Hope this helps.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[johnjrd]

Hi Mike

Yes ive got that merge module in my msi installer package along with the .

Crystal Reports11_rdc_reportengine.msm module it also then includes the other dll files ive mentioned previously.

 

[craigber]

That may be your problem. Do not create your own merge modules, but use the ones Mike pointed to. These ship with Crystal and are the only supported way to distribute runtime components.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

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

 

[johnjrd]

Hi

Ive followed the steps as per the document entitled

Report Designer Component XI
Creating an RDC Distribution Package.

This document quite clearly takes you thru the steps of creating a msi file using the merge modules, which ive done

However from re-reading the document im not sure if you add the merge modules into the msi package or the individual dlls that are needed.

Has anyone managed to get VFP to view a crystal report thru the viewer using the CRYSTAL XI run time files

 

[Mike Lewis]

However from re-reading the document im not sure if you add the merge modules into the msi package or the individual dlls that are needed.

You add the entire merge module. That's the whole point. You don't even need to know which individual files it contains.

Has anyone managed to get VFP to view a crystal report thru the viewer using the CRYSTAL XI run time files

Of course. It's not at all unusual.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[anncastellanos]

Hi,
I have the same error, Ole IDispatch exception code 0 from Crystal Reports ACtiveX Designer: Invalid TLV Record
I register all dlls
Someone could tell me any tip?
sorry by my english

 

[Mike Lewis]

Anncastellanos,

Did you try the suggestions we mentioned in the previous messages?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[johnjrd]

Hi

The only new thing ive found out is to try moving the crqe.dll into the windows\system32 folder and registering it.

Has anybody managed to get the Crystal Viewer working with the CRXI runtime files yet.

 

[anncastellanos]

Thanks I try it, I appreciate your help

Atte.
Ana

 

[Nro]

Hi.

When I received « Invalid TLV » it’s usually that the report (Ex. Cust01.RPT) is in a prior version of Crystal. You can’t view a report written in v11 in a v8.5 viewer. In fact, I never test the other way, let’s say view an 8.5 .RPT with V11 viewer.

As for installation, I always install Crystal runtimes as a separate package. In InstallShield, I check (in merge modules), theses options;

CR11_rdc_designtime
CR11_rdc_licence (don’t forget to include your serial number)
CR11_rdc_reportengine
CR11_rdc_runtime

Hope this help a bit. Good luck

Nro

 

[Mike Lewis]

Nro,

You can’t view a report written in v11 in a v8.5 viewer. In fact, I never test the other way, let’s say view an 8.5 .RPT with V11 viewer.

The viewer is backward compatible but not forward compatible. You can view 8.5 (or earlier) reports in the viewer for 9.0 (and later), but not the other way round.

Between 9.0 and XI, the viewer is compatible both ways.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk