This is a migrated thread and some comments may be shown as answers.

Grouping 2 tables in Designer

3 Answers 156 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Muhammad
Top achievements
Rank 1
Muhammad asked on 20 Feb 2018, 01:41 PM
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,

3 Answers, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 26 Feb 2018, 09:12 AM
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
0
Muhammad
Top achievements
Rank 1
answered on 26 Feb 2018, 11:33 AM
Hello Nasko,

Can you provide me any example ? I have grouped it by EmployeeName but it is still showing data like this.
0
Nasko
Telerik team
answered on 01 Mar 2018, 12:46 PM
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
Tags
Report Designer (standalone)
Asked by
Muhammad
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Muhammad
Top achievements
Rank 1
Share this question
or