Building a String value from CustomProperty
I have a custom property set on my products for internal sorting (ie. A,B,C,D...). I have built a report which is sorted by zone displaying a summary of all the associated pricing. I would like to include a column displaying which of the groups (custom property value) are included in that zone. Here is an example of what i would like to see:
Zone 1 -- A,C,F -- $2,000.00 -- $500.00
Zone 2 -- B,C,E -- $1,500.00 -- $350.00
I have no problems building my string in the fetchdata routine and at the end of the routine i store the string to a calculated field. When the report gets printed, it only displays the first stored value from each zone eg:
Zone 1 -- A -- $2,000.00 -- $500.00
Zone 2 -- B -- $1,500.00 -- $350.00
How can i get this string to display properly?
Thanks,
--ck
|