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:
But what I need is like this:
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.
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.
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]
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]
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.
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