Search results for query: *

thank you for your help and suggestions... <smile> Thanks for everything... I run Crystal 8.5 on an Oracle 8 database... [pc2] cmpgeek

i do not know how to create a period table... is that difficult? im sorry i did not explain the data and expected output as cleary as i should have - i thought trying to create a crosstab format here would look awful so i tried to just describe... sample data and expected outcome: there are...

I am writing a report that needs to list whether or not there was a case going on in a particular room at a particular time. I am hoping that i can write it as a cross tab report, but the more i try to get this cross tab to work, the more frustrated i get. i am basing the rows on...

you said the analyst is listed in both the problem and changes tables as well as the contact table... are the analysts information listed differently in each table? i am just wondering why you can not connect them if you started with the contact table and then linked it to the others based in...

i went back in and placed the *s... when i refreshed the report it had taken the mesh i wanted away and left the interpore... I run Crystal 8.5 on an Oracle 8 database... [pc2] cmpgeek

i am sorry Reebo, i thought not(A like B) and not(B like A) would give you the same result... this is my record selection code as of now: {case_.CAS_DATE} in {?DateRange} and ( {case_.CAS_SITE} = "OR" ) and {ITMCAT.ITM_PROCAT} in ["3130","3155"] and not ({implant2.IMP2_TYPE} like...

unfortunately, lb, that code did not work... but i still appreciate your taking the time to explain it :) I run Crystal 8.5 on an Oracle 8 database... [pc2] cmpgeek

Reebo99, i have already tried the LIKE statement - it tells me that there is a string required between "[" and "INTERPORE" ... lbass - thank you so much for explaining that... i can understand how that works now... i dont know about anyone else, but the way i see it is that having someone...

i want to use it for record selection... what does "instr" stand for? i just want to make sure i understand what it says and how it makes the report flow... if that makes sense... thanks for your help! I run Crystal 8.5 on an Oracle 8 database... [pc2] cmpgeek

i want to use it for record selection... what does "instr" stand for? i just want to make sure i understand what it says and how it makes the report flow... if that makes sense... I run Crystal 8.5 on an Oracle 8 database... [pc2] cmpgeek

i just wanted to let yall know someone gave me the following suggestion in regard to the second question and it worked great: Code: -------------------------------------------------------------------------------- If {Item_no}="54446" then {item.itm_desc}={item.itm_desc}...

when i try: ------------------------------------------------------------ not (["INTERPORE","CEMENT","COLLAGRAFT","MESH"] like {implant2.IMP2_TYPE}) ------------------------------------------------------------ it tells me that a string is required between the [ and "INTERPORE" when i try...

I am sitting here with both my Crystal 8.5 and my SQL guides out and still can not find the answers I am looking for... I know that if I want to block an item that starts with a certain phrase I can use the code Code...