Frozen Headers in Reports

[Nisha]

Hi

   I am working on Telerik Reporting, i have created the report using CrossTab control. I am showing the report in report viewer. I need to freeze the headers in report while scrolling the report viewer.Is there any option to that? If so, please send the sample solution.


Thanks
Nisha 

[Steve]

Hello Nisha,

There is no way to freeze the column headers, but you can repeat them on every page, by setting the ColumnHeadersPrintOnEveryPage property to true.

Greetings,
Steve
the Telerik team

[Nisha]

Hi,

   I am displaying the report in single page so the values won't display in multiple pages, because it contains horizontal and vertical scrolling. I have attached the screenshot of the report. Please let me know any other solution to freeze the header for the reports.


Thanks,
Nisha

[Steve]

Hi Nisha,

Thanks for the clarification. What you can do is increase the width/height of the report viewer so that all the data is visible. Another option is to change the way you create the tabular layout, instead of table use TextBoxes (see Automatic Layout (Dock and Anchor) ) and force a page break so that your data fits inside the viewer size.

All the best,
Steve
the Telerik team

[G]

Hello,

We have same requirement as Nisha. This should be a standard thing for any reporting engine. We have a very large report, no way the viewer can be set to handle the width of this beast. Absolutley, there must be scrolling both horizontal and vertical.

Thanks

[Stef]

Hello,

The frozen rows/headers is a media specific feature, and our aim is to have consistent rendering behavior in different formats. If you have tabular like structure of the report, test if our Grid controls do not suite better your requirements. Based on your download history we can suggest you the Telerik ASP.NET AJAX RadGrid supporting frozen columns as well as the Telerik Silverlight RadGridView.

Regards,
Stef
Telerik

[danparker276]

I would also like static headers on a cross tab.  I'm viewing a list of product sales over time and it's nice to scroll vs clicking page by page.

[Jason]

Stef, I understand that frozen headers are a media specific feature. It would be nice if the telerik report viewers supported frozen headers for the media where it makes sense, based on the ColumnHeadersPrintOnEveryPage. For example, Excel rendering, and HTML5 rendering (non-print-preview) can and should have sticky headers.

My main client that uses telerik reports was really upset today to find out this wasn't supported by the reporting framework we chose. He's a non-technical business user, so telling him, "This is a media-specific thing and so the report viewer doesn't have that," only makes the situation worse.

Others who find themselves here: considering "liking" the feature request here: http://feedback.telerik.com/Project/162/Feedback/Details/152360-freeze-table-header

[Stef]

Hello Jason,

Thank you for the feedback. The feature is not yet considered, but you can raise its priority based on the demand for it.

I can suggest you an approach with Telerik Kendo UI grid control - Grid / Frozen columns. The generated UI can be exported in image, PDF, Excel formats from browser - Exporting. To have fixed rows, you can use two grids, where the first loads the fixed rows, and the second the rest data with enabled scrolling.

Regards,
Stef
Telerik

[Jason]

Stef, your suggestion to switch to Kendo UI Grid is aggravating. We have a whole suite of user-designable reports; there are many features of Telerik Reporting that we are currently enjoying that we'd be giving up by switching everything to Kendo UI Grid. For you to suggest this course of action, just to obtain frozen headers, seems extremely odd. Unless you are suggesting that Telerik should discontinue their Reporting product and tell everyone to use the GUI grid products instead.

Besides, it sounds like Kendu UI Grid doesn't support it well either, as you suggest creating two grids (which usually creates problems with variable-width displays and adaptable column widths). I've used Kendo UI Grid on other projects, and also found it hard to work with: anchoring the bottom of the grid to the bottom of the screen, for example. I've seen the hacks on the forums to make it work. It's unfortunate.

This is not an unreasonable feature for a reporting framework. SQL Server Reporting Services has a report designer property called, "Header should remain visible while scrolling[1]."

I understand feature requests need to be prioritized, and this feature may never be added to Telerik Reports. But your suggestions that the feature is inappropriate, or that other products should be used instead, are frustrating. Is one of your objectives as a support engineer to avoid frustrating Telerik's paying customers?

 

[1] https://msdn.microsoft.com/en-us/library/dd220509.aspx

 

[Stef]

Hi Jason,

The feature is not supported in the available rendering formats.
About the logged feature request, it is not declined, but it is not considered in near future plans as well. It is open for votes. Any feedback regarding the items and rendering formats the feature should cover, including votes, is welcome, and it will raise the priority of the feature (not for implementation, but in planning perspective).
We will appreciate it to add the found information in the feedback portal, where it can be revised along with the logged item.


The suggested approach is not to replace reports, but to let users interact (per your requirements) with data, modify it and save it via grid or other UI. Once data is saved, it can be retrieved and visualized by a report. This will let users have the desired functionality in browser, and an option to get an editable document at the end.


I hope this clears the misunderstanding.

Regards,
Stef
Telerik

[Jason]

No, Stef, your response does not clear the misunderstanding - quite the opposite: it demonstrates you are oblivious of key points about my situation.

When you say, "Let users interact (per your requirements) with data, modify it and save it," I have no idea where you are getting that idea. All data entry is taken care of elsewhere in the application. We just want a nice suite of reports, with the standard features one would expect from a versatile reporting framework. We were expecting frozen headers in the HTML5 report viewer to be a feature.

I'm just trying to tell you:

1. this is a reasonable feature request (since you tried to explain in your Oct 11, 2013 post why it wasn't)
2. the workarounds you propose are neither applicable nor helpful.

You are doing a very effective job of making me feel unheard.

[Stef]

Hello Jason,

The request is not unreasonable - it is media specific, but this does not reject it by default. There is a process and the request must pass through it in order to be considered for implementation.
Rest assured your inquiry was discussed with the team, still there is a process to follow beside acknowledgement of the interest in the feature.

There is already a logged feature request you voted for - Freeze table header. The feedback portal is monitored by product managers, and logged request are reviewed, discussed with the development team. Based on the demand, the value the feature brings to the product and other community members, the media and technical specifics it will be considered further.


Please note that the current process includes the feedback portal. Also the requested feature would require changes in the rendering mechanism of the product which may take significant time.


And an entry by our development team is that in Excel format page headers are rendered as frozen rows - Design Considerations for Excel Rendering (Page Headers and Footers).

Regards,
Stef
Telerik