Reports - Next Activity Subject
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?
0