Hi
Thanks very much for your help. I tried INNER JOIN ON serviceappointmentregardingobjectid = (CRM_FilteredIncident.incidentid and serviceappointment.serviceidname = Maintenance) and the results returned only the cases associated with service activities that are associated with the service type Maintenance.
This is excellent. Thanks so much for the bit of guidance that I needed. I just have one problem with my report.
I need to display all cases and not only the cases associated with service activities associated with the service type Maintenance.
So my report should show all cases and only service activities associated with service type Maintenance.
Some I am half way to joining the tables correctly.Any suggestions would be greatly appreciated. I just need to make one last change.
Thanks again
Mark
Hi
I tried Left OUTER JOIN and now all cases are returned however for some reason a service activity is created for each case even if the service type equals Maintenance.
I just need assistance with this last bit.
Thanks
Mark