reporting-servicesssrs-2012reportbuilder3.0

Alternating Tables

I have three tables and each table has its own dataset:

Table A - Dataset A
Table B - Dataset B
Table C - Dataset C

When running the report I get this:

Table A
Table A
Table A
...

Table B
Table B
Table B
...

Table C
Table C
Table C
...

First all the Data of table A is displayed, then table B, then table C. What I want to achieve is that the tables are alternating. It should look like this:

Table A
Table B
Table C
Table A
Table B
Table C
...

Unfortunatly it is not possible to join these three tables via SQL and I want to avoid to use the lookupset-expression, because then all the data would be displayed in one single cell and not in rows and that looks badly. Or is there a way to generate an new row via expression, similar to Environment.NewLine?

Solution

  • I think the best would be to use subreports for the other 2 tables. I assume there some sort of way to associate the planets to the moons that would be used for the parameters. Then add extra add extra Row in Group for the Moon subreport.

    The solution proposed by Hannover First works fine. Working with Sub-Reports solves my problem.

    Thanks.