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