I know there has been previous discussion concerning specifying the output type from a drilldown report. It looks like most of the proposed solutions would have you rerun the current report with a new output format. In our self service app we currently do that exact thing. Run a report; drill down to the detail your looking for; click a link that reruns the report to another format(i.e. pdf, excel, etc.).

What I would prefer to do is have the ability to change the desired output as part of drilling down from the report. I would incorporate the onClick event for the link to modify the link to include a variable to specify the output.

While webfocus allows you to specify a drilldown path or specify a javascript function to execute when the link is clicked, it doesn't appear to allow you to specify any code related to an event. I'm I correct on that or have I missed something in the documentation?

If anybody has an alternative idea I would appreciate your input. Thanks.

I can think of multiple ways of doing this. The first one that comes to mind is to have all the reports drill to a common report that returns a dynamic FORM with the output type as a selection. Everything in that form, other then output type, should be dynamic and of type hidden (including the report to execute). This way, you can be looking at any format type, click a drill down, and select any format type for the next report.

Just a thought.

I may not be following your message. My understanding is that when you click on the drilldown link all that you are passing back to webfocus will be the information in the link. If you have other variables set as input types on a form they would not be passed. You would need to do a submit, but then nothing in the link would be passed only the variables on the form. If the event onClick was available as part of the definition of the link you could basically take the this.href reference and add the value of the desired output type as indicated by a control on the form.

Maybe that could be an enhancement?

Why not use multi drilldowns, assuming of course that your report is in HTML.

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=COUNTRY,
DRILLMENUITEM='HTML',
FOCEXEC=newfex(COUNTRY = COUNTRY \
OUTPUT = 'HTML'),
DRILLMENUITEM='PDF',
FOCEXEC=newfex(COUNTRY = COUNTRY \
OUTPUT = 'PDF'),
DRILLMENUITEM='EXL2K',
FOCEXEC=newfex(COUNTRY = COUNTRY \
OUTPUT = 'EXL2K'),$
ENDSTYLE
END

This will allow you to execute newfex.fex using the output format specified. newfex.fex could then contain:

-IF &OUTPUT EQ 'HTML' THEN GOTO SKIPTHIS ;
ON TABLE PCHOLD FORMAT &OUTPUT
-:SKIPTHIS

Very simplistic, but it does accomplish what you were looking for.

Ken

That is an interesting approach. Thanks.