How to add multiple hyperlink in single column.?

[kangkulbir]

Hi All,

In my prob i have 3 columns say ID, name and Links. for one ID and Name, i have multiple links. i.e ID =1 , Name = Test, Link = http://www.yahoo.com, http://www.google.com,  http://www.community.jaspersoft.com. 

i want to see this record as one row, three lines in link column with all three links. and need all three links as hyperlink to their corresponding internet links.

currently, i have just shown a valid internet links in single column, Adobe Reader makes them links as it has property to show hyperlinks as link, but this has one problem that my column length is specific and when length of internet URL is more than this column length, it automaically wraps it to next line. when links wraps into next line, it gets cut.

Please respond, need immidiate solution.

Thanks in advance

[Anuj Dudhakawale]

You didn't mesioned about what database you are using.

If you are using Oracle 11g, then do following.

Write following query in your dataset on which your table is depending.

SELECT ID,NAME
  ,      LISTAGG(LINK, ',
') WITHIN GROUP (ORDER BY NULL) AS "LINKS"
  FROM   emp
  GROUP  BY
         ID, NAME

After writing query, take all these fields into your table. After you take LINK textfield into your table set it's following properties.

1) Markup ->   html

After setting above property, preview your report.

 

 

[kangkulbir]

hi sir..

i m using sql 2008 and i tried using markup as html..

it shows link in report but prob is that when link is very long,

it wraps into second line and when i place cursor on it in report.. link

breaks after first line...

thanks for ur rply...please comment

[kangkulbir]

hi sir.. i m using sql 2008 and i tried using markup as html.. it shows link in report but prob is that when link is very long, it wraps into second line and when i place cursor on it in report.. link breaks after first line... thanks for ur rply...please comment

[ajinkya_c]

May be possible with crosstab becouse it makes grouping automatically. Add id & name in rowgroup & column group create with any name keeping  with value expression of column group keeping blank, then add your links column in measure with calculation nothing.

Let me know if works.