CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Drilldown through pipeline report with presentation variables

edited Jun 7, 2012 12:56AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered
Hi,

I have a dashboard prompt based on the area Account Team History (I need the Team Role field), I use a date field (Created Date for example) as a presentation variable (V_DATEBEGIN).

On my main pipeline report (area Opportunities) the presentation variable works fine : "Close Date".Date is greater than or equal to @{V_DATEBEGIN}

But when I drilldown to another report that also uses this presentation variable it's not working : "Close Date".Date is prompted

I receive the following message <View Display Error Error getting drill information: SELECT [...] AND ("Close Date".Date >= date '0000-00-00')>

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