Freeze Panes in Reports

  • seajoker

    Say Hey Kid

    Points: 700

    I have searches and search for this seemily easy report formatting. How can you freeze columns like in excel on large reports? Searching has lead me to column markers, but I cannot find them in the layout tab when formatting my report. Arghh!!!!

    Seajoker

  • xanthos

    SSCrazy

    Points: 2510

    In the table properties check tthe "Header should remain visible while scrolling"- check box.

    For a matrix check the "Group header should remain visisble while scrolling" - checkbox of the group properties.

  • seajoker

    Say Hey Kid

    Points: 700

    Thanks, that helps with the top scrolling, but can you freeze left to right? I want the 1st 3 colunms on the report not to scroll.

  • rs80

    SSCrazy

    Points: 2312

    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" is checked as well. But even after exporting to Excel the row headers aren't frozen. I can move the header textboxes to the Page Header, but if the sizes of the textboxes in the Page Header don't match the size of the textboxes in the table (body), the excel sheet produces extra columns.

    Any suggestions?

    Thanks.

  • rs80

    SSCrazy

    Points: 2312

    Seajoker: Highlight each column and set the FixedHeader property to True.

  • Rewadee Injan

    Valued Member

    Points: 53

    Dear all,

    Could you please help me. I use SQL 2000 Server Reporting Services. How can I freez column and header column when I scroll the report. I tried to find the check box of fixed report header as you do but I can't. So how can I do....

    Many thanks,

    Rewadee.

  • ping2smi

    SSC Enthusiast

    Points: 134

    Select the Column which u want to freeze, but it should be the Right most or Left most column/s

    Go to the Properties of the Column u selected & then Under

    Layout:

    FixedHeader: Make this Property to True & the column is Freezed.

    🙂

  • mnevill

    Valued Member

    Points: 68

    I've found the where to affect the headers in the properties of the groups.... But I've found that the report when deployed doesn't have this properties, only in VS... Any ideas why that would happen?

    Ideally, I'd like the freezing of panes to export to excel as well. Does this require VB scripting or something?

    Thanks!

  • Ramachandran Veluthattil

    SSC Enthusiast

    Points: 131

    is this in 2005 or 2008 because i dont see a layout property for the matrix object nor the table object

  • ramu.valleti

    SSCrazy

    Points: 2229

    Thanks a lot...

    Its working..

    Ramu
    No Dream Is Too Big....!

  • v-jayram

    Grasshopper

    Points: 11

    Can you please post your solution?

  • becklery

    Hall of Fame

    Points: 3315

    Hi, seajoker.

    I know a best choice for you to solve the problem -- RAQ Report.

    With it, you need only 2 steps:

    1. Set rows and columns you want to freeze as "table head rows" and "table head columns".

    2. Set needScroll="yes" in tag properties.

    Have a try of free report journey at http://www.raqsoft.com/[/url].

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • kcarstens2

    Grasshopper

    Points: 11

    Hi,

    I've set this property and noticed the difference in the web browser but when you open it in Excel the columns are not frozen.... Any ideas?

    (In explorer, they freeze but not in excel)

    Thanks.

  • john.richardson-1106818

    Newbie

    Points: 5

    Do the columns stay frozen in report server too (the web view)?

    Thanks

  • becklery

    Hall of Fame

    Points: 3315

    Hi, seajoker.

    You can try to use RAQ Report[/url] to solve your problem. As I know, it allows users to set specific rows as top report header area, or set specifc columns as left report header area. Then, you can freeze them easily.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply