Grouping by Person by Date with a summary

[MiagiSan]

Hello,

I am using CR 10 and I am trying to create a report with the following information:

datatable.person_name
datatable.date

*If datatable.ticket_comp = Y then there is a completed ticket.

I am trying to group data in the following way.

Person 1 2005-10-10 75 (tickets)
Person 2 2005-10-10 45
Person 1 2005-10-11 85

The grouping function works well when grouping by name or by date but I am having trouble when I try to group by both. It gives me this:

Person 1 - 2005-10-10
Person 1 - 2005-10-10
Person 1 - 2005-10-10
Person 1 - 2005-10-10
Person 1 - 2005-10-10
Person 2 2005-10-10
Person 2 2005-10-10
Person 2 2005-10-10
Person 2 2005-10-10
and so on...

Any assistance would be appreciated.

Regards,

R

 

[lbass]

Insert a group on date and then on name and then place a formula in the detail section:

if {data_table.ticket_comp} = "Yes" then1

Right click on the formula and insert a sum on this formula at the name group level. Then drag the two group names into the name group footer and suppress the detail section.

-LB

 

[MiagiSan]

Perfect....Thank you!!