SSRS Woes - Multiple Tablix in report

Epicor ERP 10
1

Uggh. SSRS.

I’ve got an SSRS form that I’m producing, pulling from various sources. So, I’ve got multiple BAQs that feed into it, each with their data sources. So far a bit complicated, but all is good.

In the detail area, I’ve got multiple tablixes with different sources. I’ve got four total, they’re listed in order, I’ll call them tablix A, B, C and D for simplicity. When I print my form, I see the data from tablix A, then B, then C, then D. All is good. Except I’ve got too much room between the tablixes. So, in the SSRS designer, I grab tablix B, move it up so it’s like 5 points below tablix A. They’re still in A-B-C-D order, just closer together. I’ve got my magnification set at like 250% so I know I’m below.

Now, when I print the report, it doesn’t come out in A, B, C, D order anymore. I’ll get B on the top, when I look for the data from A it’s out on like page 2 well below everything else. Here’s the odd thing - I can go back into the SSRS designer and spread my tablixes back out - can’t get a good report back out of it. Instead, I have to CTRL-Z to undo all the changes, resave and I’m good.

What the heck is going on? Any way to force it to print tablix A first, then B, then C…

I thought perhaps some of the fields are “growing” vertically, so A actually takes up more vertical space than what it does in the designer. But I think all my data fields are wide enough that I don’t have any wrapping going on.

2

Create a sub report for each. The inserted sub reports can be set to grow if necessary, and should move the following sub reports.

Or see if you can insert a Tablix in a cell of another Tablix. If you can, make a Tablix with 4 header rows and 1 column wide. Then put your tablii A, B, C & D in (one in each header row)

3

Have you wrapped them inside something (rectangle) to prevent any flow issues?

2 Likes
4

Wrapping them in rectangles seemed to do the trick. I probably could’ve done a subreport as well.

I tried inserting a tablix with the 4 header rows. That didn’t work as when I inserted the various tablii (A, B, C, D) into the holding tablix, it gave an error. I either needed to specify the datasource on the holding tablix to match the ones I inserted (but they were varying datasources), or any field in the inserted tablix needed to be an aggregate type field (FIRST…). That would’ve required a lot of redoing of my tablii and probably brought up other issues. Good idea though! Definitely worth trying.

1 Like