I wrote a report and was asked to add another condition to include a different application but it didn't work. Here is the query. I emboldened the addition. When I run it in Excel/Microsoft query several "Loancierge Team Internal" entries were included but none were included in the Crystal Reports report. What needs to be done?
SELECT "persons"."psn_lastname", "clients"."client_id", "cases"."case_id", "cases"."case_short_desc", "cases"."case_opened_DT", "cases"."case_last_edited_DT", "persons"."psn_department", "cases"."case_priority_id", "cases"."form_id", "case_statuses"."case_status_desc", "clients"."client_account", "persons"."psn_firstname"
FROM ((("FacetsRpl_SQL"."sm45_ReplView"."cases" "cases" INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."contacts" "contacts" ON "cases"."contact_id"="contacts"."contact_id") INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."persons" "persons" ON "cases"."case_assigned_to"="persons"."psn_id") INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."case_statuses" "case_statuses" ON "cases"."case_status_id"="case_statuses"."case_status_id") INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."clients" "clients" ON "contacts"."client_id"="clients"."client_id"
WHERE "cases"."form_id"=N'349' AND "cases"."case_priority_id"<>359 AND ("case_statuses"."case_status_desc"=N'1 - Open' OR "case_statuses"."case_status_desc"=N'Client Pending' OR "case_statuses"."case_status_desc"=N'Escalated' OR "case_statuses"."case_status_desc"=N'Hold' OR "case_statuses"."case_status_desc"=N'New' OR "case_statuses"."case_status_desc"=N'Open' OR "case_statuses"."case_status_desc"=N'Pending Approval' OR "case_statuses"."case_status_desc"=N'Pending Client' OR "case_statuses"."case_status_desc"=N'Pending Development' OR "case_statuses"."case_status_desc"=N'Pending Installation' OR "case_statuses"."case_status_desc"=N'Pending Research' OR "case_statuses"."case_status_desc"=N'Pending Third Party' OR "case_statuses"."case_status_desc"=N'Pending Training' OR "case_statuses"."case_status_desc"=N'Re-Opened' OR "case_statuses"."case_status_desc"=N'Staff Pending' OR "case_statuses"."case_status_desc"=N'Waiting Dev Completion' OR "case_statuses"."case_status_desc"=N'Waiting for Client') AND ("persons"."psn_department"=N'812 Lending' OR "persons"."psn_firstname"=N'Loancierge Team Internal ')
ORDER BY "persons"."psn_lastname", "cases"."case_opened_DT" DESC
SELECT "persons"."psn_lastname", "clients"."client_id", "cases"."case_id", "cases"."case_short_desc", "cases"."case_opened_DT", "cases"."case_last_edited_DT", "persons"."psn_department", "cases"."case_priority_id", "cases"."form_id", "case_statuses"."case_status_desc", "clients"."client_account", "persons"."psn_firstname"
FROM ((("FacetsRpl_SQL"."sm45_ReplView"."cases" "cases" INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."contacts" "contacts" ON "cases"."contact_id"="contacts"."contact_id") INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."persons" "persons" ON "cases"."case_assigned_to"="persons"."psn_id") INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."case_statuses" "case_statuses" ON "cases"."case_status_id"="case_statuses"."case_status_id") INNER JOIN "FacetsRpl_SQL"."sm45_ReplView"."clients" "clients" ON "contacts"."client_id"="clients"."client_id"
WHERE "cases"."form_id"=N'349' AND "cases"."case_priority_id"<>359 AND ("case_statuses"."case_status_desc"=N'1 - Open' OR "case_statuses"."case_status_desc"=N'Client Pending' OR "case_statuses"."case_status_desc"=N'Escalated' OR "case_statuses"."case_status_desc"=N'Hold' OR "case_statuses"."case_status_desc"=N'New' OR "case_statuses"."case_status_desc"=N'Open' OR "case_statuses"."case_status_desc"=N'Pending Approval' OR "case_statuses"."case_status_desc"=N'Pending Client' OR "case_statuses"."case_status_desc"=N'Pending Development' OR "case_statuses"."case_status_desc"=N'Pending Installation' OR "case_statuses"."case_status_desc"=N'Pending Research' OR "case_statuses"."case_status_desc"=N'Pending Third Party' OR "case_statuses"."case_status_desc"=N'Pending Training' OR "case_statuses"."case_status_desc"=N'Re-Opened' OR "case_statuses"."case_status_desc"=N'Staff Pending' OR "case_statuses"."case_status_desc"=N'Waiting Dev Completion' OR "case_statuses"."case_status_desc"=N'Waiting for Client') AND ("persons"."psn_department"=N'812 Lending' OR "persons"."psn_firstname"=N'Loancierge Team Internal ')
ORDER BY "persons"."psn_lastname", "cases"."case_opened_DT" DESC