Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Duplicates Post Reply Post New Topic
Author Message
mikebird
Groupie
Groupie
Avatar

Joined: 04 Mar 2008
Location: United Kingdom
Online Status: Offline
Posts: 70
Quote mikebird Replybullet Topic: Duplicates
     Posted: 07 Jul 2008 at 6:02am
Every row of my report duplicates four times now I introduced four formulae to provide four people's names from a different linked table with the four seperate roles they have in a project.
 
I thought of doing this by column or by row but each causes the same trouble I think. A simple filter got rid of each row will all empty "" name rows (thousands) but most rows have one name in one of the spaces, with the other three being empty. This means all other columns (18 or so) repeat four times. Grouping won't help because it will knock out one of the names...
 
This must be simple. I cannot see the answer. I want to see all the names just bunched into one row. What can be wrong? Checked all the links. If removing all the names from here, there are still four dupes on each project... all to do with these name formulae
 
Thanks
Mike
Life = luck (+/-) and effort (+/-). If you have no luck & make no effort, then you are dead
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 07 Jul 2008 at 6:56am
Hi,
Can you post some sample data and what you are expecting from the report.
 
Also let us know what formulas you have created and where are you checking them....
 
cheers
Rahul
IP IP Logged
mikebird
Groupie
Groupie
Avatar

Joined: 04 Mar 2008
Location: United Kingdom
Online Status: Offline
Posts: 70
Quote mikebird Replybullet Posted: 07 Jul 2008 at 8:39am
The four formulae are like this, where the role ID changes number, that's all:
 
@Eng_Partner_Director is:
 
if {INT_PROJ_ROLE_TYP.PROJ_ROLE_TYP_ID} = 9 then {INT_AUX_LISTING.FIRST_NM} + " "  + {INT_AUX_LISTING.LAST_NM}
 
