Last post May 31, 2014 07:20 AM by Ajay2707
May 20, 2014 01:01 PM|aspfun|LINK
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?
May 23, 2014 05:51 AM|itityagi|LINK
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.
May 31, 2014 07:20 AM|Ajay2707|LINK
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.
Eigher if table are link , then with join and where condition you make a single output table for all this 3 or more tables.
you can directly access tables in crystal report side and filter the data in
"Report Selection formula", simple.
No other way.