Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  split text box contents

Author  Topic  sapr Starting Member 1 Post Posted - 2012-05-17 : 04:18:57 My .Net application has a report that is converted to pdf format and rendered on screen. I have a text box whose property 'keep together' is false. If the contents cannot fit in first page, it starts from the next page leaving the first page with lot of empty space. First page has some other text boxes also so it does not fit. I want whatever content that can be fit in the first page to be fit in first page and the rest of the content must spill over to the second page. Please let me know if this is possible. I tried the code from the below link, but it's not working for me http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/9a20d6eb-96b8-4b49-8ad4-85fc2c97d7b1/ In the body section of my report I have several text boxes, I cannot merge all of them as each has different property settings. So I have added the following in expression part of the text box that has huge content. I have also set Location->top 0in for this text box. ="" +Chr(10)+Chr(10)+Chr(10)+Chr(10)+My very long text from database+Chr(10)+Chr(10)+Chr(10)+Space(8)+"" This is not working. Please tell me if any other work around is possible.