Hyperlink in DESKI report

[Former Member]

Hello Gurus,

We are using BO 3.1

My requirement is to hyperlink 2 deski reports.

For example:

Report A has fields (Emp Name, Emp ID)

Report B has fields (Emp Name, Emp Age, Emp Salary, Emp address)

Report B should be hyperlinked to Report A on the field Emp Name. and Report B should retrieve data for just that particular name. Say if I click XYZ(Emp Name) in Report A, Report B should retrieve data of XYZ.

Report B will have a prompt "Enter Emp Name". So when we click on XYZ in Report A, the report B should take XYZ as the answer for the prompt and display the related data.

I have to use opendocument. I searched for opendoucument syntax. But I am not able to implement the same. Can any one plz explain me how to do this, explaining the parameters of opendocument used.

Thanks in advance,

Naveen

[Former Member]

Thanks George. I have a question.

When we have hyper linked reports like this and which have been scheduled in HTML format.

Should all the end users have an user account for BO(DESKI/WEBI) to access these kind of reports.

The reason I am asking this question is when the end user clicks any particular Emp name in Report A, Report B will take that particular name as the parameter for its prompt and executes the Report B.

So I am thinking all the users who access this HTML format of the report should have BO user account, else when they click the hyper linked Emp name, BO might through an error?

Please let me know If I am wrong!

[Former Member]

Naveen, yes you will have to have BO user accounts and these accounts must have at least Refresh rights for these reports if you are setting sRefresh=Y in the openDoc syntax.

[Former Member]

Naveen, I assume the reports are int he same folder, try this syntax for the Emp Name object in Report A.

="<a href=\"http://Servername:port/OpenDocument/opendoc/openDocument.jsp?sType=rep&sDocName=Report%20B&lsSEnter%20Emp%20Name="+[Emp Name]+"\">"+[Emp Name]+"</a>"

George

Edited by: George Pertea on Jun 16, 2009 5:21 PM

Edited by: George Pertea on Jun 16, 2009 5:22 PM