Skip to Content
0
Former Member
Aug 09, 2007 at 02:26 PM

Problems while downloading reports to excel

26 Views

Hi All,

I have downloaded the reports from WAD to excel, Here I am facing a peculiar problem like

the Fiscal week for the expended row shows 00.00.0000 and has 'X" prefexing the row but beneath the expended row other records shows correctly.

For eg

the Fiscal week shows weeks show as 001.2005 and but in the spreadsheet it shows as 00.00.0000 and therefore doesnt indicate the week number.

Fiscal week Fiscal Period

00.00.0000 01 2005

01.01.2005

01.01.2005

02.01.2005

02.01.2005

00.00.0000 02.2005

01.02.2005

01.02.2005

05.02.2005

05.02.2005

Also the records in the excel sheet has duplicate entries

Any help will be appreciated.