How to parse html for and display hyperlinks?
I'm trying to design a report that has a text field that contains html formatted text and includes links. These links need to be clickable in a thick client Java application I'm developing and the only way I can see in Crystal Developer to make a clickable link is to have a discrete text element with a hyperlink (set using the hyperlink tab in the element properties) for each link.
The problem I have is that there can be any number of links in the html and I need a scalable way to extract and display these links.
So far I have used formulas in Crystal Developer to parse the html and extracte the links into a fixed size array and then display each link in a separate text element. I would like to be able to have only one 'link' text element in the report design and create as many link elements as required depending on how many links are present in the html.
How is this possible? With some funky grouping voodoo maybe, or something else? Please help me achieve this.