Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008

    Unanswered: Stored procedure in crystals

    Hi All,

    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.

    I am using crystal report XI.

    Please guide.

    Thanks and Regards,
    S. Vignesh

  2. #2
    Join Date
    May 2003
    From memory is it that the Add Command function does not recognise the wildcard *. It may be worth trying it naming the fields you need in your SQL.

  3. #3
    Join Date
    Feb 2008

    SP in crystal

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts