SSRS Multiple Column value under one column

Question

User-282339866 posted

Hi

i have a table which consists multiple address(address1,address2,address3) for a given id, i need to show the three address given in three different column name(address1,address2,address3) under same column name "Address" to show in the Report like ..

id Address

1  City1

    City2

    City3

Please help

Thanks

Answer 1

User2105670541 posted

you need to write your query using PIVOT keyword in SQL Server to fetch the value in a single column and later you can bind it in your report parameter.

Answer 2

User-282339866 posted

Hi thanks for your reply yours is more technically correct approach ,however i added another  textbox in the cell and draged the address1 2 and 3 dataset field in respective textbox