I want to use multiple Select Statement (for eg: 2 select query) in a single command of single crystal report file. how to use it.

 

eg: select * from dept;

select * from emp;

 

Thanks in advance. Urgent Req.

 

 

   Once again i'll explain the req.

1. I've created an SP which contains 2 queries like as follows.

    Select * from dept;

    Select * from emp;

2. Execute the SP in Sql server, we'll get the following results

    4 rows (from first query)

    20 rows (from second query)

3. Here we are getting all the columns & Rows from first and second query.

4. But if we use the same SP in Crystal report, we are getting only one querie's columns. Not getting both queries column.

 

How to solve this issue or give me some suggestions

 

Thanks in Advance