Generate a Dynamic Hyperlink from XML Data

Hi,
 
I have an XML dataset with values in the following format: 
name value

| 
 ip | 192.168.1.17 | 
 port | 8080 | 
 suburl | report1 | 
Now I have to put an generate an hyperlink, with a combination of the data. 
For example: <a data-ipb='nomediaparse' href='http://192.168.1.17:8080/birt/run?__report=test.rptdesign'>http://192.168.1.17:8080/birt/run?__report=test.rptdesign</a>
 
How to go about this. Please point me in the right direction.

Find more posts tagged with

Magellan BI & Reporting

Comments

micajblock

Use that JavaScript option in the hyperlink editor. See image

megschiru

I have tried something along the following lines:
<ol><li>Created a table of the XML dataset. Made it invisible.</li>
<li>
Created the following script on the table onCreate
var index; myArray = new Array(10); for(index=0; index < myArray.length; index++) { myArray[index]=row['value']; }</li>
<li>
I'm using "http://"+myArray[0]+":"+myArray[1] in the hyperlink
But I'm getting the following result: <a data-ipb='nomediaparse' href='http://192.168.1.17:192'>http://192.168.1.17:192.168.1.17</a></li>
</ol>I think all the array elements seems to contain the first row of the table only.

micajblock

Try putting the script on the detail row of the table.

megschiru

Tried it. Not working

micajblock

Can you provide a sample XML file and Design?

megschiru

Here are the xml and design files. You can see from the design, I've tried using 2 options : 1)Binding to the table 2)Binding to the data set. Both options are not working

micajblock

Apologize for the delay I have been on the road for a while. Attached is a new design that works. You have a couple of mistakes in your code. First the onCreate method will get called every row so your array gets initialized every row. So I initialize the array and index in the beforeFactory event of the report. Second in script to access row data it is slightly different that expression builder. 
BTW, here is a video of mine that explains the order of event.

https://www.youtube.com/watch?v=FQ9VjByPNWM

megschiru

Yes. Works Perfectly. I could figure out that only the first row of the table is getting into the array. But i did not know how to solve the issue. Thanks a Lot, Mr. Block.