locked
CR using store procedure RRS feed

  • Question

  • User546194788 posted

    There is a store procedure in which there are more "select ...from..." statements, such as

    select * from order

    select * from customer

    select * from vendor

    ....

    Is it possible to create a crystal report based on this kind of store procedure?

    Tuesday, May 20, 2014 1:01 PM

All replies

  • User1243880387 posted

    Do these tables are linked? You can use join for these stored procedures, but if number of columns may vary then its better to use sub report to show data from various tables.

    Friday, May 23, 2014 5:51 AM
  • User-578610739 posted

    Hi Dear,

    No need to make sp for this.

    If there is no link between this table and just want to get the data via sp, good to use direct table in crystal report.

    Also crystal report does not support multiple recordset in sp.

    http://scn.sap.com/thread/1851125

    http://scn.sap.com/thread/1076902

    Eigher if table are link , then with join and where condition you make a single output table for all this 3 or more tables.

    or

    you can directly access tables in crystal report side and filter the data in "Report Selection formula", simple.

    No other way.

    Saturday, May 31, 2014 7:20 AM