Print multiple data in RDLC

Devendra Kumar

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted 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 Gupta9y ago
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 Kumar9y ago
Sir, can't I use the table as normally thats fill the entire data when fetching from the database?
Devendra Kumar9y ago
Amit sir, thank you so much for your answer , it works great.. thanks a lot once again.
Devendra Kumar9y ago
Yes Amit sir. Please tell me how to do that, as I completely stuck to achieve this.
Amit Gupta9y ago
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.