Skip to Content
0

SAP Crystal report not showing Data even stored procedure return data

Feb 22, 2017 at 09:05 AM

49

avatar image

Hi,

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,

Vidhya

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

1 Answer

Vidhya S. Shinde Mar 06, 2017 at 01:13 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded