When you set the DataSource of a Report to be a query, how does the report "know" to make each row of the query a different page (when you print preview it)?
When you set the DataSource of a Report to be a query, how does the report "know" to make each row of the query a different page (when you print preview it)?
You do that in the Report. In Design of the report, right click on the bar say that says "Detail" or if you have a Groupon Section, etc. and select Properties and there is an option to Force new page. You can force new page after or before a certain key field value changes, etc.