SQL Server Performance

Exporting SRS reports to excel

Discussion in 'SQL Server 2005 Reporting Services' started by echris, Oct 3, 2008.

  1. echris New Member

    I am trying to export a series of time fields (12:00pm, 2:00am etc) into excel from SRS, when I do this however all the times come across as Negative #"s in excel. I have tried the changing my time in excel to the 1904 date but that just gives back junk.
    Can some one tell me what the statement in sql or switch in excel needs to be to get theses to come across?
  2. satya Moderator

    Welcome to the forums.
    Is that Excel sheet fields are constant or changing as per your report>
  3. echris New Member

    The feilds in excel are static but they all have diferent time values.

Share This Page