When using the Report Designer preview, is there a way to limit to one record to help with design layout?I have a database of over 500 records. So when I want to preview within the Designer it scans through all the records.

There is no way to do that from within the Report Designer. However, you could create a NeoBook pub that opens the database, performs a query (to limit the number of records) then runs the report. When editing the report in Designer, save your work and run the NeoBook pub whenever you want to see a preview.