Issue in OpenDocument

[Former Member]

Hi All,

We are facing an issue while using the opendoc url in webi reports.

The review id has to be passed from Parent report to child report which is of Datatype number.

Eg; The review id is like 12345.

While passing this it is stored as 12,345. and throwing the error -  Contains the Invalid Numeric Value

To change the format to 12345 used the fuction FormatNumber(ReviewId; "######") which then converts to string object and throwing the error: The database error Text is ORA 01772: invalid number.

In child report the object ReviewID which is prompt is Numeric not string.

Is there any way to pass the parent report ReviewId to child report without changing the datatype of the reviewid in child report to string type.

The version we are using is Business Objects XI3.1

Please let me know how to resolve this.

Thanks in advance,

Priya

[Former Member · Accepted solution]

Did you tried converting that back to number in the parent report? something like:

ToNumber(FormatNumber(ReviewId; "######")

[Former Member]

You could also try setting the object format at the Universe level, so that it won't display a comma in the number at all, but you don't have to change the format.  In the universe, you can right click on an object and select "Format Number" to access this.

Mark