locked
Print multiple data in RDLC RRS feed

  • 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 image
     
    Image1: 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 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. 
    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