I want to design a report in which it will contain fields derived from 2 different stored procedures. I understand a 'table' can display data from a single dataset. How can i bind these two stored procedures into a single dataset so as when i click on the table and use its property 'DataSetName', to be able to select the dataset which holds all columns from stored proc 1 and stored proc 2. How can i link multible tables ( multible stored procedures with different column names in each one) into a single dataset to feed the report?
Thank you
George
Hey George.
That is true about a table only being able to access a single dataset, so you will have to combine those 2 datasets somehow. Here are a couple of ways:
1. Write a 'wrapper' Sproc that gets you what you need
2. In the dataset itself combine the output of the Sprocs (probably not viable as I am sure you want to join somehow)
3. Change the Sprocs to UDFs and join them in your dataset.
Good luck,
Mike
No comments:
Post a Comment