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
Dear Community, I worked with Anja on this PCUI project, who has since left this project. We had to change the transaction customizing to rectify the descriptions and after transporting this into the master data client, we now have the transaction po [More]
Please help me to download for App Store my I'd. Need credit card but I don't have during review  I have to fill card number but I don't have with out this howz can I do ?Unless you follow the instructions on this page when creating a new account : h [More]
I jus puchased an airtel 3g connection in india and the software that comes bundled with the huawei E1731 modem only supports upto snow leopard. I downloaded various drivers and installed them succesfully but the modem does not get detected. i am on [More]
Good afternoon, Excuse, are newbie in the scope I am learning and putting desire to him, this in my situation I am trying to install Sun ONE Directory Server 5,2 since I understand that this it is application LDAP for Solaris, ok I want to install it [More]
I expect the following code to fail and to write 'ERRORE' to stdout: ------------------- mm.sql set serveroutput on BEGIN select 1/0 from dual; exception when others then dbms_output.put_line('ERRORE'); END; I execute this from the command line sqlpl [More]
Hi All We are trying to load data in Cube through DTP from DSO. In the Transformation, we are looking up Infocube data through SAP Standard Function Module 'RSDRI_INFOPROV_READ'. The Problem we are facing is that our loads are getting failed & it is [More]
Hi guys, our LMS server has proxy access to the internet but running a EoS/EoL hardware report results in:- No data available in the report. The problem could be any one of the following: 1. No EoS/EoL hardware data available in the LMS database for [More]
Hi, I want to create a gridview same as AB.net or C#.net windows forms application. Some cells of the grid view will contain listbox and some will contain textbox. The user will enter data in the grid view. Then after clicking on submit button the da [More]
dear all : i am using WebLogic Server Version: 10.3.2.0 with Oracle Jdevloper 10g realse 1 (11.1.1.2.0) . i face the following problem : i have master detail table as grid . when i click in mouse in master table it will refresh all the table and go t [More]
Hi, When I do an initial data entry in Recruitment for internal applicant, some information is not populated, e.g. personnel id number. Can anyone please give me some advise on how to solve this? RegardsHi, If the Applicant is internal .Than entry on [More]