Skip to Content
0
Sep 21, 2012 at 09:29 AM

#Multivalue error in hyperlink

235 Views

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