Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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"

    Thanks!

    Tuesday, March 8, 2011 3:42 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    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