Originally Said By: Jason Byrnes
your recordset is not working on the detail page, because you are missing the where clause that will limit the results returned to only include those related to the URL variable. 
Hi Jason, that's where I was going wrong I think, the where clause was above the union query so it filtered the details correctly but not the sums. Creating a 2nd identical where under union works in phpmyadmin but it seems I cant reuse parameters in DW?
If I create an identical parameter and use that in 2nd where it errors telling me it cant find field!
Code below works
Select
ghl_portal.tblcontacts.ContactFullName As Name,
Count(ghl_portal.tblcases.CaseID)As Cases,
Sum(ghl_portal.tblcases.CaseCommission) As Commission
From
ghl_portal.tblcontacts Inner Join
ghl_portal.tblcases On tblcontacts.ContactID =
ghl_portal.tblcases.ContactAssignedTo
WHERE ghl_portal.tblcontacts.ContactFullName = 'Barry'
Group By
ghl_portal.tblcontacts.ContactFullName
UNION ALL
Select
'GRAND-TOTAL',
Count(tblcases.CaseID),
Sum(tblcases.CaseCommission)
From
ghl_portal.tblcontacts Inner Join
ghl_portal.tblcases On ghl_portal.tblcontacts.ContactID =
ghl_portal.tblcases.ContactAssignedTo
WHERE ghl_portal.tblcontacts.ContactFullName = 'Barry'
But using DW Parameter twice doesn't, do you know if that's normal?
