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) / Best way to link to cu...
Microsoft Dynamics GP (Archived)

Best way to link to custom SSRS reports?

(0) ShareShare
ReportReport
Posted on by Alison Michaud 285

We've just developed a custom SSRS report using Dynamics tables.

In case this makes a difference, we haven't yet distributed Dynamics GP reports to our reporting server.

Is there a way in Dynamics to provide a link (url) to our custom report only to certain users?

We've considered using user classes, but the three users who need access to the report have two different classes and we wanted to avoid providing a link to other users who share the class, but don't have access to the report.

Why not just give them the URL?  That is always an option but we'd like them to think of the report as a function of GP and for the link to be in a place that we can control.

Thank you for any ideas or insight!

*This post is locked for comments

  • Mary Jakel Profile Picture
    Mary Jakel 50 on at
    RE: Best way to link to custom SSRS reports?

    at this time I only have one report that I need this for.  I am searching for an example of the code that would be used in VBA to open an SSRS report using some of the fields from the window to pass as parameters.  any help would be appreciated.

    thanks

  • Community Member Profile Picture
    Community Member on at
    Re: Best way to link to custom SSRS reports?

    I was going to suggest Rob's method.  I have about 30 custom reports that I've deployed using this method and it works quite well.  I agree that it is easier to deploy the reports first, just to get the folder structure.

    Regards

    Aaron

  • Verified answer
    Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: Best way to link to custom SSRS reports?

    A. Michaud,

    Yes, if you deploy the canned reports and save your custom report in the SSRS folder hierarchy, you can choose it and view it in Dynamics GP.  While it's not necessary to deploy the canned reports, it's probably the easiest.  Dynamics GP looks for certain folders, so you'd need to know which folders to create if you didn't deploy the reports.

    Thanks

    Rob

  • Alison Michaud Profile Picture
    Alison Michaud 285 on at
    Re: Best way to link to custom SSRS reports?

    Wow, thank you for your replies!

    Aaron, we're on GP2010.

    Victoria, GP Reports Viewer looks really slick and may be an option for us once we have more reports.

    Tim, you're right, once we have more reports it probably won't be feasible to keep creating custom buttons, but it's good to know this is possible.

    Rob, regarding your suggestion, are you saying that if we deploy the canned SSRS reports from Dynamics, we can then save a custom report to the same SSRS folder, and it will be displayed in Dynamics?  Is there anything special we'd have to do to get this to work?  Is it necessary to fully deploy all the canned reports in order to gain this functionality?

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: Best way to link to custom SSRS reports?

    A. Michaud,

    Have you considered saving it with the rest of the Dynamics GP reports so that it could be viewed on the home page?  Users can only see the reports for which they have been given access, so the report would be viewed in Dynamics GP but managed outside.

    Thanks

    Rob

  • Verified answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: Best way to link to custom SSRS reports?

    You could use Modifier to create a button and put VBA on the button that pops IE open with the link to the report (you can "build" the link and even pass some of the data from the screen into the link as parameters for the report).  You only give access to the modified screen to those who need it.  I agree with Victoria - one report is OK this way,  a bunch of them would be better with GP Reports Viewer.

    Tim

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Best way to link to custom SSRS reports?

    You might want to consider something like our GP Reports Viewer (www.gpreportsviewer.com/gpreports.html) to set up your SSRS reports inside Dynamics GP.  With GP Reports Viewer you can create shortcuts for the reports on just about any Dynamics GP window and even pass in parameters from fields on the window to the reports to make it much more user-friendly.  You would also have complete control over what users see what reports.

    Of course, if you're planning on just one report, looking at an add-on solution for this may be overkill.  However, if you're planning on setting up a number of reports (and usually once you start offering users reports, they just want more) it might be worth it and could save you a lot of administrative and setup effort while providing a much more user friendly way for your GP users to run SSRS reports.

  • Community Member Profile Picture
    Community Member on at
    Re: Best way to link to custom SSRS reports?

    What version of GP are you on?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans