Print String Field Qty Times - Report Writer

[chuito7]

I need to print a string field (like this [____]) as many times as the qty is for that line item.

For example: if they entered an item with qty of 5, they need that field to be printed 5 times, and so on.

I'm using DynamicsGP 9.0, Report Writer.

 

[winthropdc]

You will not be able to have the [______] as vertical lines as this would require a table relationship. It would only be possible with Dexterity.

You could use the RW_Token() function to have the [____] go sideways on a single line up to a specified maximum number.

[________] [_________] [_________] etc.

Have a look at RW_Token() in the Report Writer Programmer's interface document in the SDK. The SDK can be installed from the Tools folder of CD 2 of the Great Plains install CDs.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Micorosoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[jazgeek]

using crystal reports, this function is native.

-----------
and they wonder why they call it Great Pains!

jaz

 

[chuito7]

I don't think that RW_Token will work.

I need this to print a string like "_____" as many times as the qty is.

For example:

If the line item has qty of 5 I have to print
____ _____ _____ _____ _____

it the line item has qty of 3 I have to print
____ _____ _____

and so on... RW_Token will bring me a string using the | as separator.

 

[winthropdc]

RW_Token() will work Set it up as follows:

RW_Token("___|___ ___|___ ___ ___|___ ___ ___ ___|___ ___ ___ ___ ___", "|", QTY)

This will work up to a QTY of 5.

You could also use VBA if you have it registered.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer - Great Plains
Microsoft Dynamics Support - Asia Pacific

Micorosoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

mailto:dmusgrav@online.microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.