I am using the DRILLMENUITEM command for my drill downs. I am not using a DEFMACRO. I have a report that lists my clients. That report drills down to a summary report that has the drill menu in it. Sometimes the drill menu displays and other times it does not. Any idea of what could stop it from displaying? I also made sure that both report are displays the exact same values on the report.

Below is a view of the code via source when it does work.

TYPE=DATA,
COLUMN=N3,
TARGET='_blank',
DRILLMENUITEM = 'Ancillary Detail to User Screen',
FOCEXEC=/WFC/Repository/QBR/Dashboard/DB_AncPPDDrilldown.fex(\
CORPID=' 46113' \
HOSPID='_FOC_NULL' \
LABELNAME = N3 \
FROM_DATE=' 20160930' \
BUSINESS_MODEL='FeeForService' \
TIMESTAMP='2016/09/15 14:31:04 ' \
REPORT_TYPE='AHTML' \
),
DRILLMENUITEM = 'Ancillary Detail to Excel',
FOCEXEC=/WFC/Repository/QBR/Dashboard/DB_AncPPDDrilldown.fex(\
CORPID=' 46113' \
HOSPID='_FOC_NULL' \
LABELNAME = N3 \
FROM_DATE=' 20160930' \
BUSINESS_MODEL='FeeForService' \
TIMESTAMP='2016/09/15 14:31:04 ' \
REPORT_TYPE='EXL07' \
),
DRILLMENUITEM = 'Ancillary Detail to PDF',
FOCEXEC=/WFC/Repository/QBR/Dashboard/DB_AncPPDDrilldown.fex(\
CORPID=' 46113' \
HOSPID='_FOC_NULL' \
LABELNAME = N3 \
FROM_DATE=' 20160930' \
BUSINESS_MODEL='FeeForService' \
TIMESTAMP='2016/09/15 14:31:04 ' \
REPORT_TYPE='PDF' \
),
$

Below is a view of the code via source when it does not work.

TYPE=DATA,
COLUMN=N3,
TARGET='_blank',
DRILLMENUITEM = 'Ancillary Detail to User Screen',
FOCEXEC=/WFC/Repository/QBR/Dashboard/DB_AncPPDDrilldown.fex(\
CORPID='_FOC_NULL' \
HOSPID='_FOC_NULL' \
LABELNAME = N3 \
FROM_DATE=' 20160930' \
BUSINESS_MODEL='FeeForService' \
TIMESTAMP='2016/09/15 14:32:32 ' \
REPORT_TYPE='AHTML' \
),
DRILLMENUITEM = 'Ancillary Detail to Excel',
FOCEXEC=/WFC/Repository/QBR/Dashboard/DB_AncPPDDrilldown.fex(\
CORPID='_FOC_NULL' \
HOSPID='_FOC_NULL' \
LABELNAME = N3 \
FROM_DATE=' 20160930' \
BUSINESS_MODEL='FeeForService' \
TIMESTAMP='2016/09/15 14:32:32 ' \
REPORT_TYPE='EXL07' \
),
DRILLMENUITEM = 'Ancillary Detail to PDF',
FOCEXEC=/WFC/Repository/QBR/Dashboard/DB_AncPPDDrilldown.fex(\
CORPID='_FOC_NULL' \
HOSPID='_FOC_NULL' \
LABELNAME = N3 \
FROM_DATE=' 20160930' \
BUSINESS_MODEL='FeeForService' \
TIMESTAMP='2016/09/15 14:32:32 ' \
REPORT_TYPE='PDF' \
),
$

This message has been edited. Last edited by: Jay Potter,

The only thing that I see is that when it does work you have

CORPID=' 46113'

and when it doesn't

CORPID='_FOC_NULL'

Is this the normal behavior ?

Jay,
Could you try creating a REPRO with one of the IBI sample files? CAR or GGSALES?

Thanks for the replies. I found the problem. It was me.