I am also trying to find a similiar solution. I have one dataset that returns multiple rows of people. My other datasets have multiple rows for each row in the first dataset that can be 'linked' via a person_id column that exists in both datasets. For
example, one of my other datasets queries a table of phone numbers for each individual in dataset 1. So the end result would be a report page that displays a person with their basic information (i.e. address, marital status, birthdate, etc) as well as multiple
phone numbers and other many to 1 type of results for that individual.
I have not found an 'easy' solution to this yet. Most of my research has indicated the best way to handle this, if possible, is via creating a new view or stored procedure that returns a result set that you can use as one dataset and then use grouping
to show the results they way you want. Another way that I am seeing is to use sub-reports but it seems to be the most complicated and resource hungry solution.
Did you find an easier way to do this?
Here are some links that helped me come to my conclusion thus far:
edrstone
Member
4 Points
13 Posts
Re: report with multiple datasets
Apr 30, 2009 12:12 PM|LINK
Hi Zenuke,
I am also trying to find a similiar solution. I have one dataset that returns multiple rows of people. My other datasets have multiple rows for each row in the first dataset that can be 'linked' via a person_id column that exists in both datasets. For example, one of my other datasets queries a table of phone numbers for each individual in dataset 1. So the end result would be a report page that displays a person with their basic information (i.e. address, marital status, birthdate, etc) as well as multiple phone numbers and other many to 1 type of results for that individual.
I have not found an 'easy' solution to this yet. Most of my research has indicated the best way to handle this, if possible, is via creating a new view or stored procedure that returns a result set that you can use as one dataset and then use grouping to show the results they way you want. Another way that I am seeing is to use sub-reports but it seems to be the most complicated and resource hungry solution.
Did you find an easier way to do this?
Here are some links that helped me come to my conclusion thus far:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ab379738-7e34-47d8-b756-90802f850c37/ (specifically bullet 5)
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fe90b59b-9c8b-40d0-a12e-5846e592215b/
Regards,
edrstone