View/read only format a column based on a custom field

[LukaszMatyszewski]

Is it possible to format a column results in project report so that its view/read only?

I have an extensive report containing both custom data and calculated columns. Id like to restrict all users to change the custom data on this report.

[Sven-iX · Accepted solution]

Hi @LukaszMatyszewski 

yes, two approaches:

1. If you use valueexpression instead of valuefield that column just prints out the value and is no longer connected to the field. 
   • valuefield=SomeField       >     valueexpression={DE:SomeField}
   • Note that if you have fields where the label/value are different valueexpression will print out both label and value
     
     
2. you can add makeFieldEditable=false in text mode to leave it as is (ie. showing exactly what it does out of box) and you disable inline editing. 

In your case I'd start with #2 on the columns you want to make non-editable.

[Doug_Den_Hoed__AtAppStore]

Hi @LukaszMatyszewski,

Another option is to create a dedicated Read Only user account, ensure it has only view access to all of the information of interest, then update any such report to "Run As" that Read Only user.

Regards,

Doug

[LukaszMatyszewski]

Even better!

Thanks Doug!

[Sven-iX]

Oh that is slick. Love this!

[LukaszMatyszewski]

That said, I do have a trouble to make it work. Im not sure yet what is the problem.