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

Export to Excel - Issue with Excel Filters

4 Answers 179 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
pat.ramadass@emediait.com
Top achievements
Rank 1
pat.ramadass@emediait.com asked on 24 Jan 2011, 01:22 PM
Hi there,

We are using Telerik_Reporting_Q3_2010_v4_2_10_1221_dev within a ASP.NET MVC 2.0 project for some custom reporting. All seems to be working well, but there are issues when the reports are being exported to excel, specifically with the filtering functionality within excel itself. I have attached a screenshot regarding the issue, but very simply it seems like excel is not recognising the values to be used as filters per column, so one is unable to actually filter based on any values.

Any ideas why this may be happening? Have not tested it on other similar projects, but I assume it may simply be down to how we design our reports.

Thanks in advance,

-Pat Ramadass

4 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 27 Jan 2011, 09:23 AM
Hello Pat,

Looking at your screenshot, it seems you have correctly formatted your data as table so that you can sort and filter and there is no apparent reason why it would not work for you. We've tested this on our end and did not encounter any problems (see video). For your convenience I've also attached the report we've used for the test which requires the AdventureWorks installed with the product.

Best wishes,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
0
pat.ramadass@emediait.com
Top achievements
Rank 1
answered on 02 Feb 2011, 02:34 PM
Hi there again,

Thanks for the response, but I really don't know what else to do to make this work. What else could be influencing how the export feature creates the output Excel file? Could it be related to any designer settings on the report itself or even the data to which the report is being bound? Maybe something to do with how the headers are defined?

Sorry it's just really difficult to try spot a pattern here.

Thanks,

-Pat Ramadass
0
pat.ramadass@emediait.com
Top achievements
Rank 1
answered on 05 Feb 2011, 04:15 PM
Hey there again,

Any further ideas/suggestions?

Thanks,

-Pat Ramadass
0
Steve
Telerik team
answered on 07 Feb 2011, 12:49 PM
Hello Pat,

As shown in the video from my previous post, I use a Table item to create tabular layout in the report, so that when you export to Excel, one table row would be one excel row. This way you can format your data as table in the excel file (refer to video) and the sorting and filtering would be enabled for the table columns.

Greetings,
Steve
the Telerik team
Get started with Telerik Reporting with numerous videos and detailed documentation.
Tags
General Discussions
Asked by
pat.ramadass@emediait.com
Top achievements
Rank 1
Answers by
Steve
Telerik team
pat.ramadass@emediait.com
Top achievements
Rank 1
Share this question
or