Section to repeat across pages

[Rajesh Kumar]

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

 

[Ivan Hristov]

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