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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

  • Verified answer
    Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    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 on at

    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.  

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans