PageBreaks

Question

PageBreaks

Viewing 4 posts - 1 through 5 (of 5 total)

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

Tom257 SSChampion Points: 11543 More actions · Answer 1

Normally print formatting would not be done in the SQL. SQL would be used simply to select the data and another program would apply the print formatting to suit various paper sizes and margins etc,

If there is a specific place you need a page break in the data, use CHAR(12) ASCII Code 0xC Form Feed

e.g.

SELECT 'My long line of data will page break here' + CHAR(12) + 'and this is on the next page';

If you cut & paste the output of this into Word, you will get a page break.

docdiggler2 SSC Rookie Points: 41 More actions · Answer 2

Thanks Tom and apologies, but I think my message may have been somewhat misleading. I used Visual Studio to create the .rdl file.

I'm trying to find out how to establish correct pagebreaks in the layout. I was told that the best way to establish pagebreaks for this would be to create a table in the layout and establish the pagebreaks accordingly.

My problem is that I'm still getting blank pages, etc. and have tried different things but they are still not working properly.

Thanks,

Tom257 SSChampion Points: 11543 More actions · Answer 3

Sorry I've never used reporting services.

I'd recommend you repost the original question under "Reporting Services", "Reporting Services 2005 Development", http://www.sqlservercentral.com/Forums/Forum1063-1.aspx making it clear you're looking for help with a .RDL file

That way the right people will get to see it.

docdiggler2 SSC Rookie Points: 41 More actions · Answer 4

Great and will do; thanks again Tom and Happy Holidays!