Web I Hyper Link

[system]

hi,
I have a one issue in WEBI,
I have a one report in that it is displaying employee name as as hyper link
when i click on the particular employee name it has to display our required employee detaails how to achieve this problem

---

shekarbob (BOB member since 2007-07-20)

[system]

WebI/DeskI XI R2 Hyperlinking

Reports Hyperlinking •Webi to Webi •Deski to Deski •Deski to Webi •Webi to Deski This document features XI R2 report Hyperlinking methods using OpenDocument and other techniques. Prabhat, DANA CORPORATION Reports_Hyperlinking1.zip (8.0 KB) prabhat (BOB member since 2007-01-16)

The OpenDocument function is the only way to do this. It has been discussed her hundreds of times.

---

Steve Krandel (BOB member since 2002-06-25)

[system]

Try s earch on BOB, suggested keyword:

openDocument

or look here

---

Andreas (BOB member since 2002-06-20)

[system]

i know how to open new WebI report.
my employee names are displaying as hyper link when i click on particular employee how can i capture the employee name which i have clicked.

---

shekarbob (BOB member since 2007-07-20)

[system]

Hi,
That’s what they are suggesting. Using OpenDocument open a employee details report. That would meet your requirement.

---

harinmenon (BOB member since 2007-06-23)

[system]

Hi shekarbob,

Suppose you have detail report Employee_Detail, Then you needs use a prompt(Universe level) in that report.

Consider this prompt have text message “Select Employee Name” and EmpName is the object in Summary report on which you have created hyperlink.

Now when you click on the any particular EmpName, that EmpName would get pass as a parameter to the prompt in detail report.
And the detail report will have data for that particular employee name.

You can refer below syntax

="<a href=http://server name/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocType=wid&amp;sDocName=Employee_Detail&amp;lsM"+URLEncode("Select Employee Name")+"="+ URLEncode([EmpName])+" >"+ [EmpName]+ "</a>"

Thanks

---

patneel (BOB member since 2006-11-02)

[system]

In my employee name having to names like firstname lastname
ex:“john smith” when i passing this name it is taking only john not smith
when i remove space between it is accepting how to pass total name.
i tried like “lsMURLEcode(“enter name”)=“john”+” "+“smith”
but it is not accepting.

---

shekarbob (BOB member since 2007-07-20)

[system]

Hi,

Please give more details, like

1. Your prompt syntax which you have created in universe.
2. did your first name and last name are the separate objects in universe.
3. Did you want to put hyperlink on First name || Last name? Currently on which object you have put the hyperlink?
4. Your Hyperlink syntax

Thanks

---

patneel (BOB member since 2006-11-02)

[system]

http://www.geocities.com/prabhatdotnet/Reports_Hyperlinking.doc

---

prabhat (BOB member since 2007-01-16)

[system]

from data base it is coming like “john smith” we are not concatinating any where.

---

shekarbob (BOB member since 2007-07-20)

[system]

Hi Shekar,
create a variabl in report level for employee name.
like this : empnamevar=URLEncode[employeename]

and use this empnamevar in opendoc syntax here…lsSempname=[empnamevar]

and for the display purpose use empname itself …

try this …

Thanks

---

mnarne (BOB member since 2007-09-17)

[system]

How to pass more than one prompt values at a time one is string another one is date format.

---

shekarbob (BOB member since 2007-07-20)

[system]

Hi,

You needs to have prompt for Date field in child report, You can refer below syntax

="<a href=http://server name/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocType=wid&amp;sDocName=Employee_Detail&amp;lsM"+URLEncode("Select Employee Name")+"="+ URLEncode([EmpName])+"&amp;lsM"+ URLEncode("EnterDate")+"="+URLEncode([Date])+" >"+ [EmpName]+ "</a>"

Thanks

---

patneel (BOB member since 2006-11-02)

[system]

Hii Think,

Here there is no need to goto the prompts.

our requirement is at a time u can clicking on one particular employee.

for this u can make a ‘reading the content of that particular employee’ by

using urlencode function and pass that value to the details report as a

filter value. in details report u can place the filter object for employee

name.

as my idea.

---

rpothineni (BOB member since 2008-01-02)

[system]

How can we pass the Filters to Child report.

---

shekarbob (BOB member since 2007-07-20)

[system]

You pass filters to the child report as prompts. I believe that’s the only way. The URL will fill in the prompts so that the prompts are not displayed.

---

Steve Krandel (BOB member since 2002-06-25)

[system]

Make two Variables:-

=UserResponse(DataProvider(),“Select Beginning Date”)

Code:

=UserResponse(DataProvider(),“Select End Date”)

="<a href='http://xyz.com:8085/wijsp/scripts/openDocument.jsp?&amp;sDocName=YOUR_DOCUMENT_NAME&amp;sType=wid&amp;iDocID=99999&amp;sRepoType=Corporate&amp;lsSPrompt1="+UserResponse(DataProvider(<Object>),"Prompt Text to pass on to next Report")+"&amp;lsSSelect Beginning Date="+<Date1>+"&amp;lsSSelect End Date="+<Date2>+"&amp;lsMSelect Location (Type ALL for all Locations)="+(<Some Object>)+"'> Type Text to show in the Link </a>" 

You can pass Multiple values for your filter…as a semicolon delimmited characters/numbers…But you need lsM for those values…[/code]

---

prabhat (BOB member since 2007-01-16)

[system]

I am Using same syntax like what u mentioned

="<a href=https://businessintelligence.dev.arbitron.com/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocName=PHSBonus_Summary&sRefresh=Y&lsS"+URLEncode(“Enter PRS Name:”)+"="+[PRS]+"&lsS"+URLEncode(“Enter Start Date:”)+"="+[Date2]+">"+[PRS] +""

but it is taking firts prompt only it is not takeing second prompt.

---

shekarbob (BOB member since 2007-07-20)

[system]

Try using single quotes before and after hyperlinked address

As

=""

---

prabhat (BOB member since 2007-01-16)