column grouping in ssrs

Apr 8 2015 1:14 PM

Dear Experts
I have a problem in ssrs reporting..
I have a data like this

BILLNO AMT
==========
123 1000.00
1223 2000.00

I need to show in table or list in following way
123: 1000 1223:2000.00
like this...i tried by applying column and row grouping on two unique keys but it didnt work for me

please help