[Solved] How Can I Output a Remark Column with rowspan Without Duplicates for same group in Coldfusion (Re formated)
Please try the following: <!— pseudo query —> <cfscript> report = queryNew(“productTypeName,paintType,paintColor,paintCode,quantity,litreName”); queryAddRow(report, [[“Honey”,”Texture”,”Brilliant White”,1700,3,”20 litres”]]); queryAddRow(report, [[“Honey”,”Texture”,”Off White”,1701,8,”20 litres”]]); queryAddRow(report, [[“Magic”,”Texture”,”Off White”,1701,21,”20 litres”]]); queryAddRow(report, [[“Magic”,”Texture”,”Brilliant White”,1700,8,”20 litres”]]); queryAddRow(report, [[“Princess”,”Gloss”,”Brilliant White”,9102,9,”4 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Rose Pink”,1712,3,”20 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Ivory”,1704,1,”20 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Off White”,1701,3,”20 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Off White”,1701,3,”20 litres”]]); </cfscript> <!— add groupRowspan and groupTotalQuantity columns —> … Read more