Report Writer

• 07-22-2008 12:02 AM

  SGoldsmith Joined on 07-22-2008 Posts 6	Report Writer Reply Contact Can someone assist me with how to suppress zeros from printing on a SOP invoice. I have a calculated (conditional) field which has a currency result if there is a line item and zero if not. I want to be able to suppress the zero from printing. Any ideas

• 07-22-2008 4:58 PM

  In reply to

  David Musgrave [MSFT] Joined on 07-03-2007 Posts 116

  Re: Report Writer Reply Contact Double click on the field, or select it and press ctrl-F (Tools >> Field Options). Change the Visibility to Hide When Empty.  David Musgrave [MSFT] Escalation Engineer - Microsoft Dynamics GP Microsoft Dynamics Support - Asia Pacific Microsoft Dynamics (formerly Microsoft Business Solutions) http://www.microsoft.com/Dynamics mailto:David.Musgrave@online.microsoft.com http://blogs.msdn.com/DevelopingForDynamicsGP Any views contained within are my personal views and not necessarily Microsoft policy. This posting is provided "AS IS" with no warranties, and confers no rights.

• 08-18-2008 7:38 PM

  In reply to

  SGoldsmith Joined on 07-22-2008 Posts 6	Re: Report Writer Reply Contact Thanks, this worked fine. Any idea on how to account for converting the qty field to a number for extension calculation? I used STRLNG to do this initially but when the qty goes over 1000 the comma comes into play in the qty field and the calculation is incorrect

• 08-19-2008 11:20 PM

  In reply to

  David Musgrave [MSFT] Joined on 07-03-2007 Posts 116

  Re: Report Writer Reply Contact I would use RW_Strip() user defined function (system series) to remove the commas. For example RW_Strip(Field, ",") However, the QTY field should already be a currency datatype and should not require any conversion to be used in a calculated field. David Musgrave [MSFT] Escalation Engineer - Microsoft Dynamics GP Microsoft Dynamics Support - Asia Pacific Microsoft Dynamics (formerly Microsoft Business Solutions) http://www.microsoft.com/Dynamics mailto:David.Musgrave@online.microsoft.com http://blogs.msdn.com/DevelopingForDynamicsGP Any views contained within are my personal views and not necessarily Microsoft policy. This posting is provided "AS IS" with no warranties, and confers no rights.

  Tags: reports