Export to Excel - Issue with Excel Filters

[[e-mail]]

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

[Steve]

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

[[e-mail]]

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

[[e-mail]]

Hey there again,

Any further ideas/suggestions?

Thanks,

-Pat Ramadass

[Steve]

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