Freeze Page Header in Report View (1 Viewer)

raweber

Registered User.
Local time
Today, 02:20
Joined
Jul 28, 2011
Messages
41
I have several reports that span more than the window can handle. My boss has asked me (since he only looks at the reports on the screen) if it is possible to freeze the report/page header at the top of the report view (to keep it from scrolling off the top of the screen) similar to the freeze pane function in Excel.

I don't know if a continuous form would suffice because I need to group the data for presentation. If I can do that with a continuous form, please let me know.
 

vbaInet

AWF VIP
Local time
Today, 07:20
Joined
Jan 22, 2010
Messages
26,374
Possible but quite fiddly. See attached.

Pay attention to the Pop Up property and note the properties in the Format section of the rptHeader report.

NB: I think the report will stay fixed when the ribbon is minimised.
 

Attachments

  • db test.zip
    455.6 KB · Views: 2,012

raweber

Registered User.
Local time
Today, 02:20
Joined
Jul 28, 2011
Messages
41
That is very clever. I'll see if I can get it to work.
 

REDill

Registered User.
Local time
Today, 02:20
Joined
Mar 26, 2015
Messages
16
vbaInet, I love the floating header. It's exactly what I am looking for. However, I am unable to figure out how to transfer it to the Report Header that I want to be floating. Any suggestions?
 

Users who are viewing this thread

Top Bottom