Home | Blogs | rmaclean's blog

Layout data horizontally in SRS

Mon, 11/24/2008 - 09:38 |  Robert MacLean

I recently had a question about layout in reporting services. Basically if you use a table you get a vertical layout, like this:

First Name

Last Name

Brad

Pitt

Bill

Gates

Linus

Trovalds

 

But what if you want to go horizontally? Sure there could be UI issues because the report will get wider and wider with more data getting put in and it could influence the quality of export or printing but in a special scenario it would be very useful. Unfortunately the tablix control (Table + Matrix + List in 2008. See my post on what’s new for more info) does offer this natively :( But using a trick you can get around it. First you need a tablix in matrix format (i.e. drag a matrix onto the form), and then add a new column header for each column, but rather than putting a header text in there you put the data in there. You ignore the rows and data cells (in fact you can hide them by setting the hidden property to true).

image

And the output is a horizontal layout of data:

image

Tags: SQL

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Syntax highlight code surrounded by the <pre class="brush: lang">...</pre> tags, where lang is one of the following language brushes: as3, applescript, bash, csharp, coldfusion, cpp, css, delphi, diff, erlang, groovy, jscript, java, javafx, perl, php, plain, powershell, python, ruby, sass, scala, sql, vb, xml.

More information about formatting options

Twitter
Loading my tweets...
Contact Me | RSS Feed | Back to top


© SADev.co.za, SADev and the content here is copyright 2001-2012 Robert MacLean unless otherwise stated. Content reuse license: Creative Commons Attribution 2.5 South Africa License. Disclose Policy: Disclosure. Disclaimer: The views expressed here reflect the views of the authors alone, and do not necessarily reflect the views of any of their organizations, my customers and clients, employers, sponsors, or contributors. In particular, the views expressed here do not necessarily reflect those of the BBD (my employer) or Microsoft. All information and downloads are available without warranty and any use of such information or downloads is at your own risk. Use common sense. If you don't like what is written then do not read it.