Unlock Locked fields in a report or a view | Community
Skip to main content
C
CsengelleKo
Level 2
June 28, 2021
Solved

Unlock Locked fields in a report or a view

  • June 28, 2021
  • 3 replies
  • 1120 views

Morning all,

Wondered if anyone could help me out with an issue.

Tried to create a view in the NWE for a portfolio, where if needs be you could easily change the program the project belongs to.

Looks like that field is locked.

Tried to create it in a report, but again, that field is locked.

The team that asked for it, would regularly move projects from one program to the other.

Please can you help me out?

Many thanks,

Csengi

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by MollieSh

Hi,

To do that you would need to use text mode for a collection in your program report something like:

displayname=Projects in the Program

listdelimiter=<p>

listmethod=nested(projects).lists

textmode=true

type=iterate

valuefield=name

valueformat=HTML

Hope that helps. Mollie

3 replies

N
NarothneeJe
Level 3
July 6, 2021

Hey,

So I did a project report that was pulling in all of our projects and the program associated with it. You're right, you can edit or change the program ON the field BUT, if you click on a checkbox and click the pencil to edit, it bring up the details of that project where you can change the program.

I hope that helps. I'm not sure if you can edit that field on the report so easily.

M
MollieSh
Level 4
July 6, 2021

Hi,

If you do a Program type report and add the Portfolio Name via text mode (Portfolio ID is only available without text mode) you can edit the program name inline.

displayname=

linkedname=direct

namekey=portfolio:name

querysort=portfolio:name

textmode=true

valuefield=portfolio:name

valueformat=HTML

-Mollie

    C
    CsengelleKoAuthor
    Level 2
    July 7, 2021

    Hi Mollie,

    brilliant, that seems like it did the trick. Thank you.

    How would I modify this to be able to see the list of the projects sitting inside that portfolio? And still have the ability to see the programs as well.

    Many thanks,

    Csengi

    M
    MollieShAccepted solution
    Level 4
    July 7, 2021

    Hi,

    To do that you would need to use text mode for a collection in your program report something like:

    displayname=Projects in the Program

    listdelimiter=<p>

    listmethod=nested(projects).lists

    textmode=true

    type=iterate

    valuefield=name

    valueformat=HTML

    Hope that helps. Mollie

    C
    CsengelleKoAuthor
    Level 2
    July 8, 2021

    Hi Mollie,

    You are a star!!

    We are so close :)

    Could we somehow get the projects to show up as individual lines? At the moment they are all nested.

    Many thanks,

    csengi

    M
    MollieSh
    Level 4
    July 8, 2021
    Hi Csengi, That's the thing about collections; they can't be individual lines. It's a one to many relationship between programs and projects. I don't know of any other way to show it. -Mollie Mollie Shatek, PMP M +1 303 204 3000 **Click HERE to enter a Workfront Help/ Change/ New or Modified User Request**
    Terms & ConditionsAccessibility statement

    Loading footer...