Open Drilldown in a New Tab

Open Drilldown in a New Tab

By Marilyn Patchen Beyer
Minnesota Department of Education

Problem:

The question is started from a Focal Point post: Is there a way to open a drilldown report in a new tab (rather than a new window)?

Solution:

With some others' opinion, the final solution is as following.

The answer has 3 parts:

1)Set the Browser to “Open links from other programs in: A new tab in the current window."“Open links from other programs in: A new tab in the current window."

2)The following is in the stylesheet of the graph I’m drilling from (There are 4 DRILLMENUITEMs) :

TYPE=DATA,
ACROSSCOLUMN=N1, "Chart column to drill from" 
TARGET='_blank', "(_blank - NOT _new)" 
DRILLMENUITEM='Chart of Student Count by Year', "drill menu item" 
FOCEXEC= chart2.fex( \ "drilldown fex to execute" 
GRAD_YEAR=A1 \ ), "Parameter passed to fex" 
DRILLMENUITEM='Detail Report on the Screen',
FOCEXEC= report1a_test.fex( \
GRAD_YEAR=A1 \
WFFMT='HTML' \ ), "Specify the output format!" 
DRILLMENUITEM='Detail Report in PDF',
FOCEXEC=report1a_test.fex( \
GRAD_YEAR=A1 \
WFFMT='PDF' \ ),
DRILLMENUITEM='Detail Report in Excel',
FOCEXEC=report1a_test.fex( \
GRAD_YEAR=A1 \
WFFMT='EXL2K' \ ),
$

3)Be sure to include the following in report1a.fex: ON TABLE PCHOLD FORMAT &WFFMT.EVAL (The format is specified in the DRILLMENUITEM.)

As an additional benefit, users can decide AFTER they see the report if they want the drilldown on the screen, in PDF, or in Excel.

Any questions, please contact Marilyn at Marilyn.Patchen.Beyer@state.mn.us.