Webi Report

building reports webintelligence
1

Hi

I am having an webi report and one of the column in the report is MONTHS OD FIXED RATE and the values in that colums are like 215;12345;325678 etc…

In report values are fine but when i export the report to excel and double click on teh values it will bring (-) negative sign.

Can you please help.

Thanks,
Kumar

kumarpjp (BOB member since 2009-04-13)

2

can you export the report to CSV and check whether you are getting the negative symbol?

anil.ganga1 :us: (BOB member since 2007-07-04)

3

[quote:49bb9f5023=“anil.ganga1”]can you export the report to CSV and check whether you are getting the negative symbol?
[/quote]

CSV exports the data provider, not the report.

4

Yeah, I mean Exporting the cube data from the reporting tool :slight_smile:

anil.ganga1 :us: (BOB member since 2007-07-04)

5

Hi Anil/Mark,

The report is scheduled and exported to excel.

the user need the report to excel and don’t want the - negative symbol.

and the report is created using custom SQL.

Thanks,
Kumar

kumarpjp (BOB member since 2009-04-13)

6

Have you changed the number format in the BO report?

7

Yeah i did and it still brigs teh negative once exported to excel.

Thanks,
Praveen.

kumarpjp (BOB member since 2009-04-13)

8

What does it look like if you export to PDF?

9

Are the numbers actually negative, with the negative indicator being suppressed in WebI?

Have you tried just multiplying the number by -1 to see what happens? (Note, this is probably a terrible solution, but it can be a useful piece of the troubleshooting.)

Lugh (BOB member since 2009-07-16)