Search results for query: *

sorry this thing is not working it is still showing me records for col2 that have value <>N ie Y and Z and which GRP footer should I drop the detail section in

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...

What do you mean when you do "year*100"

But I have year 2004 also and it is for December only for 2004

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...

Thanks it works,...but why it is showing just the first record when I move the fields to the GH...what is the concept behind this Behavior. Thanks

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...

Thanks a lot ..it worked.... But if 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 out of these two records A Fuu Ab A Faa bc I want to display any one of the occurance.

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...

the other question I had was about using NULL option like the one shown below in SQL 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...

Thanks groggle yes you are exactly right SQL ADD command is the only solution I was able to get hold of to resolve this issue but I was thinking of getting something from within the crystal only with simple table joining in Dataexpert. I have another confusion about how the left outer join...

I think I tried what you are saying.....and it didnt work Clear picture for you..... Scenario 1. select TabA.*, TabB.Col2 from TabA inner join TabB on TabA.Col1=TabB.Col1 Scenario 2. select TabA.*, TabB.Col2 from TabA left outer join TabB on TabA.Col1=TabB.Col1 Gives Null values for...

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...

OPPS...I m sorry about that synapsevampire .. I am using CR XI. I will try with "and

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...