Is it possible to format a report in Report Builder like this?
October 27, 2015 6:24 PM   Subscribe

I'm supposed to put together a scheduled report in Report Builder and have it formatted in a way that I don't know how to do (grouped roughly by pairs of columns and then by rows. It's kind of hard to explain; mockup within).

The report works, but groups things in four columns going straight down, rather than in pairs of columns by rows, going sideways.

Basically, what I have is like this:

ALA ADABK IN  312
ALA ADABK OUT 153
ALA ADBIO IN   67
ALA ADBIO OUT  12
ALA ADFIC IN  850
ALA ADFIC OUT 140
AMM ADABK IN  241
AMM ADABK OUT  92
AMM ADABK IN  127
AMM ADABK OUT  18
ALA ADFIC IN   27
ALA ADFIC OUT   0
ANE etc.


But what I need is like this:

      ALA     |AMM     |ANE etc.
      IN  OUT |IN  OUT |
ADABK 312 153 |241  92 |
ADBIO 67  12  |127  18 |
ADFIC 850 140 |27    0 |


Is it actually possible to set up Report Builder to group and format the output how we want? I tried searching for how to do this but failed to find anything. I thought maybe I could bring in multiple datasets and put them beside each other on the output (not a very efficient way of doing it, but the report will run only once a month in off-hours), but I couldn't get that to work either; it complains about pulling from more than one dataset in that central area (maybe I just set it up wrong?)

At any rate, I haven't had any luck setting this up how it's wanted, so I'm curious if anyone knows of a way to do it.
posted by johnofjack to Computers & Internet (3 answers total)
 
Best answer: Do you want to set it so that ADxxx is the row group and Ayy and {IN,OUT} are the column groups?

In that case, your best start might be to read up on groupings in Report Builder and SSRS here and see if that helps at all. It may well help pinpoint what your issue is, if nothing else.
posted by ambrosen at 6:49 PM on October 27, 2015


Response by poster: Thanks, ambrosen. That might be what I need; I'll try it once I get in to work.
posted by johnofjack at 2:30 AM on October 28, 2015 [1 favorite]


Response by poster: This was exactly what I needed; I finally got it working today. (It's the most complicated report I've done--a Cartesian join, a few full joins [and I think it used a few of the more typical joins] plus there was some odd formatting and some expressions with an if/then--I kind of wanted to frame it once it was done.)
posted by johnofjack at 4:18 PM on October 29, 2015 [1 favorite]


« Older Safe to drink 20 year old bottles of coke?   |   In search of a VIM (Very Important Monkey) Newer »
This thread is closed to new comments.