Skip to Content
avatar image
Former Member

SAP Crystal report not showing Data even stored procedure return data

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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

    Add comment
    10|10000 characters needed characters exceeded