Skip to main content

I have created a report using Report Builder, but when I add it to a tile for a Work Portfolio, it does not recognize the active Work portfolio (all work items are pulled instead of just work within the current Work portfolio).  Does anyone know how I would make my report recognize the Work portfolio?  How about if I want to run it for a single Work entity/item?  I suspect it is in the Report Builder parameters, but I’m not sure how to code it.  Thank you in advance. 

There is some guidance here in the CSC:

https://success.planview.com/Planview_Portfolios/Analytics_and_Reporting/Custom_Reporting_with_Report_Builder

Specifically this topic on hidden parameters:

https://success.planview.com/Planview_Portfolios/Analytics_and_Reporting/Custom_Reporting_with_Report_Builder/Creating_and_Modifying_Reports_in_Report_Builder/Creating_Required_Hidden_Parameters_for_Custom_Reports


Thank you.  I have used the Customer Success Center pages you referenced.  If it tells me there how to accomplish what I’m wanting to do, it is not spelling it out clear enough for me to understand.  I’m no expert in Report Builder, so that could be the problem. 😁


I think you need to add the structure code and planning code parameters then add the following to your report. Maybe easier to copy an rdl report and make the changes needed.

 

 


Hi Mario. Thank you for the tips.  That got me to the point where it will ask the user to enter the structure code (for the Work Portfolio).  If I know the code, I can enter it and can create a report.  However, most people don’t know their portfolio’s structure code.  A drop-down of all Work portfolios that a user has access to would be better option. But, the desired option is that the report recognize the portfolio that is active for the user when the user selects the report tile.  Any suggestions on how I can achieve this?  


is that structure_code parameter hidden? Check out this video  and see if ti makes sense. maybe also check out video 8 and 9 of the series as well. 

https://success.planview.com/Planview_Enterprise_One/Enterprise_One_Training_Center/Portfolios_Reporting_and_Schema_Learning_Videos/Add_Report_Parameter_to_Respect_Portfolio_Selection_from_the_Report_Tile_-_Self-paced_Report_Builder_Series_Video_11_of_27


This looks like exactly what I need!  I’ll let you know how it turns out when I get a chance to work on it.

Thank  you!


Thank you Mario!  It is now doing what I wanted it to do. 🙂


Reply