Announcements
No record found.
HI
My client is on GP 2016 RTM version, The Finance TB report from Dynamics GP works fine. When we try to run the TB summary and detail report in SSRS it is not displaying any data. I tried to execute the SP called in the report with parameters and it gives me the data.
I need help in this issue. Please guide me.
Regards,
Durai Murugan R
Hello Durai,
The first thing i would check is what Parameters are being used to run the SSRS Reports. My guess would be something is wrong with the dates.
If the Parameters are correct, are you using a Modified SSRS Report? If yes, does the core report product data? If this does, then we will need you to create a support case to allow us to look at the custom report.
Do you see the same issue when you run the SSRS report as the sa user? If so, then look at the security for the user that is getting the report blank when printing.
Another thing you can try is to re-deploy the reports to see if this corrects the issue.
I hope this helps!
Thank you!
Brandon Jarrett | Microsoft Support Engineer.
HI Brandon
Thanks for the reply. All the standard parameters are used in the SSRS reports. Report is not a modified one. I ran the report as the local admin, still it is not displaying any data.
I also re-deployed the reports and still it is not working.
Thank you for your response. I greatly appreciate it!
The next thing i would have you check is if you have Account Security turned on for the company. (Dynamics GP | Tools | Setup | Company | Company) If that is marked, unmark it and save and test to see if the report now prints.
Hi Brandon
Thanks for your response.
As you mentioned, Account security is turned on. I turned off the Account security and the report works fine.
I just want to confirm that if the Account Security is turned on then the SSRS Finance TB report will not work or any other settings we need to make along with Account Security.
The report that prints from GP to a file requires a lot of manual work to get it to add a "Column Restriction" to your FD (Financial Dimension) column type If you have Excel Report Builder (Microsoft Dynamics GP>>Tools>>SmartList standard TB summary (if you want a GP report and not MR or SSRS).
expressHR
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 622
André Arnaud de Cal... 532 Super User 2026 Season 1
CP04-islander 430
