Skip to Content

               The insipiration for writing this blog came from the WebI forums, where I once posted a question that bogged me down. The question was “how to create  a hyperlink “on the fields in WebI that are not marked mandatory and therefore they may be null or empty.To my surprise, I found there were lot of BOBJ developers  who were struggling on the same issue. Here in this blog, I have tried to cover the problem and the relevant solution. 

Consider for e.g. we have field named “Amount” in cross-tab table where few fields are empty as shown in figure below.

 

image

 

 

Now, we put the hyperlink on the cell by rightclick–> New Hyperlink and the following pop-up window would appear.

 

image

 

Specify your link over here. for e.g. write “www.google.com” . Specify click parse for input parameters. Specify current/New Window . Click OK. You will see the following UGLY screen. 

 

image

 

We can see here, the fields that are not null are properly displayed with hyperlink but the null or empty fields (marked in Red) shows the URL of the next page, which is intolerable by client/user who is viewing the reports.

To rectify this problem. Click on formula toolbar which would look like below image.

 

image

 

On this toolbar, use the formula If(IsNumber) and Then on the Amount Field as shown in the figure below.

 

image

 

Click Ok and the error will be rectified as shown below.

 

image

 

Everytime you make a change in Hyperlink (parameters or  URL) this error would re-occur. Therefore, the change in formula toolbar should be done after editing the hyperlink. If there is Text field then NotNull and <>(Not equal to) should be used for getting the same results. 

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply