Convert list values in sentence

[SGD]

Hi All,

I have a list which shows following values in it:

Vehicle ID        Instances
ABC                 10
XYZ                  5
JKL                   7

Now I want to display above Vehicle IDs and its corresponding Instances count in below sentence.

There were 10 instances of ABC, 5 instances of XYZ and 7 instances of JKL vehicle with an angle of attack exceeding 30mRad.

Could please someone let me know whether is it possible to implement in Cognos 8.4.1? If yes then how?

Thanks in advance.

[pricter]

Try using a repeater with a combination of texts

[HalfBloodPrince]

But it wil give you  result like this
There were 10 instances of ABC      There were 20 instances of KBC
There were 5 instances of XYZ         There were 30 instances of HP

[pricter]

If you place a text item "There were" and then a repeater it will give you
There were 10 instances of ABC 5 instances of XYZ
and if you perform a running count on vecicle id you can find the first and last vehicle id in order to show "," or "and" or nothing