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

Crystal Reports- Filter field by specific word(s)

Category:DefaultRelease time:2015-10-11Views:130

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[More]

Error: Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer

Category:DefaultRelease time:2015-10-11Views:130

I have connected TABULAR Model to Excel, and in the pivot the filter is on multiple dimensions. When doing the drillthrough action it gives error - Error: Show Details cannot be executed when multiple items are selected in a report filter field or in[More]

Crystal Report Formula field function  on OLAP SAP BI/BW Cube

Category:DefaultRelease time:-0001-11-30Views:130

Dear All We create OLAP Cube Report in  Crystal Report 2008 (BO)  base  SAP ( DB2)  BI/BW  Cube, Grid report coming correctly.  Crystal Report Formula Field  functionalities are not avilabel or suporting.  If any one explain or some kind of documenta[More]

How to change crystal report data field at runtime ?

Category:DefaultRelease time:2015-10-11Views:130

Hello everyone, I have a Crystal Report file ,which i am using to generate report for my windows form project . In that report i have a filed called as Quantity which data type is set as decimal, the requirement is like that the number of value those[More]

Capturing Interactive Report Filter Fields

Category:DefaultRelease time:-0001-11-30Views:130

I've a requirement where in a user can view data, apply filters to it, and then invoke an Oracle API by passing in the data set currently visible on the report. If I can some how capture currently applied filters on an Interactive report, I should be[More]

Random Characters insterted into Crystal Reports string fields

Category:DefaultRelease time:-0001-11-30Views:130

I'm having a problem where random characters are being inserted into string fields in my crystal reports, I talked to a representative and they are unable to fix the problem, so I'm asking here if someone has a workaround.  The characters are always[More]

SAP Crystal reports formula fields

Category:DefaultRelease time:-0001-11-30Views:130

hi,     how to use formula fields in crystal report.                      thanks & regards,vinothHi Vinoth, That's a very vague question. You can create formulae via the Field Explorer > Formula option. After you save and close the formula editor,[More]

Disable Crystal reports grey fields in the preview

Category:DefaultRelease time:-0001-11-30Views:130

Dear forum users, I've got an application not written by me (so I do not have source code) that displays a Report in a standard Crystal Report Viewer. In the preview when I click on a field it gets rounded with a grey border, filled with a grey backg[More]

Crystal Reports DataBase Fields

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'd like to know if is possible to set the query string and the DataBase when you want to open a Crystal Report from SBO. Thanks.You cannot set the database connection string from the SBO connection information because the password is encrypted.[More]

Crystal Report: Show Field only in Print-Preview

Category:DefaultRelease time:2015-10-11Views:130

Dear Experts, is it possible to show a field only in the print preview (when the report is generated) without printing this field? Thanks for Help. JacquelineNo, it is not possible to display a report object on screen then suppress it when printing.[More]

Crystal Reports in other languages ...

Category:DefaultRelease time:2015-10-11Views:130

Hi I'm new to crystal reporting my question is can crystal reports (v10 to be specific) present data in other languages like for example Arabic even though your data source is English language? More like translate this data to that language, Is it ju[More]

Hot
I have a Windows Forms project which was originally developed in Visual Studio 2010. I migrated the project to VS2013, and now every time I open the project's main form, the designer complains of a null reference. If I hit "Ignore and Continue", [More]
Hi, I am using BAPI_OUTB_DELIVERY_CHANGE for changing the outbound delivery picking quantity but there is no field to change the pick quantity. plas advice any BAPI to change pick quantity Regards, KrishnaKrishna....have a look in the below threads w [More]
Several of us new iPod users on my office LAN have been plagued by iTunes' unasked decision to locate its index files (I.e. iTunes Library.itl and itunes Music Library.xml) at \My Documents\My Music\iTunes. Why is this annoying? Because, for example, [More]
itunes store won't open because it says i need to download safari 4.0.3 but there is no download for safari 4.0.3 in the software updates.itunes store won't open because it says i need to download safari 4.0.3 but there is no download for safari 4.0. [More]
Hello Experts, I am implementing fixed assets module for Mexico and as per the business requirements, the customer needs to adjust fixed assets values (APC and depreciation) for inflation. I have been able to configure the system for this but the pro [More]
Dear all, I'm strugling on changing the valid-to date for a BOM component. Let me explain in detail what the scenario is and what I've done so far. I have a BOM header "Z" with 5 different components, Y, X, W, V and U. Validity dates should be a [More]
When Software Update indicated that I had new iTunes software to install, I did it. I opened iTunes for the first time today since that install and I have absolutely no music in iTunes anymore. I have no idea what happened.AbigailinAustin wrote: Home [More]
Hi We have place to specify the  Bank G/L acct. number in the master of House bank and Hose bank ID in the Bank G/L master.  Why do we have option to mention in two places and  when do we need that? thanks PrasadHi Prasad, House bank (HB) means Your [More]
Hello all, I need some help about publishing my application as an applet from my PC. As an application my program works fine. 1) I have developed an application (which extends JApplet class). I am using some jar files (which have been written by othe [More]
Why do I have to repeat the installation process every time I turn on my PC?Why do I have to repeat the installation process every time I turn on my PC? Because you never run the install of whatever program you are referring to with sufficient user p [More]