When I export to Excel I would like the table headers to be frozen. The RepeatOnNewPage is set to true and the "Header should remain visible while scrolling option"...

Did you try rendering the report to excel directly by adding rs:Format=Excel to the url?

Mike,

I've started reading your article and am not clear why the query: SELECT COUNT(region) FROM Suppliers WHERE Region IS NOT NULL returns 0

1. WHERE clause eliminates every row in which...

2nd option seems to be incorrect as well. My birthday is 3/7, but 2nd option returned 28.