Two record set ,use in crystal report.
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
Dom Horton 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.