"Invalid Column Name" in Excel reports after updating Resource Departments enterprise custom field RRS feed

  • Question

  • Hello - I have a few dashboard reports that are now failing to update after I changed the Resource Department enterprise custom field to accept multiple values (check box). I imagine this makes the database field multi-valued and hence did something to break the report, but I'm not sure what to do since this is preventing synching to the SQL Server database. I am using the "ProjectsandAssignments" default template to create the reports, and the default template no longer works either.

    Actual Error - "Invalid Column Name - Resource Departments"


    Tuesday, March 8, 2011 3:42 AM


  • Hi JSQuestions,

    Unfortunately its a reported bug, changing custom field to accept the multiple value cause issues . its already been mentioned by Brian in his blog , go through the post and see the workarounds he as presented resolved your issue. or you can log a support call, because fix is not released yet, free of charge since its already declared as fix.

    Hope this helps.

    | Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |
    Tuesday, March 8, 2011 6:51 AM