Crystal Reports Error

system · March 22, 2013, 3:20pm

Thanks, Kurt, but those check boxes were already unchecked, and there are no stored procedures. Any other ideas?

THOM ROSE
Controller
Electric Mirror

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kurt_hilborn
Sent: Friday, March 22, 2013 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Error

I had the same issue with a few reports. I found that Crystal was set to Save Data With Report under File > Report Options and File > Options. Make sure the boxes are not checked.
If that doesn't work check any stored procedures to make sure they are running correctly.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Thomas Rose <t.rose@...> wrote:
>
> Ver 8.03.403
>
> I have a Crystal/BAQ report that combines data from the BAQ with data from an ODBC query of the database (Thank you, idiot database analyst who combined all the sales reps on an order into one field). The report runs just fine when I run it, but when another user tries to run it, it errors out with "Failed to open the connection". I have the same ODBC connection setup on the user's PC as mine, so I don't understand why it fails there, but not on mine. Any thoughts?

[Non-text portions of this message have been removed]

system · October 27, 2008, 2:23pm

I'm creating a Crystal Report and I keep getting the following error?
I'm using Crystal XI Release 2.

Failed to retrieve data from the database

Details: HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver][OPENEDGE] Sorry, operation not implemented yet (7484) [Database

Vendor Code: -20024]

Any ideas why I might be getting this error. I'm creating an Open Sales
Orders Report.

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>

[Non-text portions of this message have been removed]

system · October 27, 2008, 2:35pm

Travis,

Not to answer your question with a question,

But WHY are you using ODBC vs. the preferred/more efficient method of a
BAQ Query & Report dumping to Crystal?

I'm assuming you are on 8.305+ since you are using that version of CR.

I stopped using ODBC a long time ago and I am very happy.

Vic Drecchio
ERP Administrator

TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...
Office: 336.668.4410 x3091
Mobile: 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Monday, October 27, 2008 2:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Error

I'm creating a Crystal Report and I keep getting the following error?
I'm using Crystal XI Release 2.

Failed to retrieve data from the database

Details: HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver][OPENEDGE] Sorry, operation not implemented yet (7484) [Database

Vendor Code: -20024]

Any ideas why I might be getting this error. I'm creating an Open Sales
Orders Report.

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · October 28, 2008, 8:46am

--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
Mr. Travis: I found this on the Progress site.

ID: P127283
Title: "Crystal report generates error 7484 after upgrading to
OpenEdge 10"

Created: 11/29/2007 Last Modified: 02/22/2008
Status: Verified

Symptoms:

Crystal Report generates error 7484
Sorry, operation not implemented yet (7484)
Report had worked correctly in Progress 9.1x
Queries generated by Crystal for the reports now contain the
syntax 'RIGHT OUTER JOIN'

Facts:

Progress 9.1x
OpenEdge 10.x
Crystal Reports
Windows

Changes:
Upgraded to OpenEdge 10.x

Cause:
The error message is valid and correct as Progress SQL-92 does not
support RIGHT OUTER JOINs using this syntax (the (+) operator is
required); the query generated by Crystal is incorrect for a Progress
database.
Crystal Reports needs to be told which style of SQL JOIN syntax to
use by setting entries in the Window Registry. Whilst this had been
implemented for Progress 9, the name of the ODBC driver .DLL changed
in OpenEdge 10 so Crystal was generating SQL statements that could
not be executed against a Progress database.

Fixes:

For OpenEdge 10.1Bx, add the following entries to the Registry on
each PC running Crystal:

Crystal Reports XI
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

Crystal Reports XI R2
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

For other Progress and OpenEdge and ODBC driver versions, replace the
value "PGOE1022" .DLL with the appropriate version as follows:

Progress 9.1D / Merant 3.60 = PGPRO915
Progress 9.1D / DataDirect 4.1 = PGPRO918
Progress 9.1E / DataDirect 4.1 = PGPRO918
OpenEdge 10.0x / DataDirect 4.2 = PGPRO1019
OpenEdge 10.1Ax / DataDirect 5.1 = PGOE1021
OpenEdge 10.1Bx / DataDirect 5.1 = PGOE1022

