• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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