0 Replies Latest reply: May 15, 2014 9:57 AM by Mike _ RSS

    Multiple format detail lines

    Mike _

      My report has three different & independent detail line types.  Each of the three input lines have different fields.  The one field in common is Customer Account mnumber.


      Is there any easy way to create three detail templates to produce one joined table row


      Here is how I handled it - it isn't easy, but it is possible.  I defined a detail template common to all three detail lines with one big field for all of the variable info.  All of the variable fields are created as calculated fields in this manner:

      RENT: If(CODE="6".And.SUBCODE = " ",Val(Substr(data,1,8)),0)

      PTAX: If(CODE="6".And.SUBCODE = "2",Val(Substr(data,30,6)),0)


      [size="1"][ October 29, 2002, 04:52 PM: Message edited by: Mike ][/size]