Report Writer – Page 8 – Winthrop Development Consultants Blog

Hybrid – Cheque Amount in Words Example

Sep 29, 2008 Tagged with Dexterity, DUOS, Hybrid, Report Writer, RW Functions, VBA 15 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words. After the code was added, it was realised that Report Writer calculated fields of return type string are limited to 80 characters. This means that if your amount in words is longer than 80 characters, only the first 80 characters will be returned and the rest will be truncated and lost.

Developing For Dynamics GP

Hybrid – Purchasing Terms & Conditions Example

Sep 29, 2008 Tagged with Dexterity, Hybrid, Named Printers, Report Writer, VBA 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The report can be either a built in report or a custom report. If a built in report is used security will define whether the original, modified, alternate or modified alternate version will be printed.

Developing For Dynamics GP

How to use core Formats in a 3rd party report dictionary

Sep 2, 2008 Tagged with Formats, Report Writer 2 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This posting discusses how to use Customization Maintenance packages to enable Microsoft Dynamics GP core formats for use in the Report Writer with a 3rd party report dictionary.

Developing For Dynamics GP

How to change the font used for Text Reports

Sep 1, 2008 Tagged with Fonts, Report Writer 7 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When printing Text Reports for Microsoft Dynamics GP to a laser printer they are usually printed using the built in Courier printer font. The following article describes how the font typeface and size can be controlled by settings in the DEX.INI defaults file.

Developing For Dynamics GP

Using the built-in Report Writer Functions

Sep 1, 2008 Tagged with Report Writer, RW Functions, SDK 28 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

During my time in the partner channel, I worked with a number of consultants who had a number of problems customising reports with Report Writer.

Developing For Dynamics GP

Automating Distribution of Customizations Part 2

Aug 26, 2008 Tagged with Application, Dexterity, Modifier, Report Writer, Synchronise, Touch, VBA, Visual Studio Tools 12 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

If you have not read part 1 of this posting it can be found using the link below:

Automating Distribution of Customizations Part 1

Developing For Dynamics GP

Automating Distribution of Customizations Part 1

Aug 20, 2008 Tagged with Application, Dexterity, Modifier, Report Writer, Synchronise, Touch, VBA, Visual Studio Tools 12 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A long time discussion in the Microsoft Dynamics GP world is how to handle the distribution of customizations and updates. There are a number of approaches available and this article discusses the benefits and issues of the different configurations.

Developing For Dynamics GP

RW – Adding Line Numbers to SOP Documents Example

Jul 21, 2008 Tagged with Report Writer, VBA 6 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The following example shows how easy it is to use VBA to add a line number to a SOP Document.

Developing For Dynamics GP

Modifying Reports which use Temporary Tables

Jul 16, 2008 Tagged with ADO, Report Writer, VBA 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I often get told that it is impossible to customize a report which uses a temporary table, and in particular a temporary table which uses single fields for multiple purposes. While I admit that these reports are more challenging to customize they are far from impossible.

Developing For Dynamics GP

RW – Accessing any SQL data from a Report Example

Jul 16, 2008 Tagged with ADO, Report Writer, VBA 17 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. It works as long as you can create a query that will uniquely select the data you need based on the data on the report or from the already linked tables.

Tag: Report Writer