[Matrix] rowNumber vs LineNum
Mattia RyffelIn the marketing documents matrix ("38") i would like to extract the LineNumber of the first detail table (ex: rdr1.linenum) of a corresponding Row inside the matrix.
The problems comes when there are subtotals and text lines: the lineNum does not follow the rows order, and visOrdr neither. (no data inside xxx1 can tell me about the position of the row)
One safe solution could be to query all the 12 detail tables to try to reconstruct the correct lineNum... :roll:
Anyone ever encountered this problem?
Marco SchweighauserHello Mattia,
you need to calculate the "real" number by yourself. You can use the tables RDR1 and RDR10 to do that.
Mattia RyffelJust for information i found an easy way to do this:
select LineNum where visOrder = count of lines(inside the matrix) with empty type (not special lines)