CiviCRM Community Forums (archive)

I've got the proper code in a new report to select the groups that I want and have the code for the tags, but I can't find how it builds the SELECT statement and am having problems getting it into my custom report.

I'm using the Constituent Report (Summary) for a template, and I can see that the code generates the following SQL
WHERE  contact_civireport.id IN (
                          SELECT DISTINCT cgroup_civireport.contact_id
                          FROM civicrm_group_contact cgroup_civireport
                          WHERE cgroup_civireport.group_id IN (7) AND cgroup_civireport.status = 'Added'
                           )
When I try to copy the portions that I want to my new report, I can't find the specific lines where the SQL statement is created. I've tried a couple of print statements along with grep for "SELECT DISTINCT" for all the report php files, and I'm just missing it.

Any pointers?

Thanks!