In Telerik Report Designer y
ou can achieve the result by using Filter rule in the report. Check these help articles about Filtering Data
and Adding filters to Report using Report Designer
Basically you have to add two nested tables
- the parent table
need to contents the data from Company details data and the child table
- Employee details data. Using Table Wizard
will help you connecting to DataSource, arrange Fields, choose Layout and custom Style of the table. After creating the parent table, add new row below with option
Inside Group - Below
and use the option Merge cells.
In this row add new Table Wizard with child data.
Select nested table and click Filters in properties grid. Add new Filter, In Expression
select CompanyName field, and in Value
type = ReportItem.DataObject.CompanyName
On Preview mode you can see the filtered results.
You can find attachment of sample report with CSV data below. Additionally you can check the following how-to article
that explains the process in details.
We hope the provided approach would work for the described scenario.
Let us know if you need any further questions.
Thank you for contacting us.
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?
Telerik Feedback Portal
and vote to affect the priority of the items