My IPeople

Community discussion for IPeople products and services
Welcome to My IPeople Sign in | Help
Home Blogs Forums

MV Arrays

Last post 12-14-2007, 2:09 PM by Brian. 0 replies.
Sort Posts: Previous Next
  •  12-14-2007, 2:09 PM 595

    MV Arrays

    MV (Multi-Value) Arrays allow for the creation of our own "multiples".  Often the MV array itself is created in an NPR Report  Writer macro which is integrated into the report via the AL Footnote.  User-defined (xx) fields are placed on report lines as though they were any other multiple.  The Line Attribute MV is added to the top line containing the first of the "xx" multiples. 

    Here is an example of the steps necessary for creating an MV Array to print the positive integers 1 through 10:

    1)      Set up two Detail lines.

    2)      Create a user-defined field (xx) with the following attributes:

    It doesn’t matter what you value you use with your VAL attribute.  You could use VAL=1.  That would make no difference because the MV Line Attribute will overwrite whatever VAL you enter.

    3)      Put the xx field on your Detail lines, one on top of the other like you would any other multiple:

    D          xx.field
    D          xx.field

    4) Enter the following Line Attribute on the upper of the two Detail lines:      MV=D

    Make note of what value you use.  In this case, I used D.  You can use whatever value you like, you just have to make note of it.  Tradition has been to use the current Region as your value for this Line Attribute.  Since these lines  are in the D Region, I used D as the value.

    5) Use the AL Footnote to integrate a macro into your report.  It would appears as follows:  AL D d

    You can name your macro whatever you like.  In this case, the AL Footnote will integrate a macro called d before the D Region prints.

    6)      File and translate your report.

    7)      Go back into your report and find the field number for your xx field.  You can find the field number in the lower   left-hand portion of the Report Picture screen.  You will need this number later.

    8)       Create a macro called ‘d’ with the following code:

    DO{@Add(1,NUM)’>10 “Number “_NUM^/MV[“D”,NUM,1]}

    “D” is used here as the primary subscript since that was the value used in the MV Line Attribute.

    1 is used as the third subscript here but it will be whatever field number is used on the Report Picture screen for your xx field.

    NUM is the second subscript which is a unique value to make sure none of your MV array entries is overwritten by another entry.

    Please note that in C/S, MV Arrays are created as /R.MV while in MAGIC they simply use /MV. 

    9) File and translate your macro and then file and translate your report again (you have to retranslate your report after you translate a macro that is integrated via the AL Footnote).

View as RSS news feed in XML
Powered by Community Server, by Telligent Systems