PC Review


Reply
Thread Tools Rate Thread

Can I filter by fields 'containing' specific words?

 
 
K_C_H
Guest
Posts: n/a
 
      17th Nov 2009
I have a created a user defined field in BCM which contains the products our
customers sell. In most cases this field contains more than one product
seperated by commas. Can I filter a report to only display accounts if this
field 'contains' text which I specify?
--
Thanks
 
Reply With Quote
 
 
 
 
bwbob
Guest
Posts: n/a
 
      23rd Nov 2009
you should be able to by opening a canned report, modify it to include the
custom field, then go to the filter page, advanced filter, select the custom
field from the drop down and then select your comparitor (i.e. "contains").
your choices for comparitors changes with the type of field (number or text).
save your new report with a name that inlcudes your filter for reference.

note: different reports (opportunity, accounts, contacts) have different
infomation pieces tied to them, you may have to poke around in several areas
to find one that has the custom field and the other types of info you want.
if you put the custom field on the Contacts page, i dont think you will find
a report in the Accounts section with the data you want. Some things roll up
to the Accounts level, some things dont seem to, or at least not the way you
might expect.

"K_C_H" wrote:

> I have a created a user defined field in BCM which contains the products our
> customers sell. In most cases this field contains more than one product
> seperated by commas. Can I filter a report to only display accounts if this
> field 'contains' text which I specify?
> --
> Thanks

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to filter for specific words in a field watchtower54 Microsoft Access 4 17th Aug 2009 09:11 PM
Is there a way to filter out email containing specific words? =?Utf-8?B?Smlt?= Microsoft Outlook Discussion 1 8th Aug 2007 03:26 PM
counting occurrence of specific words in another group of words kh@horsemanship101.com Microsoft Excel Programming 0 5th Aug 2006 03:43 AM
Spam filter 'with specific words in body' does not work. =?Utf-8?B?RG91Z011bmRheQ==?= Microsoft Outlook Discussion 1 4th Feb 2005 09:34 PM
Using rules to filter out specific words in an HTML message Shadow Microsoft Outlook 0 22nd Dec 2003 01:12 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:16 PM.