Mike
October 29th, 2002, 03:27 PM
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)
[ October 29, 2002, 04:52 PM: Message edited by: Mike ]
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)
[ October 29, 2002, 04:52 PM: Message edited by: Mike ]