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

Section to repeat across pages

1 Answer 199 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Rajesh Kumar
Top achievements
Rank 1
Rajesh Kumar asked on 03 Jan 2014, 11:25 AM

Hi,
I'm using Telerik Reporting Q3 2011. I have a requirement where I have to show multiple tables and chart on the report. Each table should have independent data and all the tables will be having one id as the common field. The report should repeat itself for multiple IDs with each ID per page.

To illustrate, assume I want to show employee information
Table 1 -> will have employee details (name, age, etc..)
Table 2 -> will have multiple rows of employee achievements
Table 3 -> will have multiple rows of employee skills
Table 4 -> will have mutiple rows of employee qualification
Chart 1 -> will have trend of employee attendance every month
All the above should be displayed in one page for each employee (Employee Id will be the primary key). Each page should have one employee information.

How can this be accomplished using Telerik reporting? Is there any controls that I can use to achive the above functionality? Please help.

--Rajesh

 

1 Answer, 1 is accepted

Sort by
0
Ivan Hristov
Telerik team
answered on 08 Jan 2014, 12:00 PM
Hello Rajesh Kumar,

In your case the best option is to use nested data items. You can show your data in a table, grouped by EmployeeId and nest additional data items in the Details section.
Since the data for the nested data items will be fetched from another data source, you need to pass the current EmployeeId value as a parameter. This can be done using the ReportItem.DataObject property, as explained in this documentation article.

Please take a look at the attached .trdx report definition that demonstrates the above approach. It uses data from the sample database AdventureWorks, so you might have to edit the connection strings to make it work.

Hope it helps.

Regards,
Ivan Hristov
Telerik

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

Tags
General Discussions
Asked by
Rajesh Kumar
Top achievements
Rank 1
Answers by
Ivan Hristov
Telerik team
Share this question
or