web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Edit Excel Report with...
Microsoft Dynamics GP (Archived)

Edit Excel Report with SQL Server Report Builder, Get path error

(0) ShareShare
ReportReport
Posted on by RussK 1,875

With 'SQL Server Reporting Services - Native' installed, attempting to edit an Excel Report in GP 2013 R2 gives an unusual error, as follows:

System.Web.Services.Protocols.SoapException: The path of the item '/\\craig-win8lap\GPShare\GPData\Excel Reports\Reports\TWO\Sales\TWO SalesTransactions This Week's Returns.xlsx' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/\\craig-win8lap\GPShare\GPData\Excel Reports\Reports\TWO\Sales\TWO SalesTransactions This Week's Returns.xlsx' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.

   at Microsoft.ReportingServices.Library.ReportingService2010Impl.GetItemType(String ItemPath, String& Type)

   at Microsoft.ReportingServices.WebServer.ReportingService2010.GetItemType(String ItemPath, String& Type)

=========================

Not sure what is going on. The feature report for SQL Server 2012 shows SSRS-Native. The reports deployment seemed to go OK, and I actually re-ran it for excel reports to be sure, but then got this error again when I attempted to edit an excel report. Interestingly, editing an SRS report is fine. Anyone seen this, or have any ideas? Thanks in advance for any help you can provide.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Edit Excel Report with SQL Server Report Builder, Get path error

    The likely scenario is permissions related - my team jokes that 99% of our clients' errors are permissions related.  You may want to check your sharing settings on the folder you're using.  In this case you might want to give the EVERYONE group access.  One of the reasons I suggested you map the drive, is if there is a permissions problem, typically you can't map the drive, or are prompted to use permissions from an authorized user.

  • RussK Profile Picture
    RussK 1,875 on at
    RE: Edit Excel Report with SQL Server Report Builder, Get path error

    Of course, the 'craig-win8laptop...' references the laptop on which we're installing. I have installed GP 2013R2 on 3 laptops recently, and the edit excel reports on each of the laptops renders the same error, as if there is something with Win7 or Win8, or a non-server OS, that is causing this.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Edit Excel Report with SQL Server Report Builder, Get path error

    the error message seems to point to an odd file path '/\\craig-win8lap...

    /\\ doesn't make a lot of sense.  GP understands both \\ and // formats but not mixing them.  Sometimes GP insists on the // format.  

    As a test only, try mapping the \\craig-win8lap\ as a drive and use the letter, instead of the UNC to deploy the reports.

  • RussK Profile Picture
    RussK 1,875 on at
    RE: Edit Excel Report with SQL Server Report Builder, Get path error

    Sorry for the long reply time, Jonathan. Both ways... tried the port number, even though it is the default, to see if it helped.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Edit Excel Report with SQL Server Report Builder, Get path error

    When you deployed the reports did you put :80? I had a case a few months ago where they customer was using Server:80 and they got this error. When we took out :80 and redeployed the reports the error went away.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans