Odbc Error occurs while opening a CR 6.0 report in the Preview window 
Author Message
 Odbc Error occurs while opening a CR 6.0 report in the Preview window

Hi There!

        While trying to opening a report in the preview window the following
messagebox appears:

                "ODBC Error(Oracle)(ODBC Oracle Driver)Syntax Error"

        which is then followed by :

                "SQL Server Error"

                                                Any suggestions?
                                                                Aidan



Tue, 28 Nov 2000 03:00:00 GMT  
 Odbc Error occurs while opening a CR 6.0 report in the Preview window

it might help if you posted the sql that is contained in the report.

Dan
Bristol, England



Tue, 28 Nov 2000 03:00:00 GMT  
 Odbc Error occurs while opening a CR 6.0 report in the Preview window



Quote:
> it might help if you posted the sql that is contained in the report.

> Dan
> Bristol, England

here it is !!!
SELECT
    SYSTEM."ITEM_DESCR", SYSTEM."ITEM_VALUE_DATE",
    FRAUD_ACCOUNT."BLOCK_DATE",
    CARDHOLDER."TITLE", CARDHOLDER."SURNAME", CARDHOLDER."FULL_NAME",
    THEFT_DETAIL."THEFT_LOCATION",
    ACT_STATUS_HISTORY."ACCOUNT_NO", ACT_STATUS_HISTORY."FROM_STATUS",
ACT_STATUS_HISTORY."TO_STATUS", ACT_STATUS_HISTORY."STATUS_DATE",
    PLASTIC."EXPIRY_DATE"
FROM
    {  "ICSFRDD_SYS"."PLASTIC" PLASTIC LEFT OUTER JOIN
"ICSFRDD_SYS"."FRAUD_ACCOUNT" FRAUD_ACCOUNT LEFT OUTER JOIN
"ICSFRDD_SYS"."THEFT_DETAIL" THEFT_DETAIL ON
        FRAUD_ACCOUNT."ACCOUNT_NO" = THEFT_DETAIL."ACCOUNT_NO" ON
        ACT_STATUS_HISTORY."ACCOUNT_NO" = PLASTIC."ACCOUNT_NO"},
    "ICSFRDD_SYS"."SYSTEM" SYSTEM,
    "ICSFRDD_SYS"."CARDHOLDER" CARDHOLDER
WHERE
    SYSTEM."ITEM_DESCR" <> FRAUD_ACCOUNT."ACCOUNT_STATUS" AND
    FRAUD_ACCOUNT."ACCOUNT_NO" = CARDHOLDER."ACCOUNT_NO" AND
    FRAUD_ACCOUNT."ACCOUNT_NO" = ACT_STATUS_HISTORY."ACCOUNT_NO".

                                                Have fun!
                                                        Aidan



Tue, 28 Nov 2000 03:00:00 GMT  
 Odbc Error occurs while opening a CR 6.0 report in the Preview window

this was copied and pasted straight from the selection criteria ?

Dan



Tue, 28 Nov 2000 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. 1 * bxfcLDMXT-Odbc Error occurs while opening a CR 6.0 report in the Preview window

2. CR 6.0 Report upgraded to CR 7.0 report has formatting issues

3. CR 4.5 Automatition Error when Previewing Report

4. subclass CR preview window called thru CR API

5. CR 6.0 with ODBC Time-out-error

6. Upgraded CR 6.0 Report to CR 7.0 got formatting issues

7. CR 6.0 preview form

8. Vb5 error when open CR 4.61 report

9. VB5 error when open CR 4.61 report

10. No error reported and memory leak if error occurs in Class_Terminate

11. Error occurred while registrating EXPSRV.DLL USING VB 6.0 setup wizard

12. Diary field is truncated when previewing a report (CR 8.5.2.178)

 

 
Powered by phpBB® Forum Software