6 Answers, 1 is accepted
0
Hi Mike,
Most likely your items are not aligned and spacer rows/columns are created. Try to align report items in rows and columns so that their edges coincide. The white space in a report section, that is the space unoccupied by report items, will be emulated by empty rows and columns known as spacers. The better report items are aligned horizontally and vertically with respect to one another at design-time, the less spacer rows and columns will be produced. Use the Visual Studio Formatting Toolbar to quickly align report items. More info on is available in the Design Considerations section and specifically the excel article. We suggest you go through all of them so that you are aware of their peculiarities and know what to expect.
Greetings,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Most likely your items are not aligned and spacer rows/columns are created. Try to align report items in rows and columns so that their edges coincide. The white space in a report section, that is the space unoccupied by report items, will be emulated by empty rows and columns known as spacers. The better report items are aligned horizontally and vertically with respect to one another at design-time, the less spacer rows and columns will be produced. Use the Visual Studio Formatting Toolbar to quickly align report items. More info on is available in the Design Considerations section and specifically the excel article. We suggest you go through all of them so that you are aware of their peculiarities and know what to expect.
Greetings,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Spiros
Top achievements
Rank 1
Rank 1
answered on 17 Jun 2009, 08:32 PM
Is it possible to export only the data with out any formating from the report.
0
Hello Spiros,
We believe this is what the csv format has been designed for.
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
We believe this is what the csv format has been designed for.
Best wishes,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
Farah
Top achievements
Rank 1
Rank 1
answered on 07 Jul 2014, 05:51 AM
I have a report with 6057 rows. However, when I export it to Excel it generates 6080 rows. Why 23 records added to excel? How to solve this problem?
0
Farah
Top achievements
Rank 1
Rank 1
answered on 07 Jul 2014, 05:52 AM
I have a report with 6057 rows. However, when I export it to Excel it generates 6080 rows. Why 23 records added to excel? How to solve this problem?
0
Hello ,
Most probably there are merged cells or other report sections which occupy additional space. Please check the Design Considerations for Excel Rendering article and the paragraph regarding Merging Cells.
Regards,
Stef
Telerik
Most probably there are merged cells or other report sections which occupy additional space. Please check the Design Considerations for Excel Rendering article and the paragraph regarding Merging Cells.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.