Linking reports

Is there a way to link a report by creating a cell within a current report and placing the URL(UNIX path) within the report.

Sorry, did I mention we are running BO over Sun Solaris? But we still should be able to link this, the thing is figuring it out.

Thanks for any ideas.


toscajo (BOB member since 2002-09-04)

Do a search for OpenDocument. You’ll find the solution there.

opendocument* is how I would search.


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

Thanks, unfortunately, Open document doesn’t help much. Most of the linkage answers I found were primarily dealing with a Windows environment.
Going through FullClient and UNIX, there doesn’t seem to be any clear cut way of doing such a link. At least, I can’t find it yet.

Thanks.


toscajo (BOB member since 2002-09-04)

On Unix you will deal with JSP code, OpenDocument works with ASP and JSP.


Andreas :de: (BOB member since 2002-06-20)

For linking the reports, we are using the server name as part of the href value , in real scenario if we migrate the reports from development to production environment , it might have a different server name. In that case do we need to manually go to each report to change href value to point to the production server name or is there any alternative to do that.


mjohnson (BOB member since 2004-07-31)

Can anyone suggest a way to declare a global variable which needs to be used by all the report, i.e. something like a porperties file.


mjohnson (BOB member since 2004-07-31)

Help me understand what you mean by “global variable” …

  • A filter applied to all reports?
  • A report level variable (with a formula)?
  • VBA variable?
  • Something else I’ve missed totally?

An example, including how you hope to use it, would be helpful.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

I mean a variable that holds the Server Name and Port Number which I need to use in all of my master reports to link to the details. The bottomline is If I deploy my reports to the production I need not change my server name and port number in all of my master report href link, instead I could just change in one place that would change all the href values. FYI, I am not using VB application.


mjohnson (BOB member since 2004-07-31)

It sounds like you’re referring to a universe object. Your href code can be in the select of an object, and you can change it at anytime, allowing your reports to grab the update.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

What about the doc id? Don’t you have to put in the doc id for every report you want to link to? Isn’t the doc id different for each environment? You may still have to manually code this in. :roll_eyes:


kmahler :trinidad_tobago: (BOB member since 2002-07-29)

Well, I tried to create an configuration table that holds the server name, port number and created the object in the universe by refereing that column. I get an error(Incompatible variable types) when I try to use the value as a part of the href in the master detail report for the key value since the master report has no join with the configuration table.


mjohnson (BOB member since 2004-07-31)

You don’t need to code the server name and port in the link unless you’re intentionally jumping to another server. This code:

<a href="/wijsp/scripts/openDocument.jsp?sType=wid&amp;sRepoType=Corporate&amp;...

will call the report from the server that the parent report is being run on.

I actually pass the link to a javascript function that then calls location=, but using a href should work the same way.

Of course, they don’t tell you about this in the manual…

Joe


joepeters :us: (BOB member since 2002-08-29)

In v6 you don’t need the DocID number in the link. The Doc Name and Domain are all that is needed. This is a good thing, since the Doc ID number isn’t as easy to find as it was in v5.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

I tried the way you proposed a href="/wijsp/scripts/openDocument.js?..it doesn’t work and expects the server name whenever I need to make the link.


mjohnson (BOB member since 2004-07-31)

What error do you get?

I just tried my link using a href instead of location=, and it worked the same way. Here’s my complete string:

<a href="/wijsp/scripts/openDocument.jsp?sType=wid&amp;sRepoType=Corporate&amp;sDoc=Performance+Production&amp;iDocID=21098&amp;lsM1{lots of prompts here}&amp;sRefresh=N">click</a>

I did use Format as HTML instead of Hyperlink, don’t know if that would make a difference…

Joe


joepeters :us: (BOB member since 2002-08-29)

carefull because opendoc syntax changes according to the version of webi !


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

Very true – but we’ve used this syntax on 6.1b and 6.1.3, and I think we were using it when we were on 6.1a.

Another possibility may be the web server, we are on Apache/Tomcat.

Joe


joepeters :us: (BOB member since 2002-08-29)

I am getting page cannot be found error. And moreover the sType is rep and not wid.


mjohnson (BOB member since 2004-07-31)

Weird - I tried it with a rep and that worked too. Can’t think of anything else – can you do a view source from Infoview to see exactly how the link is being built?

Joe


joepeters :us: (BOB member since 2002-08-29)

Correct me if I am wrong. I guess the reason why I am not able to try with relative path is, since my documents are physically stored in the repository and not in the app server location, by looking at your href example it might be possible if I would have created those reports through webi and it might have stored as .wid in the server and in that case using the relative path would access the report. In my case I have created my reports through the client version and I publish it to the corporate document and which requires the server name to part of the Href value. And I don’t know why BO doesn’t have much of flexibility in configuring the server name and other system level configuration.


mjohnson (BOB member since 2004-07-31)