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,
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
0
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
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
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.
Can you provide me any example ? I have grouped it by EmployeeName but it is still showing data like this.
0
Hello Muhammad,
An example can be found in the Hide duplicates in a column blog post.
Regards,
Nasko
Progress Telerik
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