"Chaining" report update on report drill

[Martin Yergeau]

Hi community,

In a dashbord, I am trying to update report-2 according to report-1 drill selection.

How to accomplish that already?

[David Beagan]

Dashboard constructed with App Studio?

[Martin Yergeau]

Yep

[David Beagan]

Procedure1.fex ( note, the drill down has TARGET=iframe2 )

 SET PAGE=NOLEAD
 TABLE FILE GGSALES
 SUM UNITS
 BY REGION
 BY ST
 BY PCD
 ON TABLE SET STYLE *
 TYPE=DATA, COLUMN=PCD, TARGET=iframe2, FOCEXEC=./Procedure2.fex(PCD=PCD),$
 END

Procedure2.fex

 SET PAGE=NOLEAD
 TABLE FILE GGSALES
 SUM UNITS
 BY REGION
 BY ST
 BY CITY
 BY PCD
 WHERE PCD EQ '&PCD'
 END

Your HTML page in App Studio see that the Unique Identifier matches the TARGET= in Procedure1.fex.

When the HTML page is run, you can click one of the drilldown links and see the drill down report.

 

Edited September 26 by David Beagan

[Martin Yergeau]

Thanks David