Hi,

I have an report where drill down feature needs to provided in the column TITLE.

TYPE = TITLE, COLUMN=N4, FOCEXEC = DRILLFEX(variable), $

In the above drill down i need to pass the column title value (eg. assume COUNTRY as the column title) to another fex file.

If anyone have idea on this, please suggest.

Thanks

Aravindbaalaaji,

If you read the style manual dealing with drill downs etc. you would realise that you specify the column -

TYPE=TITLE, COLUMN=N4, FOCEXEC=[fextorun](variable=N4), $

Remember to Read The FOCUS Manual!

T

Sometimes it's a good idea just to try something even though you may not be sure of how to do it. Setting the ECHO to ON or ALL should give you the info you need. The worst that can happen is that it doesn't work and gives an error. If it does work, then you're on your way. In this case trying the standard solution before posting the question would have solved the problem right away. And if ALL ELSE FAILS (or even before that ) there's always the manuals as Tony suggests.

Aravindbaalaaji, are you wanting to pass the field name to the drilldown, or a value.

If you use

 TYPE=TITLE, COLUMN=N4, FOCEXEC=[fextorun](variable=N4), $ 

you will get the first value in that column.

If you want to pass the field name then use

 TYPE=TITLE, COLUMN=COUNTRY, FOCEXEC=[fextorun](variable='COUNTRY'), $ 

.

As far as I am aware, you have to specify the field as a literal, i.e. in quotes.