Solved

cannot GetSQLQuery for report

Posted on 2003-12-08
5
786 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:truedev-pk
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 9904030
What code are you using to display the report?

mlmcc
0
 

Author Comment

by:truedev-pk
ID: 9911556
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.
0
 

Author Comment

by:truedev-pk
ID: 9911695
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.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11868193
PAQed, with points refunded (50)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question