Search results for query: *

If I have two records where one of the column field is having same value, I have to exclude all the records if status in column 2 is N for any of the records Col1 Col2 col3 123 Y US 123 Z UK 123 N UK For the above case need to exclude all the 3 records as status is N for one of the...

Can any one suggest some single line code for this instead of multiple lines (({Month}= "DECEMBER" and {YearNumber} = 2004) or ({Month}= "JANUARY" and {YearNumber} = 2005) or ({Month}= "FEBRUARY" and {YearNumber}= 2005) or ({Month}= "MARCH" and {YearNumber}= 2005))

Hi I have never used a stored procedure in Crystal reports but tried dropping one through the database expert. I have seen that as soon as I drop it in I get a prompt for parameters and parameter fields are created in field explorer because of stored procedure. But is it must to write a cursor...

I am using Crystal XI If I have a table like Col1 Col2 Col3 A Fuu Ab A Faa bc B Fee ca C Fun ef D Free gh D Fis ij D Fic kl I have to display just one occurance of the record that has multiple of the same field in Col1 then what method should I use. Like...

I am using CR XI I have to do a count of record output but just count one record if multiple occurances are there in each group Group1A Col1 Col2 Col3 A Fuu Ab A Faa bc B Fee ca C Fun ef D Free gh D Fis ij D Fic kl Group2A Col1 Col2 Col3 J Fun ef F...

I am using a left outer join in a select statement as select CR.MKTG_CD_ID, CC.Name_ID, CC.Name, VCR.DOB from CC INNER JOIN VCR on VCR.CONTACT_ID=CC.CONTACT_ID LEFT OUTER JOIN CNTC_MKTG_RESP CR on CR.CNTC_GROUP_ID=VCR.CNTC_GROUP_ID and CR.MKTG_CD_ID<> 8248 WHERE CONDITIONS..... In...

I have a confusin about using NULL option like the one shown below. Select * from Table A TA, Inner Join TabB TB on TB.Col1=TA.Col1. Left outer join TabC TC.Col1=TA.Col1 and TC.Col2 isnull. Where TB.Col3=33 othercase is ... Select * from Table A TA, Inner Join TabB TB on...

I am little confused with Left outer join in Data Expert for CR XI. In first scenario I m dealing with around 3 tables out of which table A and Table B are INNER JOINED. So I am getting all the records for Table A plus where the values match with Table B Next scenarion I do a Left outer join...

I have a Zip code list which I need to exclude from the data retrieved for my report and the list of zip codes is around 1800 and the other big problem is these zip codes are not present in database tables. I tried putting all these zipcodes in one selection expert constraint as not...