Crystal Report Based on a SQL Designer Query Question....

[ChiTownDiva]

Hi, everybody...

I know that no one is a fan of reports based on queries written in SQL Designer, but I need some assistance.

I wrote a query via SQL Designer and it works fine. I designed the report, it works fine...from my PC.

The problem is I need it to work from the web. I saved the query in the same directory on the server as is on my PC--"D:\Data\TestReports\blah, blah". I then uploaded my report from CR using Crystal Enterprise folder which went fine. I noticed when I went to configure my parameters, CE saved the report as a temp file.

I ran the report which was successful, but when I tried to open it, I got an "Unable to open Page Server" error message--I figured it's because CE saved it as a temp file.

So, I then went through CE (using the "Browse" button) and pulled the report in and CE saved it as a *.rpt file, but when I ran the report, it failed with a "Not Enough Memory for Operation" error.

What am I missing, if anything.

Thanks in advance for your help.

ChiTownDivaus

 

[pelajhia]

Do you have other reports which you have successfully deployed via ce? do they use sql designer queries?

 

[ChiTownDiva]

No, I don'thave any reports that are presently using SQL designer queries.

Thanks.

ChiTownDivaus {ponytails2]