locked
SSRS Multiple Column value under one column RRS feed

  • 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

    Tuesday, July 17, 2012 1:22 PM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 20, 2012 1:17 AM

All replies

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 20, 2012 1:17 AM
  • 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 

    Friday, July 20, 2012 7:37 AM