This topic is locked

List and count unique entries

6/29/2009 5:18:46 AM
PHPRunner General questions
R
rpain author

I'm using phprunner v4.2
Hi,
I want to set a a system to allow children to be added to activites. Each day has 2 slots and a child can go to the same activity on more than one occasion. I'd like to be able to set up a report for each activity which totals the number in the group and members. At the moment it seems that if a child is in a group on more than one occasion they are listed more than once so the total is wrong. Do I need to use the 'unique' sql option in the query?
Sorry the question's a bit vague but hopefully you get the gist.
Thanks,
Richard

J
Jane 6/30/2009

Richard,
I recommend you to use reports for this purpose.

You can create report on the Datasource tables tab.