Say Hey Kid
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!!!!
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.
Say Hey Kid
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.
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.
Seajoker: Highlight each column and set the FixedHeader property to True.
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....
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
FixedHeader: Make this Property to True & the column is Freezed.
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?
is this in 2005 or 2008 because i dont see a layout property for the matrix object nor the table object
Thanks a lot...
No Dream Is Too Big....!
Can you please post your solution?
Hall of Fame
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].
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)
Do the columns stay frozen in report server too (the web view)?
Hall of Fame
Viewing 15 posts - 1 through 15 (of 18 total)