Hello! I am hoping someone can help me with this - I am quite certain it can be done, I just haven't run across this particular kind of report request yet!
I have 2 datasets that are tied together by their unit_id. In table 1 you have basic yes/no info about specific types of pension plans offered by a company and a bit field called bridgePlan. If this field (bridgePlan) is true, there will be corresponding records in table 2 that gives details of the bridge plans.
The task in front of me seems quite simple, but I haven't worked it out. In the first tablix I need to display the basic info from Table 1 (dataset1). No problem, I've done this many times. After that, however, I need to display one (or several) more tables with the information from Table 2 (dataset2). There is no limit on how many records in Table2 that actually correspond. It is unlikely that it will ever be more than 5, so I want to bank on 10 just to cover my bases.
unit_id, year, bridgePlan
ppid, unit_id, year, bridgetPlan/ppinfo
Thoughts on how I should approach this? Should I simply try to concatenate all of the information for a specific unit into one long record so that there is only one record returned for each unit/year? I am going to attach a word document that shows the tablix layout requirement given to me. Essentially, the top tablix will always be visible. The bottom one would be visible if bridgetPlan = true for a particular unit/year and it should cycle through each record from dataset 2 .. so it could be there multiple times but with different information.
Thank you in advance for your help.