Unfaithful report layout after Excel exporting

Question

Unfaithful report layout after Excel exporting

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

pmscorca SSCrazy Points: 2349 More actions · Answer 1

I have tried to cut & paste the image and the textboxes into a rectagle or move them in a page header: the Excel rendering improves but I cannot resolve the issue finally yet.

Thanks

slu-904392 Grasshopper Points: 22 More actions · Answer 2

You are right, it is something in your title. Please make sure the width of your text box for the title aligns perfectly with your Tablix down below. I always make my title the exactly same width with Tablix.

For the image in your title, right click and select image properties, under size, choose display as clip, then make the width of your image exactly same width with Tablix.

I believe these should work for you.

pmscorca SSCrazy Points: 2349 More actions · Answer 3

Ok. But I'm working with SSRS 2005 and it doesn't have the tablix.

However, I have above the table on the left the image and on the right

the two text boxes, one below the other one.

So, your suggest it is to increment (or decrement) the text boxes width

in according with the table width, isn't it?

Thanks

slu-904392 Grasshopper Points: 22 More actions · Answer 4

Right. Sorry I am on SSRS 2008 and they call table as tablix.:-)

pmscorca SSCrazy Points: 2349 More actions · Answer 5

And I cannot display my image as a clip. I have an embedded image.

Thanks

slu-904392 Grasshopper Points: 22 More actions · Answer 6

I don't know what it looks like in 2005. But in 2008 imiage properties, clip is a option under size -> sizing, and embedded is under General ->Source.

pmscorca SSCrazy Points: 2349 More actions · Answer 7

I have incremented the width of the two textboxes and I have aligned the image width with the margin a cell, but I haven't solved the issue!