crossitpro


In SQL Reporting Services - How can you configure a textbox (in a table row/cell) to display (and more importantly print to hard copy) an underline area that is "appended" to the end of variable length text. The objective is to be able to print out a form with an identified area for handwritten text entry. I need the underlined area for the textbox to be "right aligned". For example,

Customer Satisfaction

Were you satisfied with the service(s) received _________________________________________

How long did the service call take ____________________________________________________

Would you recommend us to your friends _____________________________________________

Is this possible How can I do this

Thx!

Chris




Re: how to add underline to "end" of expression text in textbox?

?®€?§Q?


Add this to your expression:

= ........ & "________________________"







Re: how to add underline to "end" of expression text in textbox?

Priyank Pandey

For right aligned text, you may put a textbox with bootm border as solid and text aligment as right justified.






Re: how to add underline to "end" of expression text in textbox?

crossitpro

That doesn't meet my needs. The problem with that solution is it does not provide the variable length "right aligned" underline that I need. Which gives me this...

Customer Satisfaction

Were you satisfied with the service(s) received _________________________________________

How long did the service call take _______________________________________

Would you recommend us to your friends ________________________________________

...instead of this....

Customer Satisfaction

Were you satisfied with the service(s) received _________________________________________

How long did the service call take ____________________________________________________

Would you recommend us to your friends _____________________________________________

Can this be done

Thx!

Chris





Re: how to add underline to "end" of expression text in textbox?

?®€?§Q?

Does the text have to be left aligned If not, then just right align the whole textbox....






Re: how to add underline to "end" of expression text in textbox?

crossitpro

Yes, the (variable length) text itself needs to be left aligned.

The solution (if one exists) may not be something I append to my variable length text. Maybe the solution is related to a property of the textbox that I don't know about I have tried to use padding, borders, textdecoration, etc. without success.

If we could control the "left to right growth" of a cell in a table without extending the overall width of the table I might have an idea that would work. However, I don't think we have the ability to have the length of an "expression" actually control the width of an individual cell of a specific row in a table. If this was possible - I could maybe place my variable length text in one table cell, then use the bottom border underline property for the table cell adjacent to it on the right. If the width of the variable length text filled cell flexed and the bottom border underline cell flexed, but the overall table width did not flex...I might have something. However, I don't think this is possible.

I wonder if a matrix control might provide this capability Or other solution suggestion

Thanks for trying...

Chris





Re: how to add underline to "end" of expression text in textbox?

crossitpro

Thanks to those who submitted posts.

I have come up with solution which has been accepted by my client. It is based upon some of the posts here, the Left() text function, and the use of a fixed width font.

The following solution appends a string of underscores (i.e. "_") to the end of *the* variable length text and then uses the Left() text function to concatenate the resulting string to a constistent character length. Of course, this solution only works if *the* variable length text contains a character count small enough to leave a usable "underscore" area at the end of the line of text AND the font used is a fixed width font (such as courier, lucida console, lucida sans typewriter, etc).

Code Snippet

=Left(Fields!display_text.Value & "_____________________________________________________________________________",80)

Hopefully, this will be beneficial to others, as well.

C





Re: how to add underline to "end" of expression text in textbox?

KimberlyL

Does this make your lines end right aligned as in your original example






Re: how to add underline to "end" of expression text in textbox?

crossitpro

Yes, it does. The expression I submitted always returns an 80 character length string (with the caveats listed in my original post). In addition, the solution requires that you use a fixed width font. Therefore, an 80 character string of fixed width font will always (start and) end in perfect alignment for each line displayed (or printed).

Good luck!

C