Two record set ,use in crystal report.

[Former Member]

Hi ,

I have a store procedure .It has two query (Two record set).Can I use thsese two record set in Crystal Report XI R2 ?. I am using ODBC connection. Please let me know.

Thanks in advance.

Manjunath N jogin

[Former Member · Accepted solution]

possibly,

have you looked at writing your own commands?

in database expert use the Add Command node

dom

[Former Member · Accepted solution]

Hi,

dom : Thanks for suggestion. How I can use the store procedure in Command node.Please let me know.

I am using a strored procedure.It has two query(two result set).I can see only one record set in crystal report. How I can use two record set in crystal report. I am using ODBC connection. Please let me know.

Thanks

Manjunath N Jogin

[Former Member · Accepted solution]

The options are, I believe,

as opposed to using database tables you can simply use a stored procedure. Make sure the stored procedure option is available.

File - Options - Database tab - check Stored Procedure in the data explorer area.

Then, back in Database Expert, the option to include stored procedures should be available alonside using tables.

Or/and,

you may have to utilise Commands. In Database Expert by clicking 'Add Command' you can write SQL directly here. This may prove useful if you've got two different datasources but want to use them both in your report.

Hope this is of some use,

Dom

[Former Member · Accepted solution]

Hi ,

Dom: Thanks

I can use store procedure in Crystal Report.

I have a store procedure "SP_Customer_Detail".

I am doing some business logic in SP. Finally I will get two queries for example as below.

1) Select Cust_Name ,Cust_PANNo from Tbl_Customer

2) Select Inv_No,Item_Name,Rate ,Qty from Tbl_Customer a,Tbl_Sales_Detail b

Where a.Cust_ID=b.Cust_ID

In this case ,how I can use these two queries in crystal report(Add command). I am using ODBC connection.Please let me know.

Thanks,

Manjunath N Jogin

[Former Member · Accepted solution]

Not too sure what you're after exactly....

create a Command for each of your two queries?

Therefore, one command will return Cust_Name ,Cust_PANNo and the other Inv_No,Item_Name,Rate ,Qty.

And join the two commands via a common field (Cust_ID?).

If i'm barking up the wrong tree, would you please clarify exactly what you're after.

Dom