Microsoft Dynamics GP Developing for Dynamics GP
A blog dedicated to the Microsoft Dynamics GP Developer & Consultant community
 
Welcome to MSDN Blogs Sign in | Join | Help

Developing for Dynamics GP

by David Musgrave (Australia) and the Microsoft Dynamics GP Developer Support Team (USA)

News

  • Please use the Blog Feedback? - Contact Us link at the top of the page to email questions relating to the blog itself.

    If you wish to ask a technical question, please use the links below to ask on the Newsgroups. If you ask on the Newsgroups, others in the community can respond and the answers are available for everyone in the future.

    Please do not use comments on pages and posts to ask questions unrelated to the topic on that page or post.



    Dates of Interest:

    11-Jul-2008: Blog Created by David Musgrave.
    10-Oct-2008: First Post by Scott Stephenson.
    04-Nov-2008: First Post by Dave Dusek.
    11-Nov-2008: First Post by Beth Gardner.
    28-Nov-2008: First Post by Chris Roehrich.
    30-Dec-2008: First Post by Patrick Roth.
    24-Feb-2009: First Post by Greg Willson.
    22-Apr-2009: First Post by David Clauson.
    04-May-2009: First Post by Ryan Wigestrand.
    19-Jun-2009: First Post by Dawn Langlie.
    03-Jul-2009: First Post by Emily Halvorson.
    23-Sep-2009: Created Twitter account with blog feed.
    20-Nov-2009: First Post by Alice Newsam.



    WorldMaps Statistics since
    24-Feb-2009:




    Click for WorldMaps Stumbler



    Translator Tool:




    Social Networking

    Follow David Musgrave and the blog on:

    David Musgrave on Twitter

    David Musgrave on LinkedIn


    Disclaimer

    This blog is provided "AS IS" with no warranties, and confers no rights.

    The links in this blog may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.

Contents

Favourite Posts

Blog Links

Newsgroups Links

Resources Links

How to get large amounts of text to look good on a report

David MeegoI have seen a number of occasions where a consultant has been asked to add a paragraph of text to a graphic report and has found it almost impossible to get the text to display nicely in both screen and printer outputs. 

For example: a Purchasing Terms and Conditions section on a Purchase Order.

The reason is that static text fields are limited to 79 characters and so to enter more than 79 characters on a line you would have to place more than one static text field on a line.  The problem is that the spacing when laying out the report might differ from the spacing when the report is printed to screen and differ again when the report is printed to the printer.

A possible solution to this issue would be to enter the paragraph into Word and get it displayed on the screen. Then use the PrintScreen to capture a screenshot to the clipboard.  Then you can use your favourite graphics tool to crop and reduce the number of colours to the lowest number of bit planes that still looks good.  You could probably go to 16 colours (4 bits per pixel) and black text on a white background will still look good, even if using shades of grey to smooth the edges of the fonts. You need to get the file size for the image when saved as an uncompressed bitmap to be less than 32KB as this is the limit for pictures in Dexterity.

This image can then be used in a report instead of actual text and would avoid the issues with spacing between static text fields on the same line.  Just remember to look at the Knowledge Base (KB) article below for hints on avoiding pixelation when using graphics in Report Writer. 

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

This might take a couple of trial and error attempts to get the sizing correct, but this method can produce better results that using static text.

Post a comment to let me know if you find this information useful.

David

Posted: Tuesday, September 30, 2008 10:06 PM by David Musgrave
Filed under: ,

Comments

Developing for Dynamics GP said:

This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The

# September 30, 2008 10:25 AM

Mariano Gomez said:

Dave,

I think this is an excellent suggestion, especially for "once in a while" type texts that need to be on invoices, sales orders, bill of ladings, purchase orders, and other docs. Is the same concept of a logo, but with texts.

This method will ensure you get the same consistent printing result each and every time you print. Very good idea!

MG.-

Mariano Gomez, MVP, MCP

Maximum Global Business, LLC.

http://www.maximumglobalbusiness.com

# September 30, 2008 10:49 AM

David Musgrave said:

# September 30, 2008 7:56 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker