Need task field (non-custom field) with multi-line text support RRS feed

  • Question

  • Hello,

    Need task field with multi-line text support that will show on project server 2010 reports. The purpose is because I want to have an Agile Story description n these fields. Custom fields don't work, because OLAP cubes only permit custom fields that have associated lookup tables. So this would have to be a non-custom field that could take in a Task description of sorts that will have a story description.

    Any suggestions are greatly appreciated!!

    Monday, February 11, 2013 10:06 PM

All replies

  • dovendaven1 --
    There is no way to create a custom field that is not custom.  If you want to use a default text field, two possible fields you might be able to use would be Contact and Notes.  Somehow I do not think that will work for you, however.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    "We write the books on Project Server"

    Monday, February 11, 2013 10:10 PM
  • If you create your reports from the Reporting Database rather than from the OLAP cube you can have access to the 'normal' custom text fields regardless of their lookup table state.

    I build lots of SSRS or Excel Pivot table reports and have only used the RDB in the last several years. I normally dont even build an OLAP cube.

    That said you cannot have a true 'multi-line' text field at the task level. You only get 256.

    you could look into using sharepoint lists to capture your stories and then link the list items to the tasks that use that support that story.

    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

    Monday, February 11, 2013 10:16 PM