CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Reports - Next Activity Subject

edited Jun 22, 2013 8:12PM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered
 Hello,
I have a report I am working on to show how many days it has been since an Activity was put to an Opportunity. This works great and I am also able to pull in the Next Activity (open activity) date into the report by using: "case WHEN MAX("- Due Date"."Task Due Date") <= CURRENT_DATE then '' else CAST(MAX("- Due Date"."Task Due Date") as char) end" in my column formula. 

What I would really like to do is have another column that has my Next Activity Subject so that I can know what is coming up. Is there any way to do this? It is already pulling the date for the next activity so is there a way to somehow capture the Activity ID and be able to have that be listed in my report?

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