locked
create a report in a Vertical Table format RRS feed

  • Question

  • hi,

    I would like to create a table like below in SSRS 2008 Report

    ColumnName1 Value1...........
    ColumnName2 Value2
    ColumnName3 Value3
    ColumnName4 Value4
    ColumnName5

    Value5

    how can i achieve this? if any one please help me.


    srikanth

    Tuesday, May 22, 2012 3:52 AM

Answers

  • Hi There

    Is every column do have multiple values? if that is the case then you can add details rows for every column if every column just have one value then you can create rows outside group for every column and delete the details row from  the report and put your column inside.

    Please refer to this article that might help you

    http://p2p.wrox.com/content/articles/creating-mailing-labels-sql-server-reporting-services

    If you have any questions please let me know

    Many Thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    • Marked as answer by Lola Wang Wednesday, May 23, 2012 1:50 AM
    Tuesday, May 22, 2012 4:25 AM

All replies

  • Hi There

    Is every column do have multiple values? if that is the case then you can add details rows for every column if every column just have one value then you can create rows outside group for every column and delete the details row from  the report and put your column inside.

    Please refer to this article that might help you

    http://p2p.wrox.com/content/articles/creating-mailing-labels-sql-server-reporting-services

    If you have any questions please let me know

    Many Thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    • Marked as answer by Lola Wang Wednesday, May 23, 2012 1:50 AM
    Tuesday, May 22, 2012 4:25 AM
  • hi

    thanks for replay,

    i have multiple values for each column 

    like

    item no       1      2     3.....

    item name   a     b     c.. 

    i am new to ssrs can you please explain more clearly.


    srikanth

    Wednesday, May 23, 2012 4:53 AM
  • Hi There

    Drag a tablix on to the surface of the report and assign a dataset to the tablix then right click on the data row and add row inside group below. You have to do it for every multi value column you have and then  you just assign the column to these row

    If you have any questions please do ask.

    Many Thanks
    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.


    Wednesday, May 23, 2012 5:04 AM