"Invalid TLV record" Error - Need workaround! 1

[wdaveb]

Got this error while trying to load a report w/ the RDC through ASP. The Seagate site acknowledges this error is caused when using the RDC with a .RPT file that uses a .QRY file. Their fix is to re-create the query w/ the Query Expert. My query (for Oracle 8i) is big and complex. I'd prefer to avoid recreating the query. Has anyone figured out a way to use .QRY files with the RDC for ASP?

 

[wapowell]

I have this problem also. I'd also like to know if anyone has a workaround/fix for this. I'm using CR8.
Thanks,

-Bill

 

[Ngolem]

You are using a query from SQL designer as a data source for a report?? I don't think you can do that using ASP.

Is it possible to execute the query in ASP and create a record set to pass to the Crystal report?

 

[kjohn008]

Q. : When i am trying to execute (using CRViewer) the following code, i am getting an error message :

Error: Invalid TLV Record.

what does it mean? But when i execute the same report (john.rpt) from CrystalReport1.PrintReport, it is showing perfectly.

The Code :


Dim myApp As New CRAXDRT.Application
Dim myRpt As New CRAXDRT.Report

Private Sub Form_Load()

mpath = "c:\john.rpt"
Set myRpt = myApp.OpenReport(mpath, OpenMethod)
CRViewer1.ReportSource = myRpt
CRViewer1.ViewReport

End Sub

 

[fwe]

If I am not mistaken, the problem is not in the code, you have a either a corrupt or previous version a Crystall.dll on that PC. You will probably have to run a dll utility and see what is loaded and compare with the one that works.

Possible that one of the .dlls is in the \windows\system32 and the Crystal directory.

 

[dgillz]

TLV=Total length value. You might try the Crystal Decisions website and see if there are any articles on that error.

Also, if you have been making any changes to the database -- not to the underlying data but to the database itself such as field lengths, field names, datatypes, adding or deleting a field, etc -- you need to verify your database in Crystal to make sure Crystal "sees" these changes. Perform this from the database menu. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[Crystalguru]

Actually, TLV stands fro T=Tag L=Length V=Value.

And the Invalid TLV message seems to be a standard error message for about anything!