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) / Report Writer field to...
Microsoft Dynamics GP (Archived)

Report Writer field to get data from a SQL view

(0) ShareShare
ReportReport
Posted on by William Kow 3,795

We have created a SQL VIEW in a company database, and we wish to get the data from this SQL VIEW to be shown in the Report (eg, RM Statement On Blank Paper).

Please advise whether it is possible to do this without using Modifier. Thank you very much in advance.

*This post is locked for comments

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Report Writer field to get data from a SQL view

    Thank you very much, Mariano. We will explore more for the VBA with Report Writer.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Report Writer field to get data from a SQL view

    Yep,

    Thanks for the reference Mariano. Still requires programming. If Modifier is available you have made them good to go! Sometimes I lose sight of more simple answers!

    Leslie

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Report Writer field to get data from a SQL view

    This is absolutely possible. Take a look at Using ADO with VBA with Report Writer over at Developing for Dynamics GP. The only one thing I can think of prior to implementing any code is that your view needs to be accesible to the DYNGRP role.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Report Writer field to get data from a SQL view

    William,

    It might be time to take this off line. My number is 972-814-8550. I'll try to help you when I get the specifics.

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Report Writer field to get data from a SQL view

    Hi William,

    Do you have any dexterity programmers on staff? How about Modifier with VBA. Depending on the Layout and information you want it could be possible with Modifer VBA. Which modules do you own? SmartList Builder, Modifier VBA, crystal?

    Is it important that it runs from the Dynamics interface? There a three thrd party products you may be interested. Fellow MVP Victoria Yudin at Flexible Solutions is good, Rockton Software has a product, and I think Accountable software may have a product.

    I' figuring you are on v 10.

    Let us know what you come up with.

     Kind regards,

    Leslie

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Re: Re: Report Writer field to get data from a SQL view

    Many thanks for your reply. BTW, we are seriously want to have the modified report (RM Statement On Blank Paper) to be able to get data from our pre-defined SQL VIEW, whether by using Dexterity Programming, Smart builder or whichever way. I wish wish you can provide some guidance on this matter. Many thanks in advance.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Report Writer field to get data from a SQL view

    William,

    To my knowledge you can not do what you want with Report Writer.  Since these are statements, you would be better served to create the reports with a database reporting tool like Crystal Reports. I imagine the 'programming' being referred to is Dexterity.

    Kind regards,

    Leslie

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Report Writer field to get data from a SQL view
    Could you please provide me the guidance on how can I use the programming way to enable the modified report to get data from SQL VIEW.

        Modified Report name : RM Statement On Blank Paper

    We have created a SQL VIEW that will extract all the SOP documents and AR transactions and classified them into different aging buckets (by calendar month rather than by no. of days).
    And we wish to have the RM Statement modified report to get data from our SQL VIEW to list out the SOP documents & AR transactions for a specific date.
    And then another set of data from SQL VIEW is put all those amounts into each buckets showing in the Statement report.

    Kindly assist me to achieve the above requirement. Thank you so much.

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at
    Re: Report Writer field to get data from a SQL view

    using report writer without programming as far as I know you cant view them.

    using smartlist builder this is possible.

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,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans