A problem with Hyperlink in opendocument()!

building reports desktopintelligence
1

Hi to All,

I am facing one problem with hyperlinks using opendocument method in BO Reporter. I have a situation like, one report object should call an other report based on the object value. i.e Hyperlink with passing parameter.
I have written a code for a particular report Object but it is giving the same content what i wrote it there. I do not know what was the mistake i made but i feel my code is correct. Also i am giving the code for you,


="< A HREF = "+Char(34)
+" http: //webi-unixdev/wi/bin/iswi.dll/ WIGenerator/wigenerator/generator/OpenDocument? 
&amp;sDoc=CBRPI
&amp;sTyp=R
&amp;iDocId=349
&amp;sRepo=STCUn
&amp;sOpen=Y
&amp;lsSEnter Call No="+<Call No>+"
&amp;lsSEnter Call No="+<Call No>
+"target=widocview"+Char(34)+">"+<Call No>+"</A>"

can anybody give me the right solution?
if you give,it will be more helpful for me.

Advance
thanks a lot

sakthi (BOB member since 2004-10-05)

2

for my part, i don’t think there’s A solution on opendocument function use and debug. the problem is that opendoc change with bo release and opendoc syntax is not the same in 5.1.8 or in 5.1.1 for example. search on techsupport or on BOB samples of opendoc syntax, make some tests… be patient. Even when you have ound the right syntax, some days it will run perfectly and some other generate error… opendoc is very usefull in some case but not very reliable :cry:

bernard timbal :fr: (BOB member since 2003-05-26)

3

Hi Sakhti,

Could you find a solution for the syntax? I am facing a similar problem. I think i have the syntax right but it is not working. The entire url is fetting displayed as a link rather than on the column values.

Please help me as i have to do this within a day. I am really frustrated :reallymad:

Thanks in advance
Swasti

swasti (BOB member since 2006-02-27)

4

Post your link. We can’t fix it if we can’t see it.

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

5

Hi,

I am using the following code:

="<a href=" + Char(34) + " http://launchpad.nat.bt.com:50357/wijsp/scripts/openDocument.jsp?sDocName=Report 8(21CN)&sType=rep&iDocID=4283&sRefresh=Y” + Char(34) & “>” & & “”

Now, the Broadband values do appear as hyperlinks but another problem has crop up. It is searching for url

http://%20http://…

i am unable to understand why it is taking http twice. Removing char(34), it takes the entire string and no hyperlinks appear.

Please help me. it is very urgent.

Thanks in advance
Swasti

swasti (BOB member since 2006-02-27)

6

swasti, please do not cross-post. I am removing your cross-posting follow-up in someone else’s topic, and your two separate new topics in this same forum. Please keep your related discussion and questions together.

One problem that pops out at me is that your report name seems to have a space and parentheses. The space, for sure, is going to cause you problems. Perhaps you can replace it with:
%20 – the code for a space.

Followup – I’ve discovered yet one more existing topic where you posted a follow-up. I’m not deleting that one since you’ve gotten some additional replies there. I think you’ll find that discussions and answers are easier to follow if you would please post in only one place!

Anita Craig :us: (BOB member since 2002-06-17)