Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. babayboy

    How to do 2 left outer joins in crystal reports.

    SELECT AR_Credit_Memos."CREDIT_MEMO_AMOUNT", AR_Invoices."SALES_REP_NUMBER", AR_Invoice_Sales_Dist."SALES_ACCOUNT_NUMBER" FROM "AR_Credit_Memos" AR_Credit_Memos LEFT OUTER JOIN "AR_Invoices" AR_Invoices ON AR_Credit_Memos."CUSTOMER_ID" = AR_Invoices."CUSTOMER_ID" AND...
  2. babayboy

    How to do 2 left outer joins in crystal reports.

    I tried to do but iam getting an error saying. ODBC error: non unique table reference: tablename I have 3 tables Invoice, Sales-Dist, Credit_Memos I joined first 2 with left outer joins and again left outer join INvoice and Credit memos. And it gives above error. I tried doing different...
  3. babayboy

    Would like to know

    Here the list of drivers available on my m/c CR ODBC xml driver and all microsfot drivers for oacle , sql, ms access, dbase.
  4. babayboy

    Would like to know

    I know how to add the driver i have following drives in my m/c . Please can any one tell me which driver to select to connect to BusinessWorks using crystal reports. I like to set the path b/b crystal and BusinessWorks(Which Driver gives me). Business Works has datafiles they .mdf files...
  5. babayboy

    Would like to know

    can you tell me what driver is needed ?? name it so that i can install
  6. babayboy

    Would like to know

    It is not clear.. What i want to do is from crystal reports i would like to access businessworks tables, views and generate a report. So how do i conect to businesworks . In crystal i see ODBC but do need a datasource name to connect. How do i create one because there is no driver to connect...
  7. babayboy

    Would like to know

    I have installed crystal reports v10 and wanna connect to businessworks v12 . How do i that.

Part and Inventory Search

Back
Top