Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Visual Reports Unknown error

Answered Visual Reports Unknown error

  • Tuesday, October 12, 2010 2:21 PM
     
     
    Sign In to Vote
    0

    I am using Project Standard 2010 and Excel 2003 sp3 (don't have Visio at all).  When I try to run visual reports I get an Unknown error.  I cannot save a .cub either.  Get the same error.

     

    thanks.

     

All Replies

  • Tuesday, October 12, 2010 4:08 PM
    Moderator
     
     
    Sign In to Vote
    0

    Dkourtis:

    Without Visio 2007 or better installed, you cannot run any of the Visio reports. However, you should be able to use the Excel reports. Have you tried running a repair on Excel? Try that first and see if it makes a difference.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
     
  • Tuesday, October 12, 2010 6:50 PM
     
     
    Sign In to Vote
    0

    Hi Gary,

    Ran repair on Excel and am still seeing the same behavior.  Any other recommendations?

    thanks.

     
  • Tuesday, October 12, 2010 7:11 PM
    Moderator
     
     
    Sign In to Vote
    0
    Dkourtis --
     
    It was my understanding when Microsoft released Microsoft Project 2010 that users can create Excel Visual Reports using Excel 2003, 2007, or 2010.  However, at a client site last week, most of my students in class had the 2003 version of Excel, while a few of them had the 2007 version.  None of the Excel 2003 users were able to create an Excel Visual Report, while all of the Excel 2007 users were able to do this.
     
    Based on this one set of users, I suspect that you cannot create an Excel Visual Report using Excel 2003.  Since Microsoft staff now peruse this user forum on a pretty regular basis, I would gladly ask them to comment.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

     
  • Tuesday, October 12, 2010 11:10 PM
     
     
    Sign In to Vote
    0
    I am also unable to create a visual report with Project 2010.  I have Excel 2007.  While attempting to create a visual report, or saving a cube for that matter, I get an Unknown Error.
     
  • Thursday, October 14, 2010 4:43 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Per the question around Project 2010 Visual Reports working with Excel 2003, it looks like there is a setup issue. Project 2010 installs OLAP10 but for some reason when Excel 2003 is there, it isn't getting installed correctly.

    To workaround this issue, you need to manually install the Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider. You can get that through this link - http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4

     

    Rod - not sure what is causing your issue. Let me investigate.

    Thanks,

    Heather

    • Marked As Answer by Dkourtis Thursday, October 14, 2010 4:29 PM
    •  
     
  • Thursday, October 14, 2010 3:47 PM
    Moderator
     
     
    Sign In to Vote
    0
    Heather --
     
    This is good to know, and helps me to be aware of issues at our client sites in the future.  Thanks!

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

     
  • Thursday, March 03, 2011 2:23 AM
     
     
    Sign In to Vote
    0

    Hi Heather,

    I have this same issue.  I did install Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider but I still receive this error for all visual reports.  I currently use MSProject 2010 and I have Excel 2010 as well.  Has there been any word on another workaround? I actually can see the reports through Reports/Custom...it goes straight to print screen and through print preview I can see them there, which is odd but I was able to get my assignments done for my class that way at least.

    Thanks so much,

     

    Tracie Hayes

     
  • Tuesday, June 14, 2011 11:34 AM
     
     
    Sign In to Vote
    0

    For the first time, I'm using Project 2010 for a "real" project, along with Excel 2010. Previously used Project 2007.  Looking like I have to go back to it.

    Having real trouble making Visual Reports work in Project 2010 with Office 2010. 

    Have only Office 2010 components on this machine. Was getting the dreaded "unknown" error when trying todo a Cash Flow to Excel.  Did a "repair" on Project 2010 and Office 2010.  Now Project tells me the source MPP file is "read only" (it is not) and asks me if I want to save a copy? If I say "Yes", it gives me a save dialog box then Project cancels. If i say "no", it also gives me a save dialog box and then crashes.  The "Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider" above appears to be 64 bit only (and I'm guessing the "repair" should have repaired.

    Any suggestions?

    (I was told by the PrimaVera guys working for the main project (I'm part of the Owner's team), that Project doesn't work. They cold be right.)

     

    --rms www.rmschneider.com
     
  • Friday, May 04, 2012 1:38 AM
     
     
    Sign In to Vote
    0
    I am using Project 2010 and Excel 2007 and experience this same error when I set Select level of usage data to include in the report: to Weeks. However, it works for every other setting. Of course, the resulting PivotTable when using the Days setting includes a Week grouping level. I did not install the OLE DB Provider. However, I have repaired Project, but I am not sure it was necessary since the Weeks setting failed before doing so, and the Months setting worked.
    • Edited by MikeMoses Saturday, May 05, 2012 8:38 PM
    •