I want to use two different record sets in the same report. They will be in their own details section, assuming two details sections can be used.
I've created two data sources in my report project, tested both connections and verified they do return the data I need. I don't understand how to use them though. I expected to see both of them listed in the Date Explorer, but only one is shown there. They both show up at design time in the pane below the report designer though.
Please see the attached file with screen shots. One is of the two data sources in the project while the other shows only one data source in the data explorer.
Can two data sources be used in the same project as described?
How should this be done?