This is a migrated thread and some comments may be shown as answers.

Frozen row/column

5 Answers 106 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Manar
Top achievements
Rank 1
Manar asked on 29 Jan 2013, 02:42 AM
Hello,


1-Can we froze some columns/rows in table in telerik report while we exporting it to Excel sheet?
2-also how we can have more than one sheet with different params in the same Excel file?
3-How can I set the "fitsheet in one page" option? or the print area??

I need your help ASAP please.


Thanks,
Manar

5 Answers, 1 is accepted

Sort by
0
IvanY
Telerik team
answered on 31 Jan 2013, 05:51 PM
Hello Manar,

Up to your questions:
  1. Yes, you can freeze some cells in Excel upon exporting your report. To do so you have to use the Page Header of the report - the cells will be rendered in Excel as frozen rows.
  2. You can use a ReportBook as a container for you reports. You can add it it multiple instances of the same report class with different parameters. In this way each report will be exported to a single sheet in the workbook.
  3. Currently it is not possible to control this Excel option from Telerik Reporting.

All the best,
IvanY
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Manar
Top achievements
Rank 1
answered on 01 Feb 2013, 03:21 PM
Hello,

Thanks a lot for your reply.


1- Just page header? what if I want to freeze some columns in the table in the details area?

2- Got it, thanks.

3- There is no any work around?


I appreciate your help
Thanks,
Manar
0
IvanY
Telerik team
answered on 04 Feb 2013, 03:19 PM
Hi Manar,

  1. Only the page header can generate frozen rows. Since Telerik Reporting is not designed to work specifically with Excel the frozen rows are just representation of our page header. Because in other formats there is no such notion as frozen rows they are not configurable.
  2. Again since Telerik Reporting is not designed to work specifically with Excel and Excel has a lot of options we do not provide a way to configure them. That is why you will have to adopt your own way of additionally configuring the exported excel files.

Kind regards,
IvanY
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Manar
Top achievements
Rank 1
answered on 23 Feb 2013, 06:31 PM
Thanks for your reply.

I tried to use another component just to open the generated Excel file and set the page setup as I need.
the component is "Aspose" but I faced the following error while trying just to open the Telerik generated file, but didn't face the error with any other excel files ( Created by hand) 


Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index




So it seems to me an issue in the generated Excel file.


Any suggestion please?

I appreciate your help

Thanks,
Manar
0
IvanY
Telerik team
answered on 27 Feb 2013, 05:12 PM
Hi Manar,

We will need some more information about the report you tried to open. It will also be good if you can test when the exception is thrown. First try exporting and opening an empty report and then if that does not fail start building your report step by step until you reach the point with the exception. The steps to reproduce the issue will help us identify the culprit faster.

Please also note that if the report can be opened in Excel but cannot be processed by Aspose it is actually their problem since the produced xlsx file is valid. If that is the case we will be able to only confirm that we are producing valid xlsx files and you should contact Aspose.

Greetings,
IvanY
the Telerik team

See what's new in Telerik Reporting Q1 2013. Register for the March 4 webinar to witness the impressive new visualizations in Telerik Reporting. Just for fun, 10 webinar attendees will be randomly selected to win a Telerik T-shirt and a $50 Gift Certificate to ThinkGeek. Register now! Seats are limited!

Tags
General Discussions
Asked by
Manar
Top achievements
Rank 1
Answers by
IvanY
Telerik team
Manar
Top achievements
Rank 1
Share this question
or