#Multivalue error in hyperlink

[#1]

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

[vinayakgole]

Thanks Marianne,

Yes we have already considered the Bex pre query option however, there are some complexities with it and we are trying to work out a solution at the BO level.

The child is on a different Bex query and we do have a prompt there but the challenge is to pass the values to the prompt. We are also trying to put the list into a string with semi colons. Can you please think of anything that comes at the top of your mind about how we can achieve this? Concatenation is out of question and we are unable to find any other way to achieve this

Hi Bill,

thanks for your suggestion, we already tried it out but it doesnt seem to work in our case.

Best regards,

Vinayak