Skip to Content
author's profile photo Former Member
Former Member

Standard Oracle Query Format in Crystal Report

Hi,

PFA oracle query which i insert into crystal report xi version it give me error like Ora-00904 ITEM.PAYOR_ACCOUNT_NBR invalid identifier but same query is run on oracle client and ITEM.PAYOR_ACCOUNT_NBR this column is in database with same name but it give error in crystal report pls tell me what are the modification should do in query which crystal report will accept

Kind Regards,

Ganesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jan 10, 2014 at 09:26 AM

    From a SQL perspective there doesn't seem to be any issue. Can you remove all references to this column from the query and post the result that is observed from CR XI designer.

    btw: what is the CR version, can you upgrade to CR XI Release 2 highest patch level.

    -Prathamesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2014 at 09:40 AM

    Hi Ganesh,

    1) Try adding a table alias for each of your inline views and also use that alias for referencing the columns.

    2) Try running each of your inline views separately to find out which one is causing the issue.

    3) Upgrade CR XI to CR XI R2 SP6.

    4) Make sure you're using the right database driver.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2014 at 02:57 PM

    Hi Ganesh,

    What Oracle client are you using in CR connection?

    Try one of the other ones:

    Oracle Server in the DB Connection wizard ( native Oracle CR driver )

    Oracles ODBC driver

    Oracle OLE DB Provider

    Or the Data Direct Oracle Clients.

    Do not use Microsoft's Oracle driver, it only supports Oracle 7

    Don

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.