Need help with Task list/Category livereport

David_Beliveau_(sanmin013_-_(deleted))

Hello,We have a task list with a category applied to it. The category contains 10 mandatory attribute fields. When I run the sql below, I get the same task listed 11 times (once for each attribute value plus the category title) rather than a single row for each task with all 10 attributes listed in their own column. Any idea how to accomplish this? We use MSSQL..select DTree.*, LLAttrData.Valstr, KUAF.Name as kuafname, (CASE DTree.status When 0 Then 'Pending' When 1 Then 'In Process' When 2 Then 'Issue' When 3 Then 'On Hold' When -1 Then 'Completed' When -2 Then 'Cancelled' Else 'Unknown' End) as mystatus from DTree, LLAttrData, KUAF where SubType=206 and KUAF.ID=DTree.Assignedto and %1 and((DTree.Status=0) or (DTree.Status=1) or (DTree.Status=2) or (DTree.Status=3) or (Dtree.Status=-1) or (Dtree.Status=-2)) and (DTree.OwnerID=1279597) and DTree.Dataid=LLAttrData.ID and LLAttrData.DefID=1279610 order by DTree.Priority DESC, DTree.DateDue%1=filter permissions.Thanks,Dave BeliveauSanmina-SCI