Using the SQL Server 2000 Reporting Services
Subject:   2005 SQL Server Reporting Services - Excel export
Date:   2009-01-13 23:41:24
From:   P L
When we export an Excel file from 2005 Reporting Service tool, those datestamp fields cannot be exported directly into a specific format "dd/mm/yyyy" for further manipulation by the Excel users. We cannot find the way out and only tail-made to export as string field "dd/mm/yyyy" and then manually convert using Excel formula. Is there any direct way to export into the specified date format without intervention on the Excel worksheet? Please help.