Click here to Skip to main content
15,075,806 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

i have create store procedure has 3 select query in sql server 2005.
I Want to get all 3 table values using dataset,and i want to set the values in crystal report, but unlikely i am getting first Query result in showing crystal report.

Please advise ...

how to get all table values from dataset using ?

Otherwise, Pls suggest how can i get all values from SP ?

1 solution

When you are assigning the datasource value to crystal report, instead of assigning it as DataSet, assign as DataTable.

Something like Dataset.Tables[0],Dataset.Tables[1],...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900