Ruport - how to wrap <a href=" "> tags around text inside a ruport table

Anyone know how to embed a hyperlink in a ruport table? The url is in
mysql. I’m using,after much head-banging, report_table_by_sql to build
a ruport table, which of course, also now contains the url text. I
want to diplay each url as a hyperlink in the browser. I’m lazy an
would like to use a ruby/rails/ruport function of some sort to parse
this url and rewrite it as hyperlink (derivce text
from url
) as part of ruport.

Here’s an example:

This controller code generates a table:

#note : @low = 70 and @high = 100 thanks to params from a form…
#note “link” refers to WAN circuits and not hyperlinks…

@links = Link.report_table_by_sql [ "SELECT headend, out_90th_util,
bandwidth, hyperlink
FROM (SELECT * FROM (SELECT * FROM links ORDER BY link_key
DESC, out_90th_util DESC) t
GROUP BY link_key)t2
WHERE out_90th_util > ? AND out_90th_util < ? ", @low,
@high ]

Here is the corresponding view code that generates simple table in a
browser:

Table Using Ruport

<%= @links.to_html %>

Here is a sample from the browser:

out_90th_util hyperlink bandwidth headend
72
http://www.imadethisup.com/service/generate.cgi?target=%2Fgeograpyisfun%2Farouter99%2Fatm1_ima1;view=Octets;ranges=m%3Ay
3000000 arouter99

I need to subsitute something like this inside the report for the
hyperlink:

arouter99_atm_ima1

I have not yet tinkered with ruport or rails enough to have much of
clue. I’m hoping to get this working so I don’t revert back to perl.
I must admit perl is looking pretty attractive at this point ;-)… I
could try to wrap the http:// in tags inside mysql. But I would like
to know if it can be done in ruport (if I don’t have control of the
database table).

Thanks to anyone who bothered to read this far!

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs