asked on

Advanced Sorts??

I have a crystal report setup and working fairly well.

what i need is to be able to count the specific instances that a specified word appears in teh description.

Is that possible and if so, how would i accomplish it???

I have a attached an image of my report.

Here's an example of what i need.
- Count the specific times the word fixed shows up in the description??? (Totals)

let me know if you need anymore information

thanks in advance
Sample-1.JPG

PCIIain

Create a formula as follows

if(isnull({table.fieldname}))then
0
else if("FIXED" in uppercase({table.fieldname}))then
1
else
0

Then SUM this formula, rather than counting it.

peter57r

Just to be precise about this..
do you want the number of times the specified word appears in all descriptions.
or
do you want the number of descriptions the specified word appears in

Are you using a parameter to input the specified word - if not how does it get into the report?

BSAS_ITGuy

Try this formula

if "FIXED" in {Description} then 1 else 0

Then do a sum on your formula.

UKSystemSupport

ASKER

peter57r: - the number of descriptions the specified word appears in

Shiv

1. Group1 : Group by Date ( for ecah Month)

2. Group2 : Group by Description

3. Details : place your decription field ( Suppress Detail Section)

4. Group2 Footer : place your counts of your decription on Group2 level
and your {group2 Name}

To do this
a) right click on description on detail section > insert summary > count > group2
OR
b)write a formula : Count({Description},{Description})

Thnx
shiv

Shiv

If you want to name on nulls:

Instead of Groupin decription, Group on this below formula :

If ISNULL({Description}) Then "No Description"
Else {Description})

UKSystemSupport

ASKER

thanks for the help;

some of these are working, but they lead me into another problem.

Is it possible to do an If statement and ask to find two words instead of just one???

the following works for me, as to what i said earlier:
IF "Fixed" in {Smart_meter_Installs.RATE_CATEGORY_DESC} then 1 else 0

How would i write it, if i also wanted to search for the word "Res" the same way i am for fixed??

So in the end i would need one formula for counting all the fixed + Res and another for the Fixed - Res

UKSystemSupport

ASKER

Anyone know how to do a if statement searching for multiple words in a field???

ASKER CERTIFIED SOLUTION

Shiv

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shiv

if statement searching for multiple words in a field :

1. write a formula for Fixed :
@fixed :
IF uppercase({Smart_meter_Installs.RATE_CATEGORY_DESC}) LIKE "*FIXED*"
THEN 1 ELSE 0

2. write a formula for RS :
@RS
IF uppercase({Smart_meter_Installs.RATE_CATEGORY_DESC}) LIKE "*RES*"
THEN 1 ELSE 0

3. adding both :
Sum(@fixed, description) + Sum(@RS, description)

UKSystemSupport

ASKER

good help, but unable to find exactly what i wanted.

thanks for the help though