field is not Date/numeric when export excel using reporting service
Do a project which is using reporting service render a report. In this report, it has some date,numeric filed showing. but when try to export the report to excel, the fields which is date, numeric in excel is general text.
This issues occurs because reporting service design time must use CDate to convert field to date. After done, export field is all OK