truedev-pk
asked on
cannot GetSQLQuery for report
I'm using Crystal Reports 8.0 for my reports with SQL Server 2000 (stored procedures) and integrating those reports with VB 6.0, the working environment is Win 2K.
when I try to run my reports through VB Application, some reports generate following error.
"cannot GetSQLQuery for report"
unable to figure it out that what to do?
plz help, it's a bit urgent, as my reports are ready but don't work from the client application.
Thanx,
Kashif.
when I try to run my reports through VB Application, some reports generate following error.
"cannot GetSQLQuery for report"
unable to figure it out that what to do?
plz help, it's a bit urgent, as my reports are ready but don't work from the client application.
Thanx,
Kashif.
ASKER
I'm using the following API that returns false in case of error
PEGetSQLQuery
The full declaration goes as follows.
Declare Function PEGetSQLQuery Lib "crpe32.dll" (ByVal printJob%, textHandle As Long, textLength%) As Integer
Kashif.
PEGetSQLQuery
The full declaration goes as follows.
Declare Function PEGetSQLQuery Lib "crpe32.dll" (ByVal printJob%, textHandle As Long, textLength%) As Integer
Kashif.
ASKER
ok thanx mlmcc for taking interest in my question.
i managed to solve it myself. actually I was using an earlier version of crpe32.dll which was making problems, I simpley replaced it with a newer version (the same which I used to develop the Crystal Reports), and it worked for me :)
As a matter of fact there were two different versions of crpe32.dll existing on my development and deployment servers which needed to be made the same. So, I had to copy the DLL from the Development Server and pasted it on the Deployment Server, simple.
Thanx again,
Kashif.
i managed to solve it myself. actually I was using an earlier version of crpe32.dll which was making problems, I simpley replaced it with a newer version (the same which I used to develop the Crystal Reports), and it worked for me :)
As a matter of fact there were two different versions of crpe32.dll existing on my development and deployment servers which needed to be made the same. So, I had to copy the DLL from the Development Server and pasted it on the Deployment Server, simple.
Thanx again,
Kashif.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
mlmcc