Browse by Tags
All Tags »
Report Writer (RSS)
I was recently asked how can you total a field in a report when that field is in a conditionally suppressed section. You might ask why should this be difficult. The reason for the complexity is this.... Suppressing a section just stops it being displayed
Read More...
When working with the Report Writer to print a report onto a preprinted form it is important to ensure that the report prints to the same position regardless of the printer or printer driver used. This article explains the option that allows a report
Read More...
A little while ago I wrote an article about how to get the RW_ConvertToWordsAndNumbers() report writer user defined function to work correctly for both originating and functional currency views. Today, a comment was added to that article asking about
Read More...
In the previous article in this series, Microsoft Dynamics GP and Illegal Characters Part 1 , we discussed how string delimiter or terminator characters can cause issues and need to be handled correctly. The article discussed the single quote (') and
Read More...
A new feature to the Support Debugging Tool for Microsoft Dynamics GP build 11 is the support for the rw_ReportStart, rw_ReportEnd, rw_TableHeaderString, rw_TableHeaderCurrency, rw_TableLineString, and rw_TableLineCurrency report writer user defined functions.
Read More...
The question of how to control the size of the body section of a document such as Sales Order Processing (SOP) Orders and Invoices or Purchase Order Processing (POP) Purchase Orders has come up a number of times before. It was asked again on a Community
Read More...
When the inventory module of Microsoft Dynamics GP was first written the Item Description field was 60 characters long. A few versions ago it was extended to 100 characters. While this allows for a longer description to be entered, it has created three
Read More...
One of biggest issues people have with the Microsoft Dynamics GP Report Writer is not being able to create the desired table relationships from tables on the report to other tables so that the other tables can be added to the report and behave correctly.
Read More...
The question in more detail is whether it is possible to print "Page: Y/X" or "Page: Y of X" on a Report Writer report, where Y is the current page number and X is the total number of pages for the report. This question was asked again on the Partner
Read More...
I recently had a support case where the partner consultant was trying to use the RW_ConvertToWordsAndNumbers() report writer user defined function to display the Purchase Order total in words at the bottom of the document. They were using the POP Purchase
Read More...
If you are going to Convergence 2009 in New Orleans between the 10 th and 13 th of March 2009, make sure you attend the various sessions about the Microsoft Dynamics GP development and customization tools. Below are the details of the sessions: GP04 Building
Read More...
If you have ever wondered why the Microsoft Dynamics GP Report Writer limits you to 32Kb (32,767 bytes) when adding images, this post should hopefully explain the reasons. The most important point to note is that the 32Kb limit is for an uncompressed
Read More...
Over the years, I have been asked many times how to call a Report Writer report to make it behave the same as if it was called by the original code. If you are member of the Source Code program, you could always find the run report command in the source
Read More...
As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects to access data from SQL Server while using the Report Writer. Sometimes it is not possible to use Report Writer to create a table relationship
Read More...
Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well. In fact using VBA with the Report Writer can allow
Read More...
