CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Using 2 or more picklist fields with same values to avoid multi-select picklists

edited Apr 25, 2012 1:00AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered
Hi,

I want to avoid using a multi-select picklist because of the related drawbacks, so I was thinking about using 3 picklist fields that all have the same values.  Say I want to be able to track Competitors at the Lead level and I was going to create Comp1, Comp2, and Comp3, and all three picklists were going to have the same values (40 or so).  Is there a way in real-time reporting that I could create a report with a prompt that would query against all three as if they were one?  Meaning that I would have a single picklist

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center