Skip to Content
avatar image
Former Member

Data is showing incorrect in report

Hi All - We have issue with report data is showing correctly from the Oracle Function in TOAD SQL tool for Oracle but not in Crystal Reports designer or BOE. We are using SAP Crystal Server 2013(BI 4.1 SP2). Please see attached screen print. As you can see attached screen print only 4 rows are displayed with correct data from second row onwards and rest is displayed as zeros. When i run query underlying this report from Toad for Oracle query tool it is showing correct data. Any input  to resolve this issue is appreciated. Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 03, 2015 at 03:19 PM

    What type of data connection are you using to the Oracle database - ODBC, OleDB, or Native Oracle?

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

    • So you're returning a record or a cursor from the function?  Crystal won't work with that.  It will only work with single values returned from a stored function.  So, you would have to run a stored procedure to get a cursor.  In order to do that, unlike SQL Server, which is probably where you got the example from, Oracle requires that you have an In Out parameter of type refcursor to a stored procedure in order to get data into the report.  You'll also have to change the connection to Native Oracle.

      -Dell

  • avatar image
    Former Member
    Aug 03, 2015 at 08:35 PM

    if you have already Existing Reports then check with the

    which connection they are Using i have same Problem

    i had used the JDBC Connetion.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The ODBC connection does produce the correct results in Crystal Reports but the Native Oracle does not. We are using Native Oracle because the application calling this report uses JDBC.