I am a fresher in crystal reports.
I have written a stored procedure which internally calls other procedures.
The parent SP is executed using "Add Command" option in crystal report and the query is as follows,
select * from table(<name>);
The above query when executed directly in SQL prompt returns desired output, but when executed via crystal returns no records.
In my report some fields are directly selected in the crystal SP and some fields are selected by calling a package from crystal SP. The issue is that i am not able to fetch the fields from the package.