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)
How to re-create the Reports.dic file in Microsoft Dynamics GP (KB 850465)
Report Writer Functions Knowledge Base (KB) Articles
How to access information about Report Writer functions in the Microsoft Dynamics GP SDK (KB 928172)
How to display a date in any format in a report in Microsoft Dynamics GP (KB 925970)
How to round a calculated field in Report Writer in Microsoft Dynamics GP (KB 872275)
Graphics Knowledge Base (KB) Articles
How to add a graphic to a Report Writer report (KB 855288)
Fonts Knowledge Base (KB) Articles
Font used when Best Text Fit is marked (KB 849370)
How to control the printer font size in Great Plains (KB 869078)
Printer Fonts Selected by Dynamics (KB 870341)
Other Knowledge Base (KB) Articles
Copying The Layout From a Modified Invoice to an Unmodified Invoice in version 6.0 (KB 856003)
Formats Not Exported to .Package Files (KB 851092)
Extender Knowledge Base (KB) Articles
Training Materials
Report Writer in Microsoft Dynamics GP 9.0
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 beenAnonymous
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 problemsAnonymous
August 31, 2008
When printing Text Reports for Microsoft Dynamics GP to a laser printer they are usually printed usingAnonymous
October 20, 2008
Over the years I have had many requests for training on the various tools available for customising orAnonymous
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 DavidAnonymous
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 DavidAnonymous
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, NeilAnonymous
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. DavidAnonymous
February 01, 2010
Hello David, do you know how to call SQL Reporting Services from Dexterity? Thanks MarcosAnonymous
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 ArnoldAnonymous
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. DavidAnonymous
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, CharlesAnonymous
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 DavidAnonymous
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