How to change the format in SSRS 2008?

Posted on 2012-08-23
Last Modified: 2012-08-27
I have a requirement to display/print  the reports in the following fashion

Name:  abcd
Occupation:  IT
Salary :  100
Address :  testAddress

Name:  abcd1
Occupation:  IT-1
Salary :  1000
Address :  testAddress1

How do I acheive it  in the vertical fashion as mentioned.?
Thanks for your help.
Question by:venk_r
    LVL 22

    Accepted Solution

    I suppose you managed to get the data in a table with 4 columns. Now right click on the 'button' in front of the detail row (the one with 3 dashes) and choose 'Insert Row', 'Inside Group - Below'. Repeat for as many rows as you need. Then move the data from the rows to the columns and delete the extra columns.
    LVL 37

    Assisted Solution

    I think what you're looking for is the List control.  It allows you to put several textboxes under each other in the same "cell".

    Another method is to add a rectangle to your existing table.  The rectangle goes into the detail line. Now you have a area where you can add several textboxes next to or under each other, just like with a List.  You'll probably need to increase the height of the row before adding the textboxes to the rectangle though...

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
    This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now