Notes:
References to Written Documentation

Progress Solutions:
P5038, "Can not perform Right Outer Join in SQL-92"
P84577, "Crystal Reports 10 and 11 require Registry

Hope this helps,

DaveO

>
> I'm creating a Crystal Report and I keep getting the following
error?
> I'm using Crystal XI Release 2.
>
>
>
> Failed to retrieve data from the database
>
> Details: HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol
> driver][OPENEDGE] Sorry, operation not implemented yet (7484)
[Database
>
> Vendor Code: -20024]
>
>
>
> Any ideas why I might be getting this error. I'm creating an Open
Sales
> Orders Report.
>
>
>
>
>
> Travis Late
>
> ERP Project Manager
>
> M-B Companies, Inc
>
> 1200 Park Street
>
> Chilton, WI 53014
>
> Phone: 920-898-1560 Ext.152
>
> Cell: 920-960-0062
>
> Email: tlate@... <mailto:tlate@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · October 28, 2008, 12:54pm

Vic,

The reason I'm using Crystal is because we are on 5.2 right now. We will
be on this version for a few more months and would like to use the
report in this version until we upgrade.

Travis

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Monday, October 27, 2008 1:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports Error

Travis,

Not to answer your question with a question,

But WHY are you using ODBC vs. the preferred/more efficient method of a
BAQ Query & Report dumping to Crystal?

I'm assuming you are on 8.305+ since you are using that version of CR.

I stopped using ODBC a long time ago and I am very happy.

Vic Drecchio
ERP Administrator

TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
Office: 336.668.4410 x3091
Mobile: 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Monday, October 27, 2008 2:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Reports Error

I'm creating a Crystal Report and I keep getting the following error?
I'm using Crystal XI Release 2.

Failed to retrieve data from the database

Details: HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver][OPENEDGE] Sorry, operation not implemented yet (7484) [Database

Vendor Code: -20024]

Any ideas why I might be getting this error. I'm creating an Open Sales
Orders Report.

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]

system · October 28, 2008, 12:58pm

I'll give this a shot and see if it works. Thanks!

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dave Olender
Sent: Tuesday, October 28, 2008 7:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Error

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@...> wrote:
Mr. Travis: I found this on the Progress site.

ID: P127283
Title: "Crystal report generates error 7484 after upgrading to
OpenEdge 10"

Created: 11/29/2007 Last Modified: 02/22/2008
Status: Verified

Symptoms:

Crystal Report generates error 7484
Sorry, operation not implemented yet (7484)
Report had worked correctly in Progress 9.1x
Queries generated by Crystal for the reports now contain the
syntax 'RIGHT OUTER JOIN'

Facts:

Progress 9.1x
OpenEdge 10.x
Crystal Reports
Windows

Changes:
Upgraded to OpenEdge 10.x

Cause:
The error message is valid and correct as Progress SQL-92 does not
support RIGHT OUTER JOINs using this syntax (the (+) operator is
required); the query generated by Crystal is incorrect for a Progress
database.
Crystal Reports needs to be told which style of SQL JOIN syntax to
use by setting entries in the Window Registry. Whilst this had been
implemented for Progress 9, the name of the ODBC driver .DLL changed
in OpenEdge 10 so Crystal was generating SQL statements that could
not be executed against a Progress database.

Fixes:

For OpenEdge 10.1Bx, add the following entries to the Registry on
each PC running Crystal:

Crystal Reports XI
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

Crystal Reports XI R2
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal
Reports\Database\QueryBuilder\JoinBuilder]
"OracleJoinBuilder"="PGOE1022"

For other Progress and OpenEdge and ODBC driver versions, replace the
value "PGOE1022" .DLL with the appropriate version as follows:

