PDA

Click to See Complete Forum and Search --> : crystal report error


noister
Jul 17th, 2008, 03:01 AM
hi to all,

cr 11, vb6

i got an error [20728: F] with the following code:'MsgBox strQry

''VIEW/GENERATE CRYSTAL REPORT
With cr

.Connect = " DSN=" & sql_odbc & "; " & _
" uid=" & sql_user & "; " & _
" pwd=" & sql_pass & "; " & _
" database=" & sql_db & "; "

.ReportTitle = "noisterCall 1.0 - Report"
.WindowTitle = "noisterCall 1.0 - Report"

'restriction
If strUserType = 5 Then .WindowShowExportBtn = False: .WindowShowPrintBtn = False

.SQLQuery = strQry
.Destination = crptToWindow

'show
.ReportFileName = App.Path & "\" & strReportFile

'MsgBox App.Path & "\" & strReportFile

'.ReportSource = crptDataControl
'.Action = 1

.PrintReport

MsgBox .LastErrorNumber & ": " & .LastErrorString, vbCritical, "noisterCall"

'MsgBox App.Path & "\" & strReportFile

End Withpls help it's urgent... any help really appreciated.

Hack
Jul 17th, 2008, 11:53 AM
What line causes the error and what is the text of the error?

noister
Jul 18th, 2008, 02:27 AM
i solved this issue already yesterday, by replacing crpe32.dll other version...

now, i have different problem... i installed the application to the other PC... but when i run the report it says "339 - Component Crystl32.OCX or one of its dependencies not correctly registered..."

when i manually register the Cystl32.OCX, it says "Loadlibrary("Crystl32.OCX) failed")..."

i tried google and found it's dependencies and copy to sys32... but still not solved the problem.

please help, it's urgent...

any help really appreciated.

anyway, can i put resolved in this thread then post a new one for the new one problem? tnx... noister