Advanced hyperlink syntax BO XI3.1

building reports webintelligence
1

Hi i have created a hyperlink syntax in XI3.1.

i have Year and revenue in parent report.
In child report i have set prompts.Year is in section and the table has State and revenue.

So when i click year in parent i should get only that year data (which i clicked) from child report.

First time i used Webi XI3.1. Java report panel. Its not taking ahref. The syntax has to start from http.
I created a syntax to open the child from parent but something is missing and it opens data for the one year only which is selected in prompt when creating child report.

Below mentioned syntax is being used:

http://boserv:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sWindow=New&sRefresh=Y&sDocName=staterev&lsSYear="+[Year]+"\">"+[Year]

Please provide your suggestions. I have checked different posts and referenced a lot of documents but no iam not able to get this code correct.

Any help appreciated.

Bobjrookie (BOB member since 2008-01-10)

2

Please try to take look at this problem friends.
In case you require any more information or want me to simplify the explanation of the problem please let me know.

If this is the correct syntax and if its something else that causing problems just let me know. i need a resolution to this thing. Its important.

Bobjrookie (BOB member since 2008-01-10)

3

Please try this:

http://boserv:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sWindow=New&sRefresh=Y&sName=staterev&lsSYear%3A="+[Year]+"\">"+[Year]

I assume that your prompt in the child report looks like “Year:” but not “Year”.

If this is not so please provide the whole hyperlink cell formula text.

DG

Dmitry Grekov :ru: (BOB member since 2009-09-29)

4

Hi Dmitry

Thanks for your reply.

My prompt is Year only. I removed : when i created the prompt.

I want to know what %3A is used for.

Apart from that ,the code posted in my first reply is the one i am using. But as its not working posted it here.

Thanks in advance.

Bobjrookie (BOB member since 2008-01-10)

5

What a wonderfull tool we are using :mrgreen:

Do the follwing:

  1. rename the input parameter (prompt) in your child report into ‘Year:’
  2. replace the hyperlink cell text with the following:
    =“<a href="…/…/opendoc/openDocument.jsp?&sDocName=staterev&sType=wid&sRefresh=Y&lsSYear%3A=”+URLEncode(“”+[Year])+“&sWindow=New" title="”+(“View “+[Year] + " details”)+”" target="_self" nav="doc">“+[Year]+”"
  3. Enjoy

Dmitry Grekov :ru: (BOB member since 2009-09-29)

6

Hi Dmitry

I was trying to modify my hyperlink as per the syntax of BO R3, but no success, below is the link, there are lots of parameters we are passing to it, n these are working fine.

but everytime i try to run this hyperlink i m getting an errror “404 Missing Page”. :frowning:

=If([Count Of Programs] = 0 Or IsNull([Count Of Programs]);0;"<a href=http:/../../OpenDocument/opendoc/openDocument.aspx?sDocName=xyz&amp;sWindow=New&amp;sRefresh=Y&amp;sReportName=xyz&amp;lsMProgram+Health="+Replace("*";" ";"")+"&amp;lsMProgram+Class="+URLEncode([Health By Project Class].[Ms Program Class Vis])+"&amp;lsMProgram+Priority="+Replace("*";" ";"")+"&amp;lsMProgram+State="+Replace("*";" ";"")+"&amp;lsMEnter+Start+Date=*&amp;lsMEnter+End+Date=*&amp;lsM" + URLEncode("03. Enter Region(s) (* for All)") + "=" + URLEncode(UserResponse("03. Enter Region(s) (* for All)"))+"&amp;lsM" + URLEncode("08. Enter Sub Department(s) (* for All)") + "=" + URLEncode(UserResponse("08. Enter Sub Department(s) (* for All)"))+"&amp;lsM" + URLEncode("Enter Program Sponsor Name  (* for ALL)") + "=" + URLEncode(UserResponse("Enter Program Sponsor Name  (* for ALL)"))+"&amp;lsM" + URLEncode("Enter Program Manager Name  (* for ALL)") + "=" + URLEncode(UserResponse("Enter Program Manager Name  (* for ALL)"))+"&amp;lsM" + URLEncode("01. Enter the Program(* for all)") + "=" + URLEncode(UserResponse("01. Enter the Program(* for all)"))+"&amp;lsM" + URLEncode("04. Enter Super Division(s) (* for All)") + "=" + URLEncode(UserResponse("04. Enter Super Division(s) (* for All)"))+"&amp;lsM" + URLEncode("05. Enter Division(s) (* for All)") + "=" + URLEncode(UserResponse("05. Enter Division(s) (* for All)"))+"&amp;lsM" + URLEncode("06. Enter Super Department(s) (* for All)") + "=" + URLEncode(UserResponse("06. Enter Super Department(s) (* for All)"))+"&amp;lsM" + URLEncode("09. Enter Sub Department2(s) (* for All)") + "=" + URLEncode(UserResponse("09. Enter Sub Department2(s) (* for All)"))+"&amp;lsM" + URLEncode("10. Enter Cost Center(s) (* for All)") + "=" + URLEncode(UserResponse("10. Enter Cost Center(s) (* for All)"))+"&amp;lsM" + URLEncode("07. Enter Department(s) (* for All)") + "=" + URLEncode(UserResponse("07. Enter Department(s) (* for All)"))+">"+If(IsNull([Count Of Programs]);0;[Count Of Programs])+"</a>")

Any kind of help from all/anybody is really appreciable…

Thanks in advane.

[Moderator Edit: Added code formatting - Jansi]

Zeenat :india: (BOB member since 2007-12-11)