#Multivalue error in hyperlink

[vinayakgole]

Hi,

We have a situation where in we need a scorecared as a parent report which will then pass on the relevant information to the child detail reoprt.

The scorecard will look like:

Red                      Yellow                 Green

------                     --------                 ---------

10                          20                       30

----                        -----                     ----

  |                            |                           |

hyperlink            hyperlink               hyperlink

The hyperlink should pass values to the child report which should show the details for the selected customers.

Hyperlink:

="<a href=\"../../opendoc/openDocument.jsp?sRefresh=Y&sDocName=Child Report&lsMCustomer="+URLEncode(""+[Customer])+"\" title=\"\"target=\"_blank\" nav=\"doc\">"+[Status Count] +"</a>

The child report has a prompt for customer.

However, the measure Status Count on the parent report always throws up a #Multivalue error. I know this issue has been discussed in some other posts. But I have started a different thread so we can arrive at a work around. If in the case above, I cant use a hyperlink to pass multiple values, what can be a better way.

The above is using

WebI 4.0 over Bex using a BICS connection.

Thanks,

Vinayak

[Former Member]

Hello,

You could try using

+Sum([Status Count]) +"</a>

at the end of the hyperlink formula. That may work.

Thanks