Skip to Content

SAP Crystal report not showing Data even stored procedure return data

Feb 22, 2017 at 09:05 AM


avatar image
Former Member


I'm creating one report using SAP Crystal Report 2013 and stored procedure of Oracle Database. SP has 4 parameter and one parameter 'Year' as string .

- if we provide year = 2017 then we get data on report

- if we provide year=2016 then we did not get data on report but when we run the stored procedure on database then Stored procedure returns data

To check this issue:

- we have checked the Database->Show SQL Query for both year parameter and it generate same SP call and checked from database it send same parameters from report

- We have created simple report (No record selection, suppress condition ) using that stored procedure and it has same issue

Could you please help me to resolve this issue.

Thank you,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 06, 2017 at 01:13 PM

We have modified stored procedure parameter and crystal reports parameter as date(start date and end date) instead of year as string.

Now report display the data

10 |10000 characters needed characters left characters exceeded