How to automatically generate drill through hyperlinks based on query result

aesfandi

I have a query returning large amount of rows/columns data displayed in a table (master
report). I need to make each element of this master report hyper-linked based on the information contained in that element. For example for a 4 by 5 table, I need to have 20 unique hyper-linked elements generated on the fly using row and column names (dates and product-names, as example, passed as parameters) of each element. Clicking on an element would then open a new detail report based on these parameters. (The name of the detail report should also be constructed on the fly using these parameters.)

Since actual master report can contain tens of columns and thousands or rows, and varying, it is not practical to use the Hyperlink option in the properties tab to manually generate an individual drill-through for each column.

Is this possible and how?

mwilliams

So, you want every possible element to be hyperlinked, but you don't want to have to add hyperlink functionality in the property editor for each column? Is this correct? You might be able to add hyperlinks in the table script dynamically. Another possibility could be to build your table dynamically from scratch in script, if you know what the columns for each table will be. Another could be to access your data with a scripted dataSet and create a HTML link string for each and use HTML type text boxes in your table, rather than data elements to display your HTML links. Hope this helps.