Showing posts with label Export to excel. Show all posts
Showing posts with label Export to excel. Show all posts

Monday, October 22, 2012

Filter issue with Excelsheet exported from Report


As we all know, we can export the CRM report in various formats and one of them is “Excel sheet”. After exporting the report in the excel sheet, there are chances that you may not be able to see the filter on certain columns. You will also notice that two columns get merged in single column and have empty columns. Hence there are two issues, one with column filter and other with the merged columns, as you can see in the below :
 

The actual problem is with the report column and not with the excel sheet. The problem in report is the column width. If a column has width more than 1in then it adds a column extra in it.

Now you just need to set the column width to 1in which is default width of a column, which will solve these problems and there will be no extra column or filter issue.
Hope this help while designing the report which can be exported to the excel sheet.