Thanks to all for your answers. By going haywire. I meant I used the format for a cell in Reporting Services as ##0.##,"%". Thus implying that it is a number...

Thanks racosta. I will try this option. Actually, I am new to replication. I was wondering if linked server thingy can help me with it. I ahve no clue about it...