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

Grouping and Tables, I'm not getting it

2 Answers 27 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Brett
Top achievements
Rank 1
Brett asked on 20 Dec 2012, 02:22 PM
Hi,

I've seen permutations of this question come up but I haven't seen a response that has clicked for me.  I have a datasource in my report that returns data with these columns:

emp_id, fname, lname, client_name, carrier_plan_title, effective_date, client_cost_pay_freq
1, Jon, Smith, Acme Group, HMO, 01/01/2012, 400.00
1, Jon, Smith, Acme Group, Dental, 01/01/2012, 200.00
2, Lindsey, Buckingham, Acme Group, PPO, 03/01/2012, 150.00

What I'm trying do is group the information by the 'emp_id' column and then within the details section of the report, display a table that outputs the carrier_plan_title, effective_date and client_cost_pay_freq per employee.  I have figured out how to group by emp_id, but haven't figured out how to display each individual carrier_plan_title, effective_date and client_cost_pay_freq per employee.  I don't think I'm quite getting how the group and details sections and tables actually work.  attached is a screen shot of what I have.

Brett

2 Answers, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 26 Dec 2012, 02:14 PM
Hi Brett,

You scenario is very much like the one in our Product Catalog demo. The key to this is that you don't use the DetailSection because the DataObject in the DetailSection data-context is just one item as you will have one DetailSection for each record. Instead, you should put the table inside the GroupHeader. In the GroupHeader data-context, the DataObject is all the data that meets the current group criteria (in your case all rows that have the same emp_id). 
 
Kind regards,
Elian
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Brett
Top achievements
Rank 1
answered on 26 Dec 2012, 03:52 PM
Thanks.  That works.
Tags
General Discussions
Asked by
Brett
Top achievements
Rank 1
Answers by
Elian
Telerik team
Brett
Top achievements
Rank 1
Share this question
or