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.

Amit Gupta · Answer

Well it is not possible to do the whole code but you can try the below steps to achieve your task. Please read the steps carefully 1. Take a list control. 2. Inside that control drag 2 rectangles ( 1 for your first format and another for your second format) 3. Inside first rectangle take a table remove the grouping section only and design your format as required. 4. Repeat step3 to design your second format. 5. Now the tricky part make visibility to expression and apply your logic according to your job no to show/hide it according to your needs 6. Thats it. Do try and let me know if it works

Amit Gupta · Answer

As list control is a dynamic binding so table cannot be have grouping on that it should be static fields. So you have to use it without grouping.

Devendra Kumar · Answer

Sir can't I use the table as normally thats fill the entire data when fetching from the database?

Devendra Kumar · Answer

Amit sir thank you so much for your answer  it works great.. thanks a lot once again.

Devendra Kumar · Answer

Yes Amit sir. Please tell me how to do that as I completely stuck to achieve this.

Amit Gupta · Answer

Hey If I understood your question property you are asking that your design format should be displayed according to job no? If it was like that then you can use List control from the toolbox to design.