I have a need to display multiple total lines in the footer so that the grid is loaded through an XML document and the results looks something like this:
Product Line In/Out Units Amount …
Product Line 1 In 1,250 2,500.00
Product Line 1 Out 300 600.00
Product Line 2 In 1,800 3,600.00
Product Line 2 Out 1,000 2,000.00
.
.
.
Total In …
Total Out …
I tried enclosing the values in double quotes so in the attachFooter element, the values looked like “11,400”,“36,495.00”, however that didn’t work. The detail is formatted fine, but the grid is treating the commas in the values like column delimiters. I have the 2.5 pro version, is there a way to do this?
Any help would be appreciated.