I have a situation where we have six different reports, where they all are basically bringing the data with the similar columns with different values.
The user want to be able to combine all of them into one, yet have each report to show up on a new page. At present the table is tied to a dataset.
My initial thought was to have one table but group it in such a way that for each different group/iteration, i would tie the table to different data source. But I don't think that it is possible from my understanding of other posts in the forum.
What is the best way for me to pull all these 6 different datasets(reports) in one report viewer control? rightnow they can run one report at a time by selecting from dropdown box which will rebind the reportviewer to the report (new data)
except for the binding of different dataset for each report, everything else is same. so it seems pointless to create different report.
Shoul i create six tables each tied to a different dataset?! Please help.