Skip to main content

Notifications

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

  • Verified answer
    coquisalsa Profile Picture
    2,725 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

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

  • GovindDevda Profile Picture
    617 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    Hey coquisalsa  , Thanks  for guide me.

    Regards,

    Govind Devda

  • GovindDevda Profile Picture
    617 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    Hey Arunprasath thanks for giving path i got the file.

    Regards,

    Govind Devda

  • Verified answer
    soma Profile Picture
    24,410 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    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!!!

  • Suggested answer
    coquisalsa Profile Picture
    2,725 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    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
    Community Member Profile Picture
    on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    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

  • GovindDevda Profile Picture
    617 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    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

  • GovindDevda Profile Picture
    617 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    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

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

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

  • Redbeard Profile Picture
    12,931 on at
    RE: Is it possible to launch a SQL Reporting Services report from Dexterity?

    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.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans