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 use Customization Maintenance packages to enable Great Plains Report Writer functions from a 3rd party report dictionary (KB 862665)
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)
How to display a string label instead of an integer representation of a radio group in Microsoft Dynamics GP (KB 926393)
Graphics Knowledge Base (KB) Articles
How to add a graphic to a Report Writer report (KB 855288)
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)
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
How to create a calculated field in Report Writer to print Extender fields in Microsoft Dynamics GP reports (KB 935385)
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.
The Report Writer Articles & Links page and the Developer Toolkit Article & Links page have been
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?
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.
During my time in the partner channel, I worked with a number of consultants who had a number of problems
When printing Text Reports for Microsoft Dynamics GP to a laser printer they are usually printed using
Over the years I have had many requests for training on the various tools available for customising or
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...
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.
How can I add a virtual table so Report Writer can see it in the table lookups?
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
PS: There are only 2 virtual tables in v10.00 Dynamics.dic anyway.
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?
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.
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?
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.
Hello David, do you know how to call SQL Reporting Services from Dexterity?
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.