CodeJunky
asked on
RDLC Multiple Dataset creating documents
SSRS rdlc with two dataset. The report prints a main textural record from the first data set. The second data set prints related items to the first dataset as textural data. Basically I'm creating documents. I have two RECTANGLES and assigned the correct dataset to each. Inside each RECTANGLE I have a text box for the text and corresponding column data. This works great if I am filtering on one set of data points; such as one record that relates to other records being in the second dataset.
Dataset1
name address owner
Dataset 2
occupant1
occupant2
etc...
I've been trying to keep them together but am running into problems. I know how to deal with this developing RDL projects with sub reports; but can't seem to get that working correctly with RDLC. Is there anyway, given my current approach to group these correctly and print one record per page regardless of the grouping as well?
Dataset1
name address owner
Dataset 2
occupant1
occupant2
etc...
I've been trying to keep them together but am running into problems. I know how to deal with this developing RDL projects with sub reports; but can't seem to get that working correctly with RDLC. Is there anyway, given my current approach to group these correctly and print one record per page regardless of the grouping as well?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I cannot use a parameter in the MAIN dataset. (This is a unique situation where the report is passed onto a 3rd party product that uses it's own dataset at runtime)
I tried adding one to the sub report and connect that to the MAIN dataset via a unique column, that relates to the sub and main.
Not working.
Severity Code Description Project File Line Suppression State
Error BC30455 Argument not specified for parameter 'TENANT_ID' of 'Public Overridable Overloads Function Fill(dataTable As dsMAIN.OCCUPANTDataTable, TENANT_ID As Decimal) As Integer'. \Form1.vb 7 Active
I tried adding one to the sub report and connect that to the MAIN dataset via a unique column, that relates to the sub and main.
Not working.
Severity Code Description Project File Line Suppression State
Error BC30455 Argument not specified for parameter 'TENANT_ID' of 'Public Overridable Overloads Function Fill(dataTable As dsMAIN.OCCUPANTDataTable, TENANT_ID As Decimal) As Integer'. \Form1.vb 7 Active
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kindly follow the step by step guide to configure subreports and see whether it helps out or not..
http://ssrstutorials.blogspot.com/2012/10/lesson-17-ssrs-subreports.html