Requests not converted to Projects report for Managers | Community
Skip to main content
amybillmayer
Level 4
November 8, 2019
Question

Requests not converted to Projects report for Managers

  • November 8, 2019
  • 7 replies
  • 894 views
I'm trying to create what I thought would be a very simple report but it's got me stumped. I need a report for Managers to be able to view Requests made by their Direct Reports that have not been converted to Projects. Here's what I've done: Primary Contact >> Manager ID Equal $$USER.ID AND Request >> Status Equates With Not Equal Closed AND Request >> Resolving Object ID I s Blank I end up with nothing. What am I missing? Amy Billmayer Allianz Life
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

7 replies

Heather_Kulbacki
Community Advisor
Community Advisor
November 8, 2019
Are you getting nothing when you view the report as yourself, or are you logged in as one of the managers and still getting nothing? Or do you have direct reports yourself that should have requests on this report?
amybillmayer
Level 4
November 8, 2019
I'm logging in as a Manager whose Direct Reports have a number of Requests that are New, Awaiting Feedback, On Hold, etc. Amy Billmayer Allianz Life
Heather_Kulbacki
Community Advisor
Community Advisor
November 8, 2019
I've struggled in the past with that "status equates with" filter and often resort to filtering on just "status" and listing all the actual statuses.
amybillmayer
Level 4
November 8, 2019
Thanks Heather. I tried this as well, no go :( Primary Contact >> Manager ID Equal $$USER.ID AND Request >> Status Equal Awaiting Feedback, New, On Hold AND Request >> Resolving Object ID I s Blank Amy Billmayer Allianz Life
Heather_Kulbacki
Community Advisor
Community Advisor
November 8, 2019
Some other maybe's... I assume the managers already have View access to all the requests that their direct reports submit - if not, in the Reporting Options > Run this report with the Access Rights of: enter any Admin's name Since Primary Contact is a field that it is possible to change, maybe try Entered by >> Manager ID = $$USER.ID Also, I went back and tried the Status Equates With filter and this pulled in requests (issues for us) that have an approval on them, where just Status did not. So if you have approvals on requests, your first option of Equates With is your better option.
amybillmayer
Level 4
November 8, 2019
Heather, you're a life saver! I didn't have the request queues shared properly. Thank you SO much for taking the time to look into this. Amy Billmayer Allianz Life
Heather_Kulbacki
Community Advisor
Community Advisor
November 8, 2019
Happy to help!