Sitemap

Amicuk Programming Answers

Crystal Reports- Filter field by specific word(s)

2015-10-11   Views:7

Advertisement

Hello, I am not sure if this possible. I have a table memo text field called close description for service incidents. I need a report to only display records where the close description contains the words ( replaced, replace ,swap , UPS, Etc). I dont

Hello,
I am not sure if this possible. I have a table memo text field called close description for service incidents. I need a report to only display records where the close description contains the words ( replaced, replace ,swap , UPS, Etc). I dont know how to code this in SQL. And if it can be done are the words case specific?
Any assistance would be greatly aprreciated
Thanks all

The replay answer
Advertisement
OK. Change the SQL Expression code to:
SELECT CASE
WHEN CHARINDEX('replaced',"Table"."Database"_Field") > 0
OR CHARINDEX('replace',"Table"."Database"_Field") > 0
OR CHARINDEX('swap',"Table"."Database"_Field") > 0
OR CHARINDEX('UPS',"Table"."Database"_Field") > 0
THEN 1 ELSE 0
END
Then, go to the Record Selection Formula and use the SQL Expression as:
{%SQL_Exp_Name} = 1
-Abhilash

Go to See the other 11 answers

Hot
I need to use my old iphone 5S, but my BF at the time was using it and has given back to me. It's locked with his icloud account and I can't set it up without entering his password to delete the account. Is there another way????karasm18 wrote: I need [More]
When I try to paste an CCI file into  a PSD, I get this message-   Could not complete the Paste command because the ICC profile is invalid. I need the layer to be an editable smart object! What's the solution? RonI received the file from my client. H [More]
Hello, I have absolute shoddy video performance on my machine as well as the fan on/off issues. To add to my frustrations the WinPhlash programme included in BIOS version 3.8 dumps out when trying to flash giving a PHLASHNT.SYS unable to load message [More]
Hi I am working on a scenario iDOC - XI -  ANSI X12.I am following the best practices guide provided by SAP .I am using conversion agent to convert the idoc to Ansi X12 format .For that I have created a serializer and deployed that on DBservice folde [More]
Recently i bought a kingston 8gb ddr3 sodimm ram plate and replaced the two stock ram plates. But after powering the laptop on - it crashes. Says, that i have to check my hardware. Before buying the ram i did a little research and found out, that my [More]
Hi,    What are the corresponding BAPI's for these transaction in ECC 6.0 MB1B MB1C VA01 F-02 F-30 Regards, Karthik.kHi. I know 2 of them. F-02: BAPI_ACC_GL_POSTING_POST, BAPI_ACC_DOCUMENT_POST F-30: POSTING_INTERFACE_CLEARINGRead other 4 answers [More]
Hi, I have only one main page with with one tableview. For example, i have the fields in header say field1, field2, field3, field4, field5. When i click the header of the field say field2, it sorts the line item which is in table display w.r.t field2 [More]
i am unable to see how to update iphoto to 9.2.3   When I check for software updates there are none and i don't see the update prompt when i go to the mac apps storeWhat version of iPhoto do you have now?  If it's an earlier version of iPhoto 9 then [More]
The docs (http://developer.apple.com/iphone/library/documentation/NetworkingInternet/Conce ptual/StreamingMediaGuide/iPhoneStreamingMediaOverview/iPhoneStreamingMediaOverv iew.html) says that there is a beta version of the Media Stream Segmenter, her [More]
I get pop ups saying I'm running low on disk space.  I don't want to delete the wrong files.  Any suggestions on which files I can delete on D:?Hi: Please see if the info at the link below is of help to you... http://support.hp.com/nz-en/document/c03 [More]