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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Is it possible to launch a SQL Reporting Services report from Dexterity?

(0) ShareShare
ReportReport
Posted on by 617

Hi there,

Hi i am new in dexterity please let me know , 
Is it possible to launch a SQL Reporting Services report from Dexterity? If
so, could you please point me to the documentation that shows how to do this.

Thank you!
Govind Devda

*This post is locked for comments

I have the same question (0)
  • Redbeard Profile Picture
    12,931 on at

    I can confirm I have seen this done by a developer before. I am unaware of where to find the documentation to explain how to do this.

  • Suggested answer
    Community Member Profile Picture
    on at

    You can find the help documentation in Chapter 43 of Dexterity Integration Guide.

  • GovindDevda Profile Picture
    617 on at

    Sorry Raheel i did't find any Dexterity Integration Guide

    Please could you give me complete path where i find this file

    Regards,

    Govind Devda

  • GovindDevda Profile Picture
    617 on at

    Hey Harry thanks for reply , but in future if you find any helpful document then please share with me..

    my personal email id is govind.devda@live.com

    Regards,

    Govind Devda

  • Verified answer
    Community Member Profile Picture
    on at

    You can find IG.pdf(Integration Guide) under C:\Program Files (x86)\Microsoft Dexterity\Dex 14.0\Manuals, if you have dexterity installed. Chapter 43: SSRS Report Access

  • Suggested answer
    coquisalsa Profile Picture
    2,725 on at

    Hi,

    It is very straight forward to call a SSRS report using Dexterity and pass parameters to it. Following there is an example:

    local integer l_SopType;
    local string l_SopNumber,l_Url;

    l_Url = "http://reports/ReportServer/Pages/ReportViewer.aspx?%2fCustomer+Support%2fInvoice+Product&rs:Command=Render&SOPNumber=" + l_SopNumber + "&SOPType=" + str(l_SopType);

    run application "", l_Url;

    Thanks

    Jorge

  • Verified answer
    soma Profile Picture
    24,410 on at

    Govind,

    Welcome to community!

    The dexterity integration guide will help you to assign the SSRS reports to any GP window and set default SSRS reports. If you want the same functionality, you can follow the guide.

    If you want to run the SSRS report from GP window, just use the "run application" code to call the deployed SSRS report from Dexterity as per the Jorge suggestion.

    Note: Before using the run application script, make sure the link is working on IE.

    Hope this helps!!!

  • GovindDevda Profile Picture
    617 on at

    Hey Arunprasath thanks for giving path i got the file.

    Regards,

    Govind Devda

  • GovindDevda Profile Picture
    617 on at

    Hey coquisalsa  , Thanks  for guide me.

    Regards,

    Govind Devda

  • Verified answer
    coquisalsa Profile Picture
    2,725 on at

    Please Verify this answer if it has been useful to you. This could help others trying to solve the same or similar problem.

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans