October 14, 2015 at 5:53 am
I have a simple tablix getting filled from a dataset through a stored procedure. I then add a rectangle around the tablix, and send the rectangle to the back. Now when I run the report I get a bunch of whitespace at the top (looks to be the size of the empty rectangle). Is there any way to eliminate this extra whitespace? It only happens when I add the rectangle. I need the rectangle because I am exporting the report to excel on multiple sheets so I'm using the rectangle page break property to accomplish this. Thanks.
October 15, 2015 at 4:12 am
Hi Sternim,
You have to kind of dock the tablix to the rectangle, this can usually be done by moving the tablix over the rectangle after you have sent the rectangle to the back.
I'm not aware of a property that tells you the tablix is "docked" however you can check it is the case by looking at the Document Outline window where you should see the hierarchy between the tablix and the rectangle. Or if Document Outline is not available, i.e. you are using Report Builder and not BIDS, you should see that the location property of the tablix has become relative to the top-left of the rectangle rather then the report body.
HTH
October 15, 2015 at 6:12 am
HTH, your solution was the answer I was looking for. Thanks a bunch!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply