I have field in my report that consists of project names. I would like to exclude any projects from my report that include the word "insert" and/or "stitch" as part of their name.

 

I've tried to use the "Select Expert" tool to accomplish this, but have had no luck. From searches of this forum, I believe I need to utilize a forumula when using the Select Expert tool, and gave it a shot based on some previous answers in this forum, but they did not work. Can someone give me some direction on creating a forumula to exlude projects with insert and/or stitch as part of their name?

 

Thanks in advance for any help on this.

 

 

 

Here are some examples of the descriptions:

 

Mens Stitch In

September Stitch In - B

Fall Insert 2

Timeline Insert

August Insert Update

 

 

 

 

Thanks for your help. I've worked on it yesterday and this morning, but still no luck - I am stuck. Here is what I have done.

 

Created a formula named "stitch". The user decided they wanted to include projects with "insert" in their descritpion, so I only need to filter out those projects with "stitch" in their description

 

Your example was:

len({table.projectname}) - len(replace({table.projectname},'Stitch',''))

 

The formula I created is called "stitch" and its syntax is below:

len({ad_info.ad_desc}) - len(replace({ad_info.ad_desc},'stitch',''))

 

I was not sure what "projectname" referred to - I thought it was the field that had to be filtered.

 

The next step was to do the following... 

 

 

OK - I am a lot closer

 

 

I double clicked the stitch formula and it added

 

{@stitch} to the top of the formula in the lower section

I am not sure what you meant by "their you check stitch = 0" but I changed the stitch formula in the lower section to read:

 

{@stitch} = 0 and

 

I checked, the code, no errors were found, I refreshed the report. It still lists projects that contain "stitch" in their description.