Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

SSRS 2008 using rectangles with text boxes

I am trying to create a text box that is filled in with "maroon" but does not fully fill the cell.  So it would have a white border around it with text being highlighted (attached is screenshot).  I tried inserting a rectangle within the textbox and then a new textbox in the rectangle but when exporting to Excel there were additional rows in the cell added.  I want it to remain one row per transaction basis
0
szadroga
Asked:
szadroga
  • 3
  • 2
1 Solution
 
szadrogaAuthor Commented:
Basically i am trying to put a text box within a text box?  I tried using placeholders, but those only allow me to put multiple data items in one text box...
0
 
planoczCommented:
You have to make two textboxes and  place one on top of the other. then use and Boolean statement to show or hide the box you want to see in your rectangle.
0
 
szadrogaAuthor Commented:
So I would first insert a rectangle then a textbox and another textbox on top of that?  all inside the one rectangle.

I cant understand why just using a rectangle then inserting a textbox in it and resizing the textbox does not work when exporting to Excel.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Could you please post a screenshot?

And also some more detail, what exactly you want.
0
 
szadrogaAuthor Commented:
Attached are 2 screenshots of what I am doing.  I can get it to work when the report renders in HTML, but when exporting/emailing in XLS format additional rows are added to the worksheet.

Why does a rectangle with an inserted text box add these additional rows?
HTML.png
XLS.png
0
 
planoczCommented:
Make sure ALL data going to the textboxes are trimmed. the blank space that you can not see can make the cells grow to big. Forcing the data to move around.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now