Skip to Content
author's profile photo Former Member
Former Member

Issue in OpenDocument

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 03:12 PM

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

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 08:18 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.