You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Freeze Pane When Report Opened in Excel

in Narrative Reporting 4 comments

Summary:

Is it possible to configure a report in Narrative Reporting so that, when it is opened in Excel, the header columns and rows are frozen using Excel's "Freeze Panes" functionality?

Background:

We are developing a report which will be opened primarily in Excel (as opposed to the HTML preview or as a PDF).

The report has a text box at the top (serving as the report title), then a single grid, and then a second text box at the bottom with POV details. The grid has one header row, and two header columns.

The business users would like the report to be configured so that, when it is first opened in Excel, the Freeze Panes option has already been configured and enabled. They would like the freeze to correspond with the header row and columns in the grid. The text above the header row (the title of the report) would need to be frozen as well, which is fine.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!