prevention of data truncation or growth in SSRS report

Question

I have SSRS report where there are 8 to 9 tablix columns and they have occupied all the width -(standard width for A4 size) and now there is a situation where some of the column will have net total values for money which increases beyond the length of the field like this.

I want it to be displayed in one line. It should print 99 in one line only. Hence I changed the length of the field and result is as below, where I can see all things displayed in one line but while printing it generates extra data in new page because it has grown beyond page size.

I also tried to stop the growth by changing CanGrow property but that truncates the data as below.

Can someone help me here? What should be the approach to do that. Report is fully utilized (width wise) and none of the column can be re-adjusted. If adjusted, it is going to break print functionality.

Is there a way to do so?

Answer 1

If you can't resize any of the columns (like the 72% column - why is that so wide?) to make the problem column bigger, then there are not too many options to fix this... You could do one of the following:

1. Set the padding on the cells to 0pt (at least on the left and right), which will allow a little more data to fit in the field
2. Decrease the font size, which will also allow a little more data to fit in the field
3. Decrease the margins on Report Properties so you can make the columns a little bigger