Format when export to Excel.

building reports webintelligence
1

Hi,

I am facing some format issue when i am export the report in to excel.

we create one report in 6.5 version with the Org name and it has hirerchey level.

when it is exported yo PDF the same structure is displayed and when it is exported tp Excel, the same sturture is not displayed.

is there any tricky way to same the same format as in pdf when it is excpot into excel.

I am attaching both the format for the reference.

Thanks
Geetha

we need the excel format which is displayed in PDF
Org_Hierarchy_Report[1].pdf (38.0 KB)
Org_Hierarchy_Report(1).xls (47.0 KB)

geethanjali (BOB member since 2010-06-07)

2

I am assuming that you are padding with spaces to show the hierarchy. When BO converts to Excel, it trims leading multiple spaces into a single space.

So can you pad with leading “.” or “_” which will be preserved in Excel.

Mohan :us: (BOB member since 2002-08-15)

3

Thanks a lot, i use ‘*’ and it shows as we expected when exported to Excel.

Thanks once again.

Thanks
Geetha

geethanjali (BOB member since 2010-06-07)