SQL Reporting Keep Header Rows Visible Repeat on New Page

This shouldn't be that difficult to figure out. But it is, so here is how to do it.

Select the first static member of the Tablix and set the property of RepeateOnNewPage to True and the KeepWithGroup property to After.

That's it.

Finding the SQL behind a Crystal Report

I need to find the SQL that generated a Crystal Report. All I had was the report definition file and Visual Studio 2008.

After creating a new DSN (Windows XP users click here for instructions) I opened up the report in VS and clicked the Crystal Reports menu at the top. Then Database -> Show SQL Query. A wizard will popup, click the Back button, choose the newly created DSN for your database and then click Next. Login with your credentials and click Finish. Whalla (spelling??) I now see the previously hidden SQL.