Data is showing incorrect in report

[Former Member]

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

[former_member202170]

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.

[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.

[DellSC]

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

-Dell

[Former Member]

Thanks for your response.It is ODBC connection to the Oracel database,i tried native Oracle still the same results.

[DellSC]

Oracle ODBC is notorious for not running stored procedures correctly, so there might also be an issue with stored functions.

What is the return data type from the function?

-Dell

[Former Member]

it is combination of numbers and Varchar2's

[DellSC]

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