Tuesday, June 20, 2006

SSRS Report: "Column should remain visible while scroling"

Okay, I am a database developer sucked into some hundred different tasks due to the nature of my work. One is to build a ton of SQL Server 2005 Reporting Services reports. I have one table based report loved by the parties that be with one request. That the report render in Excel with headers, and left columns mimicing Freeze Pane as well as doing this on the web display. Web display table header was simple enough, "Header should remain visible while scroling" and Report header/footer rows on each page" when a long way, but this doesn't answer the export format nor the left column remain visible requests.
Everything I can find suggests "Repeatwith" property should be set to a data region, but there doesn't seem to be a way of doing this within a single SSRS table.

No comments: