Dupplicate rows only in viewer-

Hi,

I have an SSRS report on a WSS task list. The task list allows multiple "assigned to" users.

Including the "assigned to" field in the data set causes records to dupplicate according to the number of users assigned to the task. Including the "Assigned to " column, shows that each of the assignees gets a seperate record.

Previewing the report on the designer shows no such problem. It only happenes on the site when the report is viewed. On the preview, in the designer, the date of the assigned user is displayed like this: "53;#Gil Shayer;#55;#Yaron Amar"

On the report presented, only the names are shown.

Its SSRS 2008 R2 and Wss 2010.

Thanks,

Gil