I am able to successfully create a hyperlink. However, I cannot figure out how to pass parameters from one report to another. I’m trying to pass the account number and year over from one report to another. Does anyone know how to use the correct formula so that when you have a list of 50 accounts, that the account you click on, is what is used as a parameter that would be passed over to the other report.
For example:
account 1 1999
account 2 1999
account 3 1999
so if you click on account 2, you would pass over, account number = account 2 & year = 1999?
I can’t see to incorporate the correct text at the end of my hyperlink…
Its the document provided by BO. Look into dir “C:\Program Files\Business Objects\BusinessObjects Enterprise 6\onlineguides\en” dir. I was talking of the document “webintelligence.pdf”.
Regards,
Create a new variable where you would use objects from query
=Concatenation("http://20.15.29.51/wiasp/scripts/openDocument.asp?sDocName=ActivityLog&sType=R&RepoType=Corporate&iDocID=11&lsSCLMNBR=" , Concatenation(<Claim Number(Query 1 with Ex30_Clm)> , Concatenation("&lsSCustClmNbr=" , <Customer Claim Number(Query 1 with Ex30_Clm)>)))
Then include the above variable in the below defined variable
="<a href=" & Char(34) & <The above variable> & Char(34) & ">Reset Activity Filter</a>"
This would create dynamic links which have prompt values for the corresponding rows.
[Edited, when posting code samples please use the code option for formatting. It will preserve any indenting or formatting that you may have done. Thank you, Andreas.]
(BOB member since 2002-06-20)