I am trying to create a report with multiple data sources so
that I can access various fields in the report. For example, a list or a
crosstab that would display rows of aggregate data derived from different queries. So
far as I can tell, these controls can only be bound to one data source. Moreover,
the report itself can only be bound to one data source. So how do I create a
table, list or crosstab of rows that uses data from several queries?
Sequel Server Report Server (SSRS) supports this by being
able to add multiple data sources to the report and then you are able to drag
fields from which ever on you want into any textbox on the report you wish. See attached:
that I can access various fields in the report. For example, a list or a
crosstab that would display rows of aggregate data derived from different queries. So
far as I can tell, these controls can only be bound to one data source. Moreover,
the report itself can only be bound to one data source. So how do I create a
table, list or crosstab of rows that uses data from several queries?
Sequel Server Report Server (SSRS) supports this by being
able to add multiple data sources to the report and then you are able to drag
fields from which ever on you want into any textbox on the report you wish. See attached: