Asked by:
Print multiple data in RDLC

Question
-
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 imageImage1: OpenTrenching
https://i.stack.imgur.com/J38rC.png
Image2: HDD
https://i.stack.imgur.com/1CjDb.jpg
Fetching data is not a problem, I can manage thatThe thing is:The data of the 2 tables is based on the Job No (which is not fixed, its dynamic), meansThe job no may start from table 1 or table 2 likeJob1 : Table1Job2: Table2Job3: Table2Job4: Table1Job5: 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.- Moved by Wendy ZangMicrosoft contingent staff Wednesday, November 8, 2017 5:34 AM
Wednesday, October 18, 2017 2:15 PM
All replies
-
Hello Devendra007,
Base on your description ,The Job data may store in multi tables .I'm not sure which table the workOrderNo element come from. Please share more details about you table structure.
If you data table structure as below.
table1.
table2.
In this case,you could use sql select statement, the Union statement combine two table into a table that contains all job_data element , add where conditions and use order by clauses.
Sincerely,
Neil Hu
Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.Thursday, October 19, 2017 10:36 AM -
Thanks Neil for your reply
As both the tables is having different structure, so I can't use Union in this case.
The image enclosed is to be printed, so I thought of RDLC, that will do this work but as the tables is having different columns and the design pattern is also differ (as shown in enclosed image), I can't figure out the solution to show that.
The above tables is based on Job no, which needs to be determined at runtime and designed it accordingly.
Friday, October 20, 2017 9:34 AM -
Hello Devendra007,
I'm sorry that I'm not too familiar with RDLC report,but you could find a suitable forum for professional support.There are some options for you.
https://forums.asp.net/t/1942202.aspx?RDLC+forum+
If you have some grammar or code errors in using C#, please feel free to contact us. We will try our best to give you a solution .
Sincerely,
Neil Hu
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.Friday, October 20, 2017 11:21 AM