Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: drenalin on 28 Dec 2012 11:55:07 AM

Title: Need help with query!
Post by: drenalin on 28 Dec 2012 11:55:07 AM
Hi,

I'm having trouble pulling the records I need.

Below is my primary filter:

Code Select

[Query1].[Service] in ('Lending Pipeline (Referrals)','Deposit Pipeline (Referrals)','Third Party Services (Referrals)'



Based on the above filter what I need to happen next is to NOT pull any records where:

Code Select

[Query1].[Referred From] = [Query1].[Referred To] and [Query1].[Service] = 'Lending Pipeline (Referrals)' or 'Deposit Pipeline (Referrals)'


Thanks for any help.
Terry
Title: Re: Need help with query!
Post by: blom0344 on 31 Dec 2012 02:11:47 AM
[Query1].[Referred From] <> [Query1].[Referred To] and [Query1].[Service] not in ('Lending Pipeline (Referrals)','Deposit Pipeline (Referrals)')
Text only | Text with Images