Multiple Lines - Page Break

Question

Multiple Lines - Page Break

RonBrisola

SSC Enthusiast

Points: 153
More actions
August 13, 2008 at 8:34 am

#196967

I have a report created only with TEXT datatype fields of SQL-Server
The fields can have multiple lines and when the lines of field don´t fit in the page, Reporting Service create a new page, making a huge blank space in the prior page.
Somebody have a solution to this problem?
Thanks for your cooperation,
Ronaldo Brisola,
Sorocaba - Brasil.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

Remove Carriage Returns and Line Feeds from the data. You can do it in SQL by converting the TEXT fields to varchar or in the Report (which is where I would put it).

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

RonBrisola SSC Enthusiast Points: 153 More actions · Answer 2

Hi Jack,

Actually I want to keep the line breaks.

My report is like this:

- Field 1

Line 1 Line 1Line 1Line 1Line 1 Line 1

Line 2 Line 2

- Field 2

Line 1 Line 1Line 1Line 1Line 1 Line 1

Line 2 Line 2

... ...

Line 10 Line 10

Line 11 Line 11

The 11 lines of Field 2 don´t fit on the page, so Reporting Service create a new page after field 1, leaving a blank space in the first page, to print the whole Field 2 on next page.

I want the report like this:

- Field 1

Line 1 Line 1Line 1Line 1Line 1 Line 1

Line 2 Line 2

- Field 2

Line 1 Line 1Line 1Line 1Line 1 Line 1

Line 2 Line 2

Line 3 Line 3

--- Page Break ---

Line 4 Line 4

Line 5 Line 5

... ...

Line 10 Line 10

Line 11 Line 11

Can I do this?

Thanks.

Jack Corbett SSC Guru Points: 184393 More actions · Answer 3

What control are you using on the report? You may need to "nest" controls in order to get the behavior you desire. For example, if you are using a table and Field1 and Field2 are on 2 detail lines in the table you may want to try creating a group, deleting the detail lines and placing a table within the Group Header that has the 2 detail lines.

Another option would be to concatenate the 2 fields into one and inserting a break and "header" on the second field. Something like:

=Fields!Field1.Value & ControlChars.CRLF & "Field 2" & ControlChars.CRLF & Fields!Field2.Value

If you could attach your rdl (you need to zip it first) to the thread so I could take a look it may be easier to make appropriate suggestions.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

RonBrisola SSC Enthusiast Points: 153 More actions · Answer 4

I´m using textboxes inside a List.

The problem with concatenation is that the headers must have other format.

I´m sendig you the rdl file.

Thank you very much.

Ronaldo.

Jack Corbett SSC Guru Points: 184393 More actions · Answer 5

Having seen the report I now actually understand your real question. I don't think that there is a way to have data in a single textbox span pages. The textbox is going to try to render on a single page. I wonder what it would do if there was enough data to cause it to spill over 2 pages?

Is it the =First(Fields!CRONSEM01.Value) fields that are causing the problem? If so, how are you keeping the line numbers (Semana) 01, etc... with the correct textbox?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

RonBrisola SSC Enthusiast Points: 153 More actions · Answer 6

I already put various lines in the textbox to print over 2 pages.

When this occurs the print is perfect!!!

Actually the problem is in the third textbox (CONTEUDO), that have more text.

I´m thinking to write a stored procedure to convert each line in the TEXT field in one record on a new table, then use the TABLE component to print the lines.

Jack Corbett SSC Guru Points: 184393 More actions · Answer 7

ronaldo (8/13/2008)
I already put various lines in the textbox to print over 2 pages.
When this occurs the print is perfect!!!
Actually the problem is in the third textbox (CONTEUDO), that have more text.
I´m thinking to write a stored procedure to convert each line in the TEXT field in one record on a new table, then use the TABLE component to print the lines.

I was actually going to suggest that for a solution, but I wanted to know which textbox was causing the problem.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

paul.bailey-855422 SSC Journeyman Points: 77 More actions · Answer 8

Jack Corbett (8/13/2008)
Having seen the report I now actually understand your real question. I don't think that there is a way to have data in a single textbox span pages. The textbox is going to try to render on a single page. I wonder what it would do if there was enough data to cause it to spill over 2 pages?

Hi

I think I've got a problem similar to this issue and you've touched on something that might work for me.

I'll try to explain best I can.

One of the columns that our report is displaying is a huge text field, the report puts this in a text box but when one row exceeds one page it fails saying it can not render the report. Having tested this it is because the one data row is trying to span more than one page so the question is what do I need to specify to enable this to happen.

Sorry if thats unclear and thanks in advance for any suggestions.

Thanks,

Paul.