SSRS: Is it possible to combine reports?

I have not had a chance to try this, but I would place a sub-report at the end of the main report. All you have to do is make sure you pass the parameters to the sub-report from the main report.

The reason for the First(Fields!VendorID ... is because your subreport is not located inside a table and the dataset can potentially return more than one record.  If you want your subreports to get rendered for each record in the POOR_Matrix dataset then you need to nest it inside a Table.  And you can then just pass the VendorID field into the parameter, without the First().

Hello:

I really do appreciate all of the responses.  But, I am extremely lost.

I want to combine two matrices into one report.  How do I do that?

Do the matrices go into subreports and, if so, how?

Which one would be considered the main report?

I need answers to these questions and specific instructions, so I can understand what I need to do.

Thanks!

TBSupport

The main report and the sub-report are really two standalone reports.

You make the  first report (or main report) with all the correct answers in it that you  are looking for.
The sub-report you do the same thing. Run it by itself and produce the answers that you are looking for.
Then in the main report you add the sub-report
(You will find this in the properties window of the report and the parameters listed to be passed to the sub-report)
So what basically happens is the main report runs and passes any parameter info to the sub report for it to run.

I want to combine two matrices into one report.  How do I do that?

You don't need to use subreports for such a scenario.  A report can have multiple Tables and Matrices.  Just drag them from the Toolbox into the design.

Hello:

Following ValentinoV's suggestion, if I place my two matrices into one report, will SSRS allow me to pass the parameter from the first matrix into the second?  If so, how?

I need for the matrices in the one report to "work together", in that sense.

Thanks!  Much appreciated!!!

TBSupport

Can you explain in some more detail how exactly the matrices need to work together?  A simple example can help to clarify this.

If needed, a subreport can be nested inside a matrix and this also allows you to pass any of the values from the matrix's dataset into the subreport through parameters.

Alternatively, you can use the lookup functions to look up data from another dataset.  More on that here: Looking Up Data On Different Sources

Hello:

I tried all of the suggestions and nothing worked.  

I have two matrices in two separate .rdl files.  Each has a similar parameter, Vendor ID.

I want to take each of these matrices and place them on the same report.  When the parameter is chosen, I want both reports to run upon clicking "View Report".

That's the best that I know how to explain it.

TBSupport