This made a great improvement to filter on blank rows without names:
({@Eng Partner Director} <> "" or
{@Identified By} <> "" or
{@Managing Country Account Partners} <> "" or
{@Pursuit Leader} <> "")
 
 
The CSV data follows. Generally all rows are quadrupled to show something for each name... gaps for the rest. If you view this in a grid it should be clear. I'm hoping you've come across this problem before. I'll put the SQL afterwards but it didn't point anything out to me this time.
 
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date AS National Grid plc Continuous Controls monitoring AABS: Tech & Secur Risk Srvcs (TSRS) 2 Pursuit 150000 Gill Williams 21/03/2008 0 30 500000 07/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date AS National Grid plc Continuous Controls monitoring AABS: Tech & Secur Risk Srvcs (TSRS) 2 Pursuit 150000 Jon Hughes 21/03/2008 0 30 500000 07/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date AS National Grid plc Continuous Controls monitoring AABS: Tech & Secur Risk Srvcs (TSRS) 2 Pursuit 150000 Gill Williams 21/03/2008 0 30 500000 07/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date AS National Grid plc Continuous Controls monitoring AABS: Tech & Secur Risk Srvcs (TSRS) 2 Pursuit 150000 Gill Williams 21/03/2008 0 30 500000 07/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance Xyratex Group Ltd Audit Assurance: Assurance Services 2 Pursuit 400000 Geoff Collins 12/10/2006 1 80 500000 12/31/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance Fiberweb plc Audit Assurance: Assurance Services 2 Pursuit 195000 Nick Powell 30/05/2008 1 30 650000 10/31/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance SkyePharma Plc 2007 audit including overruns Assurance: Assurance Services 1 Pursuit 500000 William Powlett Smith 06/03/2008 1 100 500000 04/30/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance SkyePharma Plc 2007 audit including overruns Assurance: Assurance Services 1 Pursuit 500000 David Wilkinson 06/03/2008 1 100 500000 04/30/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance AT & T Audit Pursuit (12/08 Start) Assurance: Assurance Services 2 Pursuit 1050000 Mick Bardella 12/02/2008 1 50 2100000 12/26/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance Fiberweb plc Audit Assurance: Assurance Services 2 Pursuit 195000 Nick Powell 30/05/2008 1 30 650000 10/31/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance Fiberweb plc Audit Assurance: Assurance Services 2 Pursuit 195000 Nick Powell 30/05/2008 1 30 650000 10/31/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance SkyePharma Plc 2007 audit including overruns Assurance: Assurance Services 1 Pursuit 500000 William Powlett Smith 06/03/2008 1 100 500000 04/30/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance Fiberweb plc Audit Assurance: Assurance Services 2 Pursuit 195000 Nick Powell 30/05/2008 1 30 650000 10/31/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date Assurance SkyePharma Plc 2007 audit including overruns Assurance: Assurance Services 1 Pursuit 500000 William Powlett Smith 06/03/2008 1 100 500000 04/30/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Production Services Network Limited Everest (Production Services Network Ltd) TAS: Transaction Support Services 1 Pursuit 750000 Ally Rule 04/04/2008 1 75 1000000 10/15/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Goulds Tissue Limited Goulds administration TAS: Transaction Support Services 2 Pursuit 500000 Ben Wildsmith 16/08/2007 1 100 500000 08/16/2007 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS The World Bank East Africa Power Pool TAS: Transaction Support Services 2 Pursuit 125000 Michael Cupit 28/05/2008 1 25 500000 09/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Transport Scotland Borders Rail/Airdrie-Bathgate - RAB Funding TAS: Project Finance (PFI) 2 Pursuit 612000 Neil Thomson 28/02/2008 1 90 680000 02/29/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Transport Scotland Borders Rail/Airdrie-Bathgate - RAB Funding TAS: Project Finance (PFI) 2 Pursuit 612000 Dougald Middleton 28/02/2008 1 90 680000 02/29/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Production Services Network Limited Everest (Production Services Network Ltd) TAS: Transaction Support Services 1 Pursuit 750000 Duncan Glennie 04/04/2008 1 75 1000000 10/15/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS The World Bank East Africa Power Pool TAS: Transaction Support Services 2 Pursuit 125000 Jon Hughes 28/05/2008 1 25 500000 09/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Goulds Tissue Limited Goulds administration TAS: Transaction Support Services 2 Pursuit 500000 Thomas Jack 16/08/2007 1 100 500000 08/16/2007 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Production Services Network Limited Everest (Production Services Network Ltd) TAS: Transaction Support Services 1 Pursuit 750000 Ally Rule 04/04/2008 1 75 1000000 10/15/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Transport Scotland Borders Rail/Airdrie-Bathgate - RAB Funding TAS: Project Finance (PFI) 2 Pursuit 612000 Dougald Middleton 28/02/2008 1 90 680000 02/29/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS The World Bank East Africa Power Pool TAS: Transaction Support Services 2 Pursuit 125000 Jon Hughes 28/05/2008 1 25 500000 09/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Goulds Tissue Limited Goulds administration TAS: Transaction Support Services 2 Pursuit 500000 Thomas Jack 16/08/2007 1 100 500000 08/16/2007 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Production Services Network Limited Everest (Production Services Network Ltd) TAS: Transaction Support Services 1 Pursuit 750000 Ally Rule 04/04/2008 1 75 1000000 10/15/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS The World Bank East Africa Power Pool TAS: Transaction Support Services 2 Pursuit 125000 Michael Cupit 28/05/2008 1 25 500000 09/30/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Transport Scotland Borders Rail/Airdrie-Bathgate - RAB Funding TAS: Project Finance (PFI) 2 Pursuit 612000 Neil Thomson 28/02/2008 1 90 680000 02/29/2008 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAS Goulds Tissue Limited Goulds administration TAS: Transaction Support Services 2 Pursuit 500000 Thomas Jack 16/08/2007 1 100 500000 08/16/2007 Core Account
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Viridian Group PLC Post Venice work - repat of ROI profits x2, tax structuring, swap panning Tax: Business Tax Advisory (BTA) 1 Pursuit 860000 Michael Hall 20/02/2008 1 100 860000 10/02/2007 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX IBM United Kingdom Limited Expatriate tax return compliance Tax: Human Capital 2 Qualified 1350000 Nicholas Day 07/02/2008 0 100 1350000 01/31/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Nortel Networks Ltd AP Outsourcing Tax: Business Tax Compliance (BTC) 2 Pursuit 640000 Nick Milton 23/05/2008 1 20 3200000 07/18/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Viridian Group PLC Post Venice work - repat of ROI profits x2, tax structuring, swap panning Tax: Business Tax Advisory (BTA) 1 Pursuit 860000 Graham Galbraith 20/02/2008 1 100 860000 10/02/2007 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX IBM United Kingdom Limited Expatriate tax return compliance Tax: Human Capital 2 Qualified 1350000 Julian Gray 07/02/2008 0 100 1350000 01/31/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Nortel Networks Ltd AP Outsourcing Tax: Business Tax Compliance (BTC) 2 Pursuit 640000 Karl Havers 23/05/2008 1 20 3200000 07/18/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Viridian Group PLC Post Venice work - repat of ROI profits x2, tax structuring, swap panning Tax: Business Tax Advisory (BTA) 1 Pursuit 860000 Michael Hall 20/02/2008 1 100 860000 10/02/2007 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX IBM United Kingdom Limited Expatriate tax return compliance Tax: Human Capital 2 Qualified 1350000 Mike Hibberd 07/02/2008 0 100 1350000 01/31/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Nortel Networks Ltd AP Outsourcing Tax: Business Tax Compliance (BTC) 2 Pursuit 640000 Sarah Clifford 23/05/2008 1 20 3200000 07/18/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Nortel Networks Ltd AP Outsourcing Tax: Business Tax Compliance (BTC) 2 Pursuit 640000 James Bennet 23/05/2008 1 20 3200000 07/18/2008 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX Viridian Group PLC Post Venice work - repat of ROI profits x2, tax structuring, swap panning Tax: Business Tax Advisory (BTA) 1 Pursuit 860000 Michael Hall 20/02/2008 1 100 860000 10/02/2007 UKI PAT
Client Project Service ChannelNumber Stage Weighted Valueof Potential Sale Managing Country Account Partners Eng Partner Director Open Date CompBid Probabilityof Win Total Value of Potential Sale PAT Status Pursuit Leader Identified By Ant Win Date TAX IBM United Kingdom Limited Expatriate tax return compliance Tax: Human Capital 2 Qualified 1350000 Nicholas Day 07/02/2008 0 100 1350000 01/31/2008 UKI PAT
 

 SELECT DISTINCT "INT_AUX_PROJECT"."ARC_CLIENT_NM", "INT_PROJTYP_STAGE"."STAGE_NM", "REPORT_STAGING"."B3", "REPORT_STAGING"."A10024", "INT_AUX_PROJECT"."OPEN_DT", "INT_AUX_PROJECT"."PROJECT_NM", "INT_AUX_PROJECT"."PROBABILITY", "INT_AUX_PROJECT"."SIZE_AMOUNT", "REPORT_STAGING"."A10003", "INT_AUX_PROJECT"."CONFIG_ID", "INT_AUX_PROJECT"."DELETE_IND", "CLIENT_REPORTS"."A26915", "INT_AUX_LISTING"."FIRST_NM", "INT_AUX_LISTING"."LAST_NM", "INT_PROJ_ROLE_TYP"."PROJ_ROLE_TYP_ID", "INT_AUX_PROJECT"."FORECAST_IND", "REPORT_STAGING"."A4", "INT_PROJECT_TYP"."PROJECT_TYP_NM", "INT_PROJ_ROLE_TYP"."LISTING_TYP_IND"
 FROM   ("InterAction"."dbo"."INT_PROJ_ROLE_TYP" "INT_PROJ_ROLE_TYP" INNER JOIN ((((("InterAction"."dbo"."INT_PROJECT_TYP" "INT_PROJECT_TYP" INNER JOIN "InterAction"."dbo"."INT_AUX_PROJECT" "INT_AUX_PROJECT" ON "INT_PROJECT_TYP"."PROJECT_TYP_ID"="INT_AUX_PROJECT"."PRIMARY_PROJECT_TYP_ID") INNER JOIN "InterAction"."dbo"."INT_AUX_PROJMEMBER_ROLE" "INT_AUX_PROJMEMBER_ROLE" ON ("INT_AUX_PROJECT"."PROJECT_ID"="INT_AUX_PROJMEMBER_ROLE"."PROJECT_ID") AND ("INT_AUX_PROJECT"."LAST_EDIT_ID"="INT_AUX_PROJMEMBER_ROLE"."LAST_EDIT_ID")) INNER JOIN "InterAction"."dbo"."CLIENT_REPORTS" "CLIENT_REPORTS" ON "INT_AUX_PROJECT"."PROJECT_ID"="CLIENT_REPORTS"."PROJ_ID") INNER JOIN "InterAction"."dbo"."REPORT_STAGING" "REPORT_STAGING" ON "INT_AUX_PROJECT"."PROJECT_ID"="REPORT_STAGING"."PROJ_ID") INNER JOIN "InterAction"."dbo"."INT_PROJTYP_STAGE" "INT_PROJTYP_STAGE" ON "INT_AUX_PROJECT"."STAGE_ID"="INT_PROJTYP_STAGE"."STAGE_ID") ON "INT_PROJ_ROLE_TYP"."PROJ_ROLE_TYP_ID"="INT_AUX_PROJMEMBER_ROLE"."PROJ_ROLE_TYP_ID") INNER JOIN "InterAction"."dbo"."INT_AUX_LISTING" "INT_AUX_LISTING" ON "INT_AUX_PROJMEMBER_ROLE"."LISTING_ID"="INT_AUX_LISTING"."LISTING_ID"
 WHERE  "INT_AUX_PROJECT"."CONFIG_ID"=300 AND "REPORT_STAGING"."A10003"='UKI' AND "INT_AUX_PROJECT"."SIZE_AMOUNT">=500000 AND "REPORT_STAGING"."B3" NOT  LIKE 'TAS: M&A%' AND ("INT_PROJTYP_STAGE"."STAGE_NM"='Pursuit' OR "INT_PROJTYP_STAGE"."STAGE_NM"='Qualified') AND "INT_AUX_PROJECT"."DELETE_IND"=0 AND ("INT_PROJ_ROLE_TYP"."PROJ_ROLE_TYP_ID"=9 OR "INT_PROJ_ROLE_TYP"."PROJ_ROLE_TYP_ID"=21 OR "INT_PROJ_ROLE_TYP"."PROJ_ROLE_TYP_ID"=10005 OR "INT_PROJ_ROLE_TYP"."PROJ_ROLE_TYP_ID"=10006) AND "INT_PROJ_ROLE_TYP"."LISTING_TYP_IND"=2
 
 
Thanks
Mike
Life = luck (+/-) and effort (+/-). If you have no luck & make no effort, then you are dead
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.