Search code examples
reporting-serviceslookupdrillthrough

SSRS drilldown in text box tag cloud

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?

Solution

  • 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