I have made a tag cloud using custom code from SQL Jason which displays the words using custom code`Public Function BuildHtmlTag(ByVal Keywrd as String, ByVal Num as Integer, ByVal FColor as String) AS String HtmlTag = HtmlTag & "" & Keywrd & " "
End Function` This works fine but I would like to drill through to another report on the words. I have tried drill through expression in the textbox using Lookup, MultiLookUp and LookupSet functions but can only succeed in getting the first value returned. Does anyone know how to either return multiple values to a text box that I could use for the drillthrough action, or how to adjust the custom code to allow drillthrough?
You can adjust the code to have links to other reports by using the <a> tag in the HTML. You'll have to build a url to the report that you want to link to & use parameters.
For example:
Public Function BuildHtmlTag(ByVal Keywrd as String, ByVal Num as Integer) AS String
HtmlTag = HtmlTag & "<a href=""http://foo/reports/reportb?a=" & Keywrd & """><font size=""" & FontSize & """>" & Keywrd & " (" & Num & ") </font></a>"
Return Keywrd
End Function