Dynamic AI Support Forum

I can't seem to figure out the trick to make one report drill down to another report.
The docs have a screen shot on page 40 that shows a report in the list, but in my case my choices are always limited to only:
Form
Do not allow drill-down to form
Form (floating layout)
Form (column layout)

I tried defining Dynamic relations between the table/views involved but that didn't do it.

What do I need to do?

Thanks
Bob

Hi Bob

You are right about the need to setup a relation between the datasources. Once a relation is set, every report based on one of the sources can be set to drill to reports based on the other.

Below is an example that I just created based on the Dynamic AI Demo:

First I set up the relation:



In a report that is based on one the sources in the relation (in this case a contact list):



Drill down to is changed to the relevant related report:





When report is executed related drill down will be show as



This example shows a simple related drill between a list and a pivot table with a fixed relation point (Contact ID).

In case that column names are identical in the two datasources Dynamic AI also offers automatic identification or the related drill down based on the users "click".

Mikkel

Thanks Mikkel,

I understood correctly. I just didn't do it correctly. I was using an actual table instead of my DAI view for the table in my relation. A report now appears in the available drill-down list based on the relation.

WHAT A POWERFUL TRICK!

Bob