Hello,

I am using the Reports module 5.0 ( on dnn 4) and I would like to know how to dynamically generate a URL for one of the fields generated (and displayed) by the initial query for subsequently drilling down to a more detailed view. In other words, how do I generate a query inside the report for a new query?

Example: you show countries and towns (on an entry report page) with town being a link displaying the available pubs in that town.

Is it possible at all?

Thanks,

Franco

I haven't figured out how to create an interactive dropdownlist that is populated from a select statement, then used in a second select statement to create a report.

However, if what you are seeking is simply how to create an URL link within a report, one method is a combination of SQL code and a HTML template for visualization.

For instance, the vendor file has city and country as fields, so a SQL statement like: Select City, Country from vendors produces those two fields as output.

Then set up a HTML visualization file like the following example using googlemaps:
<a href="http://maps.google.com/?q=[City]"  target="_blank">[City]</a>, [Country]<br />

This should produce a list that has the city with a hyperlink to the google maps page for that city.  You'll need to figure out what the URL syntax is for your need and place that in where the google example above is.