Grouping 2 tables in Designer

4 posts, 0 answers
  1. Muhammad
    Muhammad avatar
    23 posts
    Member since:
    Oct 2017

    Posted 20 Feb Link to this post

    Hello everyone.

    Is it possible to use 2 tables in report and display records in them ?
    I have been trying from past 1 week but can't figure out a way to get the desired output. I have three tables name Addition/Deduction/Leave and master table Employee.
    I am trying to get the report that which employee have got what addition or deductions and how many days he/she have been absent. I am using joins in query an the output is repeating for multiple times for one row which is fine.
    But I don't want that row to be repeated in the report. Is there any way possible to fix this ? I'm attaching snap here I'm not sure if I can attach files for designer and code to database as well. Please have a look and help me as soon as possible. I've posted this question 2 times before too but got no response.

    Regards,
  2. Nasko
    Admin
    Nasko avatar
    1021 posts

    Posted 26 Feb Link to this post

    Hi Muhammad,

    With Table layout this is the expected behavior. You can remove the repeating column from the table item and display this information inside a Group Header section of the report. This way the item will display only once. More information can be found in the following help articles:

    Grouping Data
    Edit Grouping Dialog
    Report Structure

    Regards,
    Nasko
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. Muhammad
    Muhammad avatar
    23 posts
    Member since:
    Oct 2017

    Posted 26 Feb in reply to Nasko Link to this post

    Hello Nasko,

    Can you provide me any example ? I have grouped it by EmployeeName but it is still showing data like this.
  4. Nasko
    Admin
    Nasko avatar
    1021 posts

    Posted 01 Mar Link to this post

    Hello Muhammad,

    An example can be found in the Hide duplicates in a column blog post.

    Regards,
    Nasko
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top