XI3.1 Hyperlinking: same Report, new Tab, dynamic ReportPart

Since I’m working on this I thought I’d post progress in case anyone else has similar needs or any more ideas…
Thanks to jsanzone for their nugget in https://bobj-board.org/t/116974 of

I’ve now used this to build

=If(Substr(DrillFilters([Sub Business Unit]);1;1)>" ";Max([Area Office]);If(Substr(DrillFilters([Business Unit]);1;1)>" ";Max([Sub Business Unit]);If(Substr(DrillFilters([Company]);1;1)>" ";Max([Area Office]);If(Substr(DrillFilters([Group]);1;1)>" ";Max([Business Unit]);"Drill Path?"))))

This gives me the value of the Section at any point in the Drill except the first one, i.e. which Drill Path my user has taken.
I can then pass that value into an openDocument.jsp code.

I’m still stuck on identifying which Drill Path, which is the main thing I need to know.
Actually, reading the above back, I don’t know if I’ve made progress or not :hb: :crazy_face:


Neil Phillips :uk: (BOB member since 2002-08-22)