SSRS - LineHeight property of Textbox

(0) Share

Report

Posted on by 4BzSoftware

6,073

Hi All,

I'd like to increase space between lines of a textbox in SSRS (as Line Spacing in MS Word with Single, 1.5 Lines, Double, ...). LineHeight property of textbox not affect. Is it a bug or should use another property? How can archive it without coding to split lines?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Saurabh Shah 4,560 on at

Like (0)

Report

Hi,

Unfortunately it is not possible in SSRS based on the below links:

stackoverflow.com/.../spacing-width-between-lines

social.msdn.microsoft.com/.../line-height-or-line-spacing-in-sql-reporting-services-2008-r2-when-using-sql-server-business

So,As we all know, there are many kinds of line space in Microsoft Word, like single, 1.5 lines, double, multiple...The line space property of text-box in Reporting Services is LineHieght, however, this property setting only has an effect in HTML rendering. It is ignored for other rendering formats.

So in you scenario, I would prefer a workaround: you can add vbCrLf to your textbox’s expression manually for each line if possible.

Thank you for your understanding.

-Saurabh Shah

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

hi, use the padding property of the textbox.

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (0)

Report

Thank Saurabh and Jonathan!

What a pity that line space property of text-box in Reporting Services has no effect in Report Viewer rendering! Padding property does not satisfies the requirement.

In fact, posted sales invoices are printed on pre-printed paper. There is "total amount in letter" region with 2 dot lines on paper. It is nice if we can use one textbox and line spacing property. Currently, we split text by C/AL code and use 2 textboxes for this.

Was this reply helpful? Yes No
Ansar Basha 1,584 on at

Like (0)

Report

Hi Khoa Nguyen,

I'm facing the same issue, could you pls. share the script, i tried using Line height,line spacing options to increase height & some functions to split the string into two text boxes.

Thanks and much appreciated.

Regards,

Ansar Basha.S

Was this reply helpful? Yes No
4BzSoftware 6,073 on at

Like (1)

Report

Hi Ansar,

Just made a test again, LineHeight property still not work in latest SSRS report.

Here you are, how I split long text into 2 lines:

Was this reply helpful? Yes No