Keep Paragraph Lines Together Issue

[SQLUSA]

I need to keep the following lines together (no pagebreak in the middle):

SELECT [Year]=YEAR(OrderDate), OrderCount=COUNT(*)
FROM AdventureWorks.Sales.SalesOrderHeader
GROUP BY YEAR(OrderDate)


ORDER BY [Year]

Year OrderCount
2001 1379
2002 3692
2003 12443
2004 13951
I selected the above text (highlight it), right click, Paragraph, Line & Pagebreaks, Keep lines together (checkmark).

Despite that it page breaks in the middle.

[Stefan Blom]

If the text lines are in separate paragraphs, that is, if they are separated by paragraph marks (¶, inserted as you press Enter), make use of the "Keep with next" option instead, also found in the Paragraph dialog box.

[SQLUSA]

Thanks Stefan. It works.