[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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