SSRS: Is it possible to combine reports?

Hello:

Attached is a SQL Reporting Services (SSRS) report combining two reports.  When I try to configure parameters for each of these reports, it only allows for the "First" vendor ID.

How can I get each report to use the Vendor ID field, rather than the first Vendor ID field?

Also, if there is a better way of getting two reports together on the same report, I'd love to hear it!  :)

Thanks!

Much appreciated!

TBSupport
POOR-Combined.rdl
LVL 1
TBSupportAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

planoczCommented:
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.
0
ValentinoVBI ConsultantCommented:
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().
0
TBSupportAuthor Commented:
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
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

planoczCommented:
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.
0
ValentinoVBI ConsultantCommented:
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.
0
TBSupportAuthor Commented:
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
0
ValentinoVBI ConsultantCommented:
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
0
TBSupportAuthor Commented:
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
0
ValentinoVBI ConsultantCommented:
You can just put the two matrices on the same report and use the report parameter in the datasets for both matrices.

In other words:

1. make sure your report contains any datasets needed to fetch the data for the matrices
2. copy the matrices that are currently located in your subreports into your main report

That's about it, not sure what else I can say here...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.