Microsoft Dynamics GP

Home » Microsoft Dynamics GP » Microsoft Dynamics GP Forum » All Tags » Report Writer » VBA

Browse by Tags

Tags
Related Posts

  • Forum Post: Re: Third party

    David Musgrave [MS]
    Your easiest alternate is to use VBA if you are registered. See the following blog articles: RW - Accessing any SQL data from a Report Example Using ADO with VBA with Report Writer Using VBA with Report Writer David Musgrave [MSFT] Escalation Engineer - Microsoft Dynamics GP Microsoft Dynamics...
    on 6 Apr 2009

  • Forum Post: Re: Report Writer

    David Musgrave [MS]
    Hi Bsaad Are you registered for Modifier & VBA, you can use VBA to access data without needing a table relationship. See the articles below: http://blogs.msdn.com/developingfordynamicsgp/archive/2008/07/17/vba-accessing-any-sql-data-from-a-report-example.aspx http://blogs.msdn.com/developingfordynamicsgp...
    on 20 Apr 2009

  • Forum Post: Re: SQL User-Defined Functions in ReportWriter

    David Musgrave [MS]
    There are many Dexterity User Defined functions available in the report writer, but the only way to call a SQL UDF would be via Visual Basic for Applications (VBA) and Active X Data Objects (ADO). See the posts below for info. http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/01/using...
    on 31 Jan 2010

  • Forum Post: Re: Re: Report Writer field to get data from a SQL view

    wk
    Thank you very much, Mariano. We will explore more for the VBA with Report Writer.
    on 6 Jul 2010

  • Forum Post: Re: Re: Modifier not enable in Report Writer, but OK in GP form

    wk
    Thank you so much to Leslie and Mariano. BTW, if I managed to do VBA programming for a modified report, i would like to know whether need to pay extra fee/license for VBA code use in the Modified report ? It is the same way, by importing the Package on other workstation, the VBA codes goes together with...
    on 9 Jul 2010

  • Forum Post: Can other GP computer without license key for Modifier, to use the package with VBA code

    wk
    My laptop is installed with GP with full license key to use all the modules including Modifier. I have modified a Report on my computer, and this modified report contain VBA codes (Using Microsoft Visual Basic) and then I exported this Report into a package. May I know if I import this package into another...
    on 13 Jul 2010

  • Forum Post: Re: Re: Re: Re: How VBA variable pass a value to a Report calculated field ?

    wk
    Thank you so much David. I do not even aware that the report calculated "field" is also need to "add" into the VBA. All the while I thought just only need to add the "Modified Report" into the VBA -- so i have ignored the report objects/fields are also need to add into VBA...
    on 13 Jul 2010

  • Forum Post: VBA parameter cause problem to SQL Stored Procedure

    wk
    I need to prepare a different set of records for Report Writer to printout. I can find a few sample of how to use VBA and I managed to retrieve SQL tables and pass to recordset, However, I do not managed to find VBA samples on how to do define parameters for SQL stored procedure , especially for date...
    on 18 Jul 2010

  • Forum Post: Can I display a box containing a dynamic set of group totals at end of report

    Sandy Westman
    I would like to modify the SOP Picking Ticket Order Entered report to calculate the total quantity to pick per item class and to display the totals for each class at the end of the report. This is because the pick tickets can be many pages long, and we want the pickers to be able to double-check the...
    on 4 Apr 2011