multiple datatables passed to one report?

Is it possible to pass multiple datatables to one report (within one dataset)?

My stored procedure would have two or more select statements.

Only one resultset is supported.

You could add a parameter to the stored procedure (or write a wrapper). The parameter determines which resultset is returned. You would then define multiple datasets in the RS report and call the stored procedure with different parameter values.

-- Robert

|||

Thanks, I guess I need to research multiple datasets in the report. I imagine there is a custom assembly involved?

|||

Using multiple datasets in a report has nothing to do with custom assemblies.

Multiple datasets just means you need to have multiple data regions (list, table, matrix, chart) in the report to show the data.

-- Robert