1. Only setting it in the datawindow should be enough.

2. see how many rows you get when the property is not set and retrieve. Then Set the property and repeat the retrieve. When you get at the end of the retrieved rows, it should automatically retrieve another block of rows.

Hi Chris;

  Note that even when this property is set, the following negates this setting & use at runtime ...  

• Sort settings
• Filter settings
• Some types of computed columns
• Group calculation(s)

  If the above settings are present, then the DWO will retrieve all the rows regardless & thus, ignore the RetrieveAsNedded. Food for thought 

Regards ... Chris