Hyperlink object

building semantic layer
1

Hi Folks,
I have created a hyperlink object in universe. It is working fine but when I select sRefresh=Y , it is not refreshing the report and shows the prompt window.
Object syntax in universe:

'<a href="http://server:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&amp;sRefresh=Y&amp;iDocID=1234&amp;lsSSelect:="+table1.column1+">'+table1.column1+'</a>'

Please give me your suggestions to open the report with refresh.
Thanks in advance.

Arjun (BOB member since 2008-07-28)

2

Dear Arjun,

You mean when you click the hyperlink in the main report it doesn’t open the child report rather it is asking you for prompt…

Is that what you mean?

Cheers,

shiva.tomar (BOB member since 2007-10-05)

3

Check the Prompt text in the report you are linking to. Your code has lsSSelect:. The Prompt text needs to be Select:. If it isn’t you can either change the prompt text or change the lsSxxxxx variable in the hyperlink to match what the report has

tmarion :us: (BOB member since 2002-08-20)

4

Thanks for the responses.

[quote:64b4a31c7c=“shiva.tomar”]You mean when you click the hyperlink in the main report it doesn’t open the child report rather it is asking you for prompt…

[/quote]
Yes.

@tmarion: I have checked. Prompt message is the same.

Arjun (BOB member since 2008-07-28)

5

Ok in that case i feel the problem is with your prompt as tmarion said…

Check the following.

  1. In your hyperlink, whether you have used lsS or lsM… depending on the prompt you have created for the child report.

i.e. If your prompt in the child report is created using = operator you need to use lsS in your hyperlink to pass the value.
If your prompt in the child report is created using In List operator or any operator that uses multiple values then use lsM to pass the values.

lsS<prompt name>=<value> - Name the prompt. 
lsM<prompt name>=<value_1>;<value_2>;.....so on - Name &amp; Values of the prompt.
  1. Ther prompt name that you specify in the hyperlink matches exactly with the prompt that you have created in the child report.
    It has to be identically same at both the places.

Hope this helps you. Let us know what you get. :wave:

Regards,

shiva.tomar (BOB member since 2007-10-05)

6

Dear Shiva,

I have checked what you mentioned and I followed.

Still child report is not refreshing :roll_eyes:

Arjun (BOB member since 2008-07-28)

7

Could you please post us your hyperlink syntax.

That can help us in understanding the problem more.

Regards,

shiva.tomar (BOB member since 2007-10-05)

8 
'<a href="http://server:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&amp;sRefresh=Y&amp;iDocID=12345&amp;lsSEnter State:&amp;lsSEnter Year:"+URLEncode("+Agg_yr_qt_rn_st_ln_ca_sr.State) +">'+Agg_yr_qt_rn_st_ln_ca_sr.State+'</a>'

It is dispalying fine if sRefresh=N.
Two prompts are there in child report.

Arjun (BOB member since 2008-07-28)

9

In the formula mentioned below:

Kindly check with the URLEncode part. To me the problem seems to be in that…

Please share the response you get.

Regards,

shiva.tomar (BOB member since 2007-10-05)

10

Arjun,
If it works fine with sRefresh=N why not just leave it that way? It’s possible that with sRefresh=Y it is intended to show the dialog or it could be a bug in the code. Either way, since sRefresh=N works then you don’t need it to be Y. The target report is going to refresh anyway (at least it should) because it has prompts.

tmarion :us: (BOB member since 2002-08-20)

11

yeah i think i got your problem…

In this formula you’ve mentioned state variable twice… due to which it is prompting you for the year value… which acually you are not passing here.

So just check it… i think it’ll go on a rollercoaster…
:wink:

Cheers,

shiva.tomar (BOB member since 2007-10-05)