I have a report with a very large number of drills that is taking forever to render. When I comment out the drills, it renders very quickly. I appears that the fexes for the drills are evaluated every time the report is executed. Is there an option to stop that from happening? Basically only evaluate the fex for the drills upon the drill being clicked? Any insight is greatly appreciated! Cheers!

This message has been edited. Last edited by: <Emily McAllister>,

quote:

It appears that the fexes for the drills are evaluated every time the report is executed

This is most likely not the case, how did you determine this?

What kind of report is this? HTML, Active HTML?

Please update your profile to include the version of WebFOCUS you're using.

Thank you for your response Francis! This is an assumption made in that when I execute the report, it takes minutes to run. When I comment out the drills, it runs in seconds. The assumption is that the drills are being evaluated individually. This is in an HTML report on 8.105. I will get my profile updated

Please post the code (between code tags). I don't see why including drilldowns would affect the speed of displaying the report. The additional HTML for the drilldowns would be fairly small.

[code]

YOUR CODE HERE

[/code]

Hey Francis,

I'm going to jump in here for newbie2 as I am part of the team.

There is a large number of drills being created for this report. We are experiencing increased time to render the report as the amount of drills have increased due to changes in the report. The output formats that we are experiencing this problem with are HTML and Excel.

 -IF '&FOCFOCEXEC.EVAL' EQ 'RCASTER' THEN GOTO :SKIPDRILLS;

TYPE=DATA,COLUMN=DESC,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/pointofsalec/clubaccountc/datatrak_club_accounts_drill.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I  ASOF='&ENDDATE' DRDR='DRDR' DRILL='2'),TARGET=_blank,WHEN=DRILL1 EQ 'Y',$
TYPE=DATA,COLUMN=AMT1,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL21 EQ 'YP',$
TYPE=DATA,COLUMN=AMT1,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL21 EQ 'YN',$
TYPE=DATA,COLUMN=AMT2,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&BOMDATE' ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL22 EQ 'YP',$
TYPE=DATA,COLUMN=AMT2,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&BOMDATE' ENDDT='&ENDDATE' DRILL='2'),TARGET=_blank,WHEN=DRILL22 EQ 'YN',$
TYPE=DATA,COLUMN=AMT1,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL21 EQ 'YP',$
TYPE=DATA,COLUMN=AMT1,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL21 EQ 'YN',$
TYPE=DATA,COLUMN=AMT2,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL22 EQ 'YP',$
TYPE=DATA,COLUMN=AMT2,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'),TARGET=_blank,WHEN=DRILL22 EQ 'YN',$
TYPE=DATA,COLUMN=AMT1,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL23 EQ 'YP',$
TYPE=DATA,COLUMN=AMT1,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL23 EQ 'YN',$
TYPE=DATA,COLUMN=AMT2,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL24 EQ 'YP',$
TYPE=DATA,COLUMN=AMT2,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT2' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='IC TO'),TARGET=_blank,WHEN=DRILL24 EQ 'YN',$

TYPE=DATA,COLUMN=DESC,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_early_deposit.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I  ASOF='&ENDDATE' DRDR='DRDR' CYCLE='DLY' DRILL='2'),TARGET=_blank,WHEN=DRILL7 EQ 'Y',$

TYPE=DATA,COLUMN=AMT3,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT3 EQ 'YP',$
TYPE=DATA,COLUMN=AMT3,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT3 EQ 'YN',$
TYPE=DATA,COLUMN=AMT4,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT4 EQ 'YP',$
TYPE=DATA,COLUMN=AMT4,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT4 EQ 'YN',$

TYPE=DATA,COLUMN=AMT3,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT3 EQ 'YP',$
TYPE=DATA,COLUMN=AMT3,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT3' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT3 EQ 'YN',$
TYPE=DATA,COLUMN=AMT4,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT4 EQ 'YP',$
TYPE=DATA,COLUMN=AMT4,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT4' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT4 EQ 'YN',$

TYPE=DATA,COLUMN=AMT13,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT13 EQ 'YP',$
TYPE=DATA,COLUMN=AMT13,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT13 EQ 'YN',$
TYPE=DATA,COLUMN=AMT14,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT14 EQ 'YP',$
TYPE=DATA,COLUMN=AMT14,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE TO'),TARGET=_blank,WHEN=DRILL15T2AMT14 EQ 'YN',$

