1 * bxfcLDMXT-Odbc Error occurs while opening a CR 6.0 report in the Preview window 
Author Message
 1 * bxfcLDMXT-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



Wed, 06 Dec 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. 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. CR 6.0 with ODBC Time-out-error

5. New to CR - Report files won't open (w/ VB5)

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

7. CR 6.0 preview form

8. BIG urgent problem: Printing from the CR preview under Win NT 4

9. Vb5 error when open CR 4.61 report

10. VB5 error when open CR 4.61 report

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

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

 

 
Powered by phpBB® Forum Software