Progress 9.1D / Merant 3.60 = PGPRO915
Progress 9.1D / DataDirect 4.1 = PGPRO918
Progress 9.1E / DataDirect 4.1 = PGPRO918
OpenEdge 10.0x / DataDirect 4.2 = PGPRO1019
OpenEdge 10.1Ax / DataDirect 5.1 = PGOE1021
OpenEdge 10.1Bx / DataDirect 5.1 = PGOE1022

Notes:
References to Written Documentation

Progress Solutions:
P5038, "Can not perform Right Outer Join in SQL-92"
P84577, "Crystal Reports 10 and 11 require Registry

Hope this helps,

DaveO

>
> I'm creating a Crystal Report and I keep getting the following

error?

> I'm using Crystal XI Release 2.
>
>
>
> Failed to retrieve data from the database
>
> Details: HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol
> driver][OPENEDGE] Sorry, operation not implemented yet (7484)

[Database

>
> Vendor Code: -20024]
>
>
>
> Any ideas why I might be getting this error. I'm creating an Open

Sales

> Orders Report.
>
>
>
>
>
> Travis Late
>
> ERP Project Manager
>
> M-B Companies, Inc
>
> 1200 Park Street
>
> Chilton, WI 53014
>
> Phone: 920-898-1560 Ext.152
>
> Cell: 920-960-0062
>
> Email: tlate@... <mailto:tlate@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]

system · January 15, 2010, 9:46am

Hello,

I have a user who cannot preview or print a Crystal report that is connected via ODBC. ODBC is working because report parameter queries are firing, but once he clicks OK Crystal says it cannot find the report tables. I can see the xml files being generated in a temp folder on his client laptop and he does have permissions to the folder. He is the only user experiencing this problem. I don't think it is a Vantage issue, because Crystal forms work fine and other users are not experiencing this problem. Has anyone else come across this problem and have a solution? We are running 406A on Progress.

Thanks,
David Pfiester
Nustep, Inc.
dpfiester@...

system · March 22, 2013, 3:07pm

Ver 8.03.403

I have a Crystal/BAQ report that combines data from the BAQ with data from an ODBC query of the database (Thank you, idiot database analyst who combined all the sales reps on an order into one field). The report runs just fine when I run it, but when another user tries to run it, it errors out with "Failed to open the connection". I have the same ODBC connection setup on the user's PC as mine, so I don't understand why it fails there, but not on mine. Any thoughts?

THOM ROSE
Controller

[cid:FD06E4C7-D1D5-4E4C-90A4-4F7835B00062]<http://www.electricmirror.com/products/options/diamond_clear.html>

T +1 425 776 4946
F +1 425 491 8200
A 11831 Beverly Park Road Building D, Everett, WA 98204 USA

electricmirror.com
twitter.com/electricmirror
facebook.com/electricmirror

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use ordissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that mightaffect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use.

[Non-text portions of this message have been removed]

system · March 22, 2013, 3:10pm

I had the same issue with a few reports. I found that Crystal was set to Save Data With Report under File > Report Options and File > Options. Make sure the boxes are not checked.
If that doesn't work check any stored procedures to make sure they are running correctly.

--- In vantage@yahoogroups.com, Thomas Rose <t.rose@...> wrote:
>
> Ver 8.03.403
>
> I have a Crystal/BAQ report that combines data from the BAQ with data from an ODBC query of the database (Thank you, idiot database analyst who combined all the sales reps on an order into one field). The report runs just fine when I run it, but when another user tries to run it, it errors out with "Failed to open the connection". I have the same ODBC connection setup on the user's PC as mine, so I don't understand why it fails there, but not on mine. Any thoughts?
>
> THOM ROSE
> Controller
>
> [cid:FD06E4C7-D1D5-4E4C-90A4-4F7835B00062]<http://www.electricmirror.com/products/options/diamond_clear.html>
>
> T +1 425 776 4946
> F +1 425 491 8200
> A 11831 Beverly Park Road Building D, Everett, WA 98204 USA
>
> electricmirror.com
> twitter.com/electricmirror
> facebook.com/electricmirror
>
> Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use ordissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that mightaffect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use.
>
>
>
> [Non-text portions of this message have been removed]
>