TYPE=DATA,COLUMN=AMT13,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT13 EQ 'YP',$
TYPE=DATA,COLUMN=AMT13,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT13' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT13 EQ 'YN',$
TYPE=DATA,COLUMN=AMT14,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT14 EQ 'YP',$
TYPE=DATA,COLUMN=AMT14,COLOR=RED,FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT14' BEGINDT='&BOMDATE' ENDDT='&ENDDATE' ICFLT='DUE FROM'),TARGET=_blank,WHEN=DRILL15T3AMT14 EQ 'YN',$

-SET &AMTCNT = 1;
-REPEAT :LOOP4 WHILE &AMTCNT LE 18;
-SET &DATERNG3 = IF &AMTCNT IN (1,3,5,7,9,11,13,15,17) THEN &ASOF ELSE &DATERNG1;
-SET &BEGINDT3 = IF &AMTCNT IN (1,3,5,7,9,11,13,15,17) THEN &ENDDATE ELSE &BOMDATE;
-SET &RTBORDER = IF &RUNTYPE EQ 'D' AND &AMTCNT IN (1,3,5,7,9,11,13,15,17) THEN LIGHT
-                ELSE IF &RUNTYPE NE 'D' AND &AMTCNT IN (2,4,6,8,10,12,14,16,18) THEN LIGHT ELSE OFF;
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
          FOCEXEC=daily_billing_ccd_pass_thru(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='CC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL3&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pay_type_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4D&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pay_type_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4T&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pft_ctr_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5D&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=rev_pft_ctr_detail(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5T&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=daily_billing_ccd_pass_thru(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='PROC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL6&AMTCNT EQ 'Y',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='CC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL3&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='CC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL3&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4D&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4D&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4T&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL4T&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5D&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5D&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5T&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,STYLE=BOLD,BACKCOLOR=(NONE NONE),BORDER-TOP=MEDIUM,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pft_ctr_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PFTCTR=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE'),
          TARGET=_blank,WHEN=DRILL5T&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='PROC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL6&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/dailyqrhalf7/daily_billing_ccd_pass_thru.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' CCPROC='PROC' DATERNG1='&DATERNG3' DATERNG2='&ASOF' BOMDATE='&BEGINDT3' ENDDATE='&ENDDATE' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL6&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/billingp9wcu/late_fee_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' DATERNG1='&DATERNG3' DATERNG2='&ASOF' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL45&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/billingp9wcu/late_fee_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='D' DATERNG1='&DATERNG3' DATERNG2='&ASOF' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL45&AMTCNT EQ 'YN',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE' ICFLT='TOT REV'),
		  TARGET=_blank,WHEN=DRILL154T&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT&AMTCNT' BEGINDT='&BEGINDT3' ENDDT='&ENDDATE' ICFLT='TOT REV'),
		  TARGET=_blank,WHEN=DRILL154T&AMTCNT EQ 'YN',$
-*

-SET &FS_BEG_DTE = IF &TOYYMD EQ &EOM_FUL_SVC AND &AMTCNT EQ 1 THEN &AGGRMTH | '16' ELSE &AGGRMTH | '01';
-SET &FS_END_DTE = IF &TOYYMD EQ &EOM_FUL_SVC THEN &TOYYMD ELSE &AGGRMTH | '15';
-SET &DATERNG1 = EDIT(&FS_BEG_DTE,'$$$$99/') || EDIT(&FS_BEG_DTE,'$$$$$$99/') || EDIT(&FS_BEG_DTE,'9999');
-SET &DATERNG2 = EDIT(&FS_END_DTE,'$$$$99/') || EDIT(&FS_END_DTE,'$$$$$$99/') || EDIT(&FS_END_DTE,'9999');
-INCLUDE parse_range.fex
-SET &FS_HEADER = &HDRDTE;
-SET &FRDATE = &DRDR_FRDATE;
-SET &TODATE = &DRDR_TODATE;
-SET &HDRDTE = &DRDR_HDRDTE;

TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='EML' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSEML&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='IBC' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSIBC&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='VCE' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSVCE&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='SMS' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSSMS&AMTCNT EQ 'YP',$
-*
TYPE=DATA,COLUMN=AMT&AMTCNT,BORDER-RIGHT=&RTBORDER,COLOR=RED,
          FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountdetai/fs_all_events_detail.fex(REIMDED='D' CLUB_NUMBER_I=CLUB_NUMBER_I WFFMT='&WFFMT' FRYYMD='&FS_BEG_DTE' TOYYMD='&FS_END_DTE' METHOD='LTR' RPT_NUM='12' HDRDTE='&FS_HEADER' TOT_ROW='NO' DBS='DRDR'),
	      TARGET=_blank,WHEN=DRILLFSLTR&AMTCNT EQ 'YP',$
