Grouping and Tables, I'm not getting it

[Brett]

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

[Elian]

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

[Brett]

Thanks.  That works.