Print multiple data in RDLC

Question

Hi

 

I am having 2 tables, first table contains approx 15 columns while the other table contains approx 10 columns, both the data of the tables should be distributed into 21 sections and 3 sections respectively as shown in the below image

 

Image1: OpenTrenching

 

Image2: HDD

 

 Fetching data is not a problem, I can manage that

 

The thing is:

The data of the 2 tables is based on the Job No (which is not fixed, its dynamic), means

The job no may start from table 1 or table 2 like

 

Job1 : Table1

Job2: Table2

Job3: Table2

Job4: Table1

Job5: Table2

..... and so on...

These job no's are based on Work Order No.

 

The above format should be printed in respect of Job no ( which is not fixed), What is the best possible method to achieve this, either in RDLC or any other methodology.

 

Please suggest.