Split long text in SSRS reports on two pages

By default text in tables on Dynamics AX reports like SalesQuotation are kept together. If the text does not fit on the actual page, the complete line starts on the next page. This wastes lot of space and produces unnecessary many pages.

To split text in the SalesQuotation follow these steps:

1. Start Visual Studio as Admin and load the SalesQuotation report from the Application Explorer
2. Open the report design
3. Add a new line under the line that contains [ItemId], [Name], [DlvDate] etc.
4. Assign the same fields in the new line, but don’t assign the [Name] field
   
5. Select the new line and set the property KeepTogether to False
6. Drag&Drop a textfield form the toolbox on an empty space in the report and name it textboxName
   
7. Drag&Drop the textfield in the empty column in the new line.
8. Make sure the textfield “textboxName” is still selected and open the properties window. Set the field [Name] as value for the textfield
   
9. Change the Font and Size to fit the other fields, by default its Segoe UI 8pt
10. Finally mark the old line above and set the property Hidden to True
11. Deploy the report