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 / Finance | Project Operations, Human Resources, ... / SSRS Report in Busines...
Finance | Project Operations, Human Resources, ...
Answered

SSRS Report in Business Analyzer Not Loading

(0) ShareShare
ReportReport
Posted on by dceworks 15

Hello All,

We are running GP 2016 (16.00.0641 R2) on SQL Server 2016 (SP1-CU15-GDR)(KB450522).  We have several custom SSRS reports that work great from the SSRS Manager/Viewer (ie webpage viewer).  I have added those reports to the Charts & KPIs folder within the company data directory.  Within GP, I have added these reports to the "Selected Reports" pane within the Business Analyzer Details window.  After logging out and back into GP, these reports are available to cycle through within the business analyzer however they load with a 0 byte count, and a rendered date of 1/1/0001.  I don't know if this is a permissions issue or what but I could use some troubleshooting guidance.  Is there a guide anywhere that details size/component restrictions with respect to displaying these reports in the Business Analyzer?

Thanks,

Chris  

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    We don't do much troubleshooting on custom SSRS reports, as that starts getting more on the SQL Reporting Services side than Dynamics GP, even though the report may be pulling GP data.

    Have you verified the report works fine when you access it directly from the Report Manager web page for SSRS?

    If it does, if you go to the area page in Dynamics GP, such as Financial or whatever series it is under, and click on Reporting Services Reports, select this report and attempt to view it, does it render correctly there?

    This would help determine whether the issue is with the Business Analyzer window/section of the GP Home page or not.

    For permissions, SSRS reports as far as data, are given via the RPT_ database roles. You could try assigning a WIndows account the RPT_PowerUser role under the system and/or company databases for GP and test, this would help rule out permissions or not for that report.

    Thanks

  • dceworks Profile Picture
    dceworks 15 on at

    Thank you for your response Derek.  I have verified that the reports do render correctly when launched from the Reporting Services Reports section.  The issue definitely seems to be with Business Analyzer.  Do you know if there is a limitation on data size for BA?  I took one of the reports and stripped out everything but the pie chart and that does load now in Business Analyzer.  The chart alone is less than useful however so I am trying to figure this thing out.  Again, much appreciation for your insight.

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    I know that there were some issues with BA in Dynamics GP 2016 R2 that were fixed in later versions.

    Even with default SSRS reports, I know I had a case with a similar issue and in my testing, with BA in GP 2016, I added 3 reports to be shown in BA, but it would only show 2 of the 3 reports at all.  

    To further test, I added a total of 10 reports to BA in GP 2016, again, even after refreshing, only 2 of the reports shown.

    However, in GP 18.3, I added 8 SSRS reports to show in BA in testing, and I can view and look at all 8 in the BA section of the Home page.

    Based on this, it does appear there is an issue with BA section of the GP Home page in Dynamics GP 2016 R2 that was fixed in later versions.

    My recommendation would be to access these custom SSRS reports via the 'Reporting Services Reports' links on the area pages in GP 2016 R2, until the client upgrades to Dynamics GP 18.3 or so.

    Thanks,

  • dceworks Profile Picture
    dceworks 15 on at

    Thank you again Derek.  This seems like the likely cause.  I believe we have an update/upgrade scheduled soon so hopefully that takes care of it.  When/If we get there I will post back with the result but I have marked your answer as correct for now.  Merry Christmas!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans