Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Two record set ,use in crystal report.

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question