web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

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

    using smartlist builder this is possible.

  • William Kow Profile Picture
    William Kow 3,795 on at
    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.

  • L Vail Profile Picture
    L Vail 65,271 on at

    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

    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

    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

  • L Vail Profile Picture
    L Vail 65,271 on at

    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

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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

    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

  • William Kow Profile Picture
    William Kow 3,795 on at

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans