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.
="<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.