I am trying to format some of the columns in a Portfolio Analyzer view
(based on a project server OLAP cube). I can successfully format any
calculated field that I define, but when I try to change the format on some
of the standard fields (such as work), the changes appear when I am in
design mode, but when I look at the view normally, the changes are gone, and
when I go back into design mode the changes are gone.

For example, the "Work" column. It has a default format of ###,##0.0"h" and
I want to change it to not show decimal places. So I do this: ###,##0"h" and
in the design view, it changes correctly. So I save the view, exit, and open
up the view normally. Changes not there - still the orginial format. And
when I go back into design mode, it's still the original format.

Is it not possible to change the format for "normal" project server fields?
What's up with that??

Thanks,
Kris

I found the answer - from Microsoft (basically, you CAN'T change format for
standard fields in PWA views):

I believe this is by design. Let me explain - basically, when the page is
loaded into PWA, our ASP code walks through the fields via the OWC object
model. For the fields that we recognize, we overwrite the format with what
we have in our resource dll's. This is how we support multi-language pack
scenarios as well. Of course we don't do this for custom calculated measures
that you might insert since we don't know about them.
As far as I can think, there's isn't an alternative to this.



"Kris R." <kris (AT) nospam (DOT) com> wrote