I am trying to create a report where each Item I am reporting on has data that is spread across two different sets of data that don't relate in anyway except for the one key field.
I'll try to explain the layout here.
1st: there is the main data for each item which consists of a single row from the database with X number of columns. There can be X number of items returned from the SP for this dataset
2nd: there is finacial data for each item that consists of multiple rows of data for each item. Each row is a specific type of data. This comes from a seperate SP
The only linking factor is a column called 'ref_num'
I am trying to figure out the easiest way to get these sets of data into a report. My first approach was a single RDLC with a list that would put the data from #1 into boxes. In the list there was a subreport that send the current Ref_num as a parameter
to the sub report. the sub report showed the data from #2 based on that paramter.
So each page on the report would do show this. I am trying to find a way to do this without the subreport and hopefully do this in a more dynamic way where I can use .NET to place the items into the report and not have to pre-define the fields in the report.
So far I don't get how I can get these 2 sets of almost unrelated data to show up on the same page of the report without that sub report to load the data.
Zenuke
Member
217 Points
296 Posts
report with multiple datasets
Apr 02, 2009 06:03 PM|LINK
Hopefully I explain this correctly.
I am trying to create a report where each Item I am reporting on has data that is spread across two different sets of data that don't relate in anyway except for the one key field.
I'll try to explain the layout here.
1st: there is the main data for each item which consists of a single row from the database with X number of columns. There can be X number of items returned from the SP for this dataset
2nd: there is finacial data for each item that consists of multiple rows of data for each item. Each row is a specific type of data. This comes from a seperate SP
The only linking factor is a column called 'ref_num'
I am trying to figure out the easiest way to get these sets of data into a report. My first approach was a single RDLC with a list that would put the data from #1 into boxes. In the list there was a subreport that send the current Ref_num as a parameter to the sub report. the sub report showed the data from #2 based on that paramter.
So each page on the report would do show this. I am trying to find a way to do this without the subreport and hopefully do this in a more dynamic way where I can use .NET to place the items into the report and not have to pre-define the fields in the report. So far I don't get how I can get these 2 sets of almost unrelated data to show up on the same page of the report without that sub report to load the data.