-*

-SET &AMTCNT = &AMTCNT + 1;
-:LOOP4;

TYPE=DATA,COLUMN=DESC,BORDER-RIGHT=LIGHT,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/billingp9wcu/late_fee_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I CYCLE='DLY' REIMDED='R' DATERNG1='&DATERNG1' DATERNG2='&ASOF' DRDR='DRDR' DRILL='2'),
		  TARGET=_blank,WHEN=DRILL46 EQ 'YP',$
-*
TYPE=DATA,COLUMN=C1,BORDER-RIGHT=LIGHT,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/abc_ca_recon_sum.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I CYCLE='DLY' DLYDATE='&DLYDATE'),
		  TARGET=_blank,WHEN=DRILL851T EQ 'YP',$
-*
TYPE=DATA,COLUMN=C1,BORDER-RIGHT=LIGHT,COLOR=RED,
		  FOCEXEC=IBFS:/WFC/Repository/clubrepo/std_reports/accountingsq/abc_ca_recon_sum.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I CYCLE='DLY' DLYDATE='&DLYDATE'),
		  TARGET=_blank,WHEN=DRILL851T EQ 'YN',$
-*
-:SKIPDRILLS; 

Brian & newbie2,

You should probably do some debugging using the "salami" technique: cut out pieces and see what happens and when.
I see within your mounds of drills that there is a loop (18 times).
If you cut out the loop what happens?
Also, within the loop you have "-INCLUDE parse_range.fex" what does that do?
Lastly, you put semi-colons at the end of labels e.g. "-:LOOP4;". I wouldn't do that.

A took a look at the first few lines of the drilldown stylesheet, form column AMT1.

I rearranged the code a little. The conditions for lines 1 and 2 are the same, and the conditions for lines 5 and 6 are the same. The syntax used in these drilldowns does not allow for multiple drilldowns, so only one drilldown per condition will be on the report.

TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YN', TARGET=_blank, FOCEXEC=ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'), COLOR=RED, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YN', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'), COLOR=RED, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL23 EQ 'YN', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'), COLOR=RED, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YP', TARGET=_blank, FOCEXEC=ic_pmts_detail.fex(WFFMT='&WFFMT' CLUBLIST=CLUB_NUMBER_I BEGINDT='&ENDDATE'   ENDDT='&ENDDATE' DRILL='2'), TARGET=_blank, $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YP', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC FROM'), $
TYPE=DATA, COLUMN=AMT1, WHEN=DRILL21 EQ 'YP', TARGET=_blank, FOCEXEC=rev_pay_type_detail.fex(WFFMT='&WFFMT' CLUB_NUMBER_I=CLUB_NUMBER_I PAYTYP=DESC SOURCE='AMT1' BEGINDT='&ENDDATE' ENDDT='&ENDDATE' ICFLT='IC TO'), $

I agree with Danny, I'd say the code needs to be examined carefully.

Daniel and Francis,

Thank you for your responses. I did apply "salami" testing to figure out where and in what instances we would experience the slowness of this report as you suggested.

This report is much like a pivot table in the way it displays the data, but is not built in that way. The data is grouped in to 9 categories which contain 2 columns for each category giving a total of 18 numeric columns total. The categories columns are split between a daily value column and a month-to-date value column. The user running the report has the ability to choose to run the report for "Daily Only", "MTD Only", or "Daily & MTD" together. So when running the report for "Daily Only" or "MTD Only" there is only 9 columns being produced instead of the 18.

I found that the drills section created with a loop was trying to create drills for all 18 columns when the report was run for Daily Only or MTD Only which was only using 9 columns. A simple adjustment of the loop cleared up the speed differences. It would appear that it managed to run even when the loop tried to create the drills for missing columns, but the amount of time for it to complete increased.

I agree Francis, the code here needs to be examined further to see where the amount of drills created could be reduced from single instance drilldowns to multiple. Unfortunately as it is in most work places, the work load is full and has to be prioritized into the to-do list by the business.

Thanks for both of your input.