How to link the reports from summary to details...

building reports webintelligence
1

Hello All,

I am asked to create a Hyper linking into the reports.We are using BO XiR2.
Please give me a code and Procedure to do it.

My requiremnts is as follows:

In the first block it would be the summary and when they link it has to go the details report.

ClientName Account Number Location.

In the Cell of account Number it would be count(Account Number).When A user click on the account Number it has to show the Details of that Account Number.

Thanks for your help.

Pooja

ktm :us: (BOB member since 2008-11-12)

2

We talked about that here hundreds of times. Do a search for OpenDocument

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

3

I copied the below formula from the forum and changed my IP created one formula as below:

="<a href=http://120.45.125.131:8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?&sType=wid&sRefresh=Y&sReportName=Test&iDocID=1983616&sWindow=New>Click on this "

when i click on the above link it is opening browser and i am getting a message like

Your Security Profile doesnot include permission to view the  document or the document doesnot exist.

I am new to Open DOC and we are using WEBI. I have created one cross tab reports.In that we have a mesaure count([Account Number]). when we click on that Account number it has to show the details of that count.

Any help…

Thanks
Pooja

Thanks

ktm :us: (BOB member since 2008-11-12)

4

try it without the docid.

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

5

Hello All,

I am using Below Code and it is throwing an Error:

=“<a href=” + Char(34) +
“http://120.45.125.131:8080/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocName=Child&amp;sDocTyp=wid&amp;sRefresh=
Y&lsSEnter+Date+of+Service+Start=”
+URLEncode(UserResponse(“Enter Date of Service Start”))

  • “&lsSEnter+Date+of+Service+End=”+ URLEncode(UserResponse(“Enter Date of Service End”))
  • "+ " + Char(34) + “> " +[Service] + " ”

For your Information, Both Reports has object prompts,

Date of Service :Enter Date of Service Start and Enter Date of Service End

Can you guys let me where I am wrong?

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)