Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Are KPI on business po...
Microsoft Dynamics GP (Archived)

Are KPI on business portal working when SSRS is Sharepoint integrated mode

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi

After chaning SSRS from Native to Sharepoint integrated mode KPIs are not working. While new custom reports which I developed in SSRS are deployed on Sharepoint working fine. The only issue is KPIs are not showing any thing.

When I try to deploy SSRS reports in GP as sharepoint integrated it gives error "You do not have persission to the location where you want the reports to be deployed" I am the admin on GP and on Sharepoint also.

I tried to edit webparts in sharepoint for the KPIs and unable to select the kpi path and get message this features is not available for sharepoint integrated modee.

If i reintall KPIs will I loose all changes done on other pages like I added many new libraries and do not want to loose any thing. I just need that KPIs should display like these were displaying while the SSRS were in Native mode. I have to use sharepoint integrated mode as there are lot of reports I have deployed and do not want to go back to SSRS native mode.

I want to make sure that if the SSRS are sharepoint integrated mode then KPIs are working ok?

Any help will be appriciated.

My environemt is

GP 2010 seperate server

Sharepoint 2010 + SSRS SQL 2008 R2 seperate server (business portal 5.1)

 

Regards,

 

 

and  My environment is following

GP 2010  seperate server

Sharepoint 2010 + SSRS Sql 2008 R2 sharepoint integrated mode

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Are KPI on business portal working when SSRS is Sharepoint integrated mode

    Dear Rob

    Thank you very much! You made my day. I have no words to say you thank you. You pointed the right config file and after adjusting it centers display nice charts. Only adjusting in config works fine it did not require  repairing.  

  • Verified answer
    Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    RE: Are KPI on business portal working when SSRS is Sharepoint integrated mode

    Zaheer,

    Thanks for the update.  I believe a Business Portal "Repair" action will fix this for you, but here are some additional details.  The following (approximate location - <drive>\inetpub\wwwroot\wss\VirtualDirectories\80\bin) will hold this file:  Microsoft.Dynamics.GP.ReportingServices.Common.ReportViewerSettings.config.  The information within this file needs to change to support your transition from native to SharePoint Integrated deployed reports.

    Thanks

    Rob

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Are KPI on business portal working when SSRS is Sharepoint integrated mode

    I have deployed the reports as sharepoint integrated. I added a site owner user and enter the creditial for that user when it ask me to enter windows user name in GP Reporting Tools Setup.

    Now I can view these reports in sharepoint and there is no issue. Now I want to update the webparts in dashaboard centers with new path. When I installed Business Portal that time the SSRS was native and it took the path of native ssrs now it is sharepoint and the kpis need to be updated . Where can i update relative path for report in webpart? When I click on choose path in edit webpart window it gives me message that this feature is not available for sharepoint integrated. So I just want to write path manually but it takes company as prefix so I want to know where (config. etc) can i find the path prefix so that i will adjust it as per my current report library for dashborad centers

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Are KPI on business portal working when SSRS is Sharepoint integrated mode

    The GP 2010 version is 11.00.2044. The SSRS native mode is woking ok but I want to deploy it as sharepoint integrated and I enter the site name in reporting tool setup like  http://myservername/ReportServerSQL and the report libirary is SSRSreport where I have added three types of documets Report Model, DataSource and Report.. Upon clicing deploy error appears with message The SQL Service Reporting Service setup is not valid. While when i enter the same url in IE it works fine. If I enter sharepoint site port then the another windows appear "Enter windows user name " after that it gives error you do not have permission to the location where you want reports to be deployed.

    Sharepoint has correctly configured for SSRS. I have created many custom reprots and deployed on Sharepoint and these are working ok. I just want to deploy GP SSRS reports  from native to sharepoint mode.

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    RE: Are KPI on business portal working when SSRS is Sharepoint integrated mode

    Zaheer,

    Dynamics GP and Business Portal both work with SRS reports in native mode.  Are you using Dynamics GP 2010 RTM?  What is the path that you are entering when trying to deploy?

    Thanks

    Rob

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans