SSRS RDL with multiple reference table group

See more:

RDL

SSRS-2008

1. Having a grid with n rows and n number of columns
2. Each row having reference to different table
3. If the first row having value it should bring the value from table 1
4. If the second row is having value it should bring the value from table 2
Conditions
5. We don’t know how many rows returned in step 1 Grid
6. We should bring the value of table2 or table 1 detail for grid corresponding row type
7. Table 1 and table2 having different field name and different number of column
8. All this need to be done in SSRS

Thanks,
Muthu