Share via


Report Writer Articles & Links

This is a page to provide links to Report Writer related articles and materials.

Troubleshooting Knowledge Base (KB) Articles

How to use and troubleshoot Report Writer in Microsoft Dynamics GP (KB 861803) Secure Link

How to re-create the Reports.dic file in Microsoft Dynamics GP (KB 850465) Secure Link

Report Writer Functions Knowledge Base (KB) Articles 

How to access information about Report Writer functions in the Microsoft Dynamics GP SDK (KB 928172) Secure Link

How to use Customization Maintenance packages to enable Great Plains Report Writer functions from a 3rd party report dictionary (KB 862665) Secure Link

How to display a date in any format in a report in Microsoft Dynamics GP (KB 925970) Secure Link

How to round a calculated field in Report Writer in Microsoft Dynamics GP (KB 872275) Secure Link

How to display a string label instead of an integer representation of a radio group in Microsoft Dynamics GP (KB 926393) Secure Link

 

Graphics Knowledge Base (KB) Articles

How to add a graphic to a Report Writer report (KB 855288) Secure Link

How to prevent the image quality of a graphic from being reduced when you print a graphic from Report Writer in Microsoft Dynamics GP (KB 854470) Secure Link

 

Fonts Knowledge Base (KB) Articles 

Font used when Best Text Fit is marked (KB 849370) Secure Link

How to control the printer font size in Great Plains (KB 869078) Secure Link

Printer Fonts Selected by Dynamics (KB 870341) Secure Link

 

Other Knowledge Base (KB) Articles 

Copying The Layout From a Modified Invoice to an Unmodified Invoice in version 6.0 (KB 856003) Secure Link

Formats Not Exported to .Package Files (KB 851092) Secure Link

 

Extender Knowledge Base (KB) Articles

How to create a calculated field in Report Writer to print Extender fields in Microsoft Dynamics GP reports (KB 935385) Secure Link

 

Training Materials

Report Writer in Microsoft Dynamics GP 9.0 Secure Link

Direct download of archive file

Note: The training materials are for version 9.0. Don't worry, this is the latest version and everything is still valid for later versions of Microsoft Dynamics GP and Dexterity.

  

26-Apr-2011: Added direct link to training materials.

Comments

  • Anonymous
    July 24, 2008
    The Report Writer Articles & Links page and the Developer Toolkit Article & Links page have been

  • Anonymous
    July 29, 2008
    KB 926393 refers to "the Report Writer Programmer's Interface document in the Software Development Kit". The only document I'm aware of in the SDK is the RW_Func.doc that you wrote.  Is this what the KB is talking about or is there another reference out there somewhere?

  • Anonymous
    July 29, 2008
    Hi Leslie That's the one.  I will be adding a posting on Report Writer functions and will include the document and also a package that demonstrates most of the functions in use.

  • Anonymous
    August 31, 2008
    During my time in the partner channel, I worked with a number of consultants who had a number of problems

  • Anonymous
    August 31, 2008
    When printing Text Reports for Microsoft Dynamics GP to a laser printer they are usually printed using

  • Anonymous
    October 20, 2008
    Over the years I have had many requests for training on the various tools available for customising or

  • Anonymous
    October 29, 2008
    Hi Good posts... But I'm a new one in this, and want to know, How could I do to link a new Report with a buttom in Dynamics GP? I mean I created a new Report but can't find the way to link them...

  • Anonymous
    October 29, 2008
    Hi George You did not mention the tool that you are using. If using Dexterity, use the run report command. If using VBA, look at the following sample which uses pass through Dexterity sanScript with the run report command. http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/29/purchasing-terms-conditions-example.aspx David

  • Anonymous
    June 04, 2009
    How can I add a virtual table so Report Writer can see it in the table lookups?

  • Anonymous
    June 09, 2009
    Hi Dan As far as I know a virtual table cannot been referenced from a table relationship so you could not add it to a report.   Using VBA, you can access data from any table or SQL View. Have a look at http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/30/using-vba-with-report-writer.aspx David PS: There are only 2 virtual tables in v10.00 Dynamics.dic anyway.

  • Anonymous
    August 11, 2009
    Have you been able to create a GP payables check to print on legal size check stock stub-check-stub-check by modifying the check layout in Report Writer?

  • Anonymous
    August 11, 2009
    Hi Lauran Can't say I have ever tried.  I would suggest you ask on the newsgroups/forums. If you are having a specific problem, make sure you explain what it is in your post. Thanks David

  • Anonymous
    November 17, 2009
    Hi...I am trying to link a UDF to a report.  Specifically, I want to add Receivings UDF Text 1 to the check stub as a description of the voucher. So far all my attempts have been unsuccsssful.  Can you point me toward some sample code or a sample explanation on how to do this? Thanks, Neil

  • Anonymous
    November 17, 2009
    Hi Neil Can I suggest that you ask this type of question on the newsgroups where others can answer and also where others can benefit. There are links on the left hand side of this blog. When you post, please let us know the exact report name so we can work out if it will be possible to create a chain of table relationships to the POP_Receipt (Purchasing Receipt Work) and POP_ReceiptUserDefined (Purchasing Receipt User-Defined) tables.  If not, you can also look at VBA to directly acess the POP_ReceiptUserDefined (POP10306) table via ADO & SQL. David

  • Anonymous
    February 01, 2010
    Hello David, do you know how to call SQL Reporting Services from Dexterity? Thanks Marcos

  • Anonymous
    October 12, 2010
    Hi there! Is it possible to set the paper size of the report? I have design three different report with three different paper size thanks Arnold

  • Anonymous
    October 13, 2010
    Hi Arnold I answered your similar question when you asked on another post. You cannot define paper size in the report writer. However, you can define custom page sizes is most printer drivers. Dexterity reads the page size from the printer driver. I would suggest using Named Printers to select the printer and/or adjust settings. David

  • Anonymous
    May 24, 2011
    Hi David, Is it possible to display bank account details e.g bank account number or code in check remmitance advice(CB_Check_Remittance)? I woud really appreicate your input. regards, Charles

  • Anonymous
    May 24, 2011
    Hi Charles Blog comments are not the best method of providing support. I suggest you try the newsgroups or forums. Also have a look at the following articles as they show methods of getting data onto a report when it is not possible to create a relationship to the appropriate table.  Any data stored in a table can be accessed and added to a report. blogs.msdn.com/.../using-ado-with-vba-with-report-writer.aspx blogs.msdn.com/.../how-to-add-item-category-long-descriptions-to-reports-using-the-support-debugging-tool.aspx David

  • Anonymous
    June 19, 2013
    David, Do you know of a technique in Report Writer to print fields from an Extender Form rather than from an Extender Window? Thanks Wassim