I use RS2000 SP2. I would like to set table header to Print titles option when export a report to excel. I try to create text boxes in stead of table on Page header area. This way seems good, however, this way is difficult for preventing merged cell problem.
Does anyone know good solution? Does it solve at RS2005?
Yeah I have the same conundrum. When exporting a report to excel in order to print it, I want the table headers to be reflected on each page. Beside the above work-around which is not pretty, is there some other way? This is in RS 2005.