Creating a Bar Chart from an Array in CR XI

[kaky]

Hi All,
I am very new to this forum and also to CR. I need some serious help from you guys!

I get a values in the records as below in a String like this

"45:1;32:2,10:3"
"34:1;43:2,15:3"
"34:1;43:4"
basically the 45:1 represent there are items type 1 of count 45.
so i will have to add all the 45+34+34 = 113 etc

and the bar graph should be like

1 |||||||||||| - 113
2 |||||| 85

etc.

Can any one help me by giving an idea how to approach it.

Thanks in advance