I am displaying a field for which there are 3 values and these value are constant all the time. Now I need to put a DRILLMENUITEM on this field and the drilldowns vary for all the 3 field values. I was wondering if there is a way to put the DRILLMENUITEM based on a condition.

It is something like below.

ST COUNTRY ZIP
MN USA 55420
MI USA 48331
MO USA 64101

If I click on MN or MI or MO (I only see these 3 states all the time) it should popup with DRILLMENUITEM but each DRILLMENU has different links.

I have tried this in TECH Library or in the forum but couldn't find any similar topic.

Thanks in advance.

Reddy.

This message has been edited. Last edited by: dreddy_23,

You can use
WHEN=condition,
[for example: WHEN = ST EQ 'MN',]

(insert it before the first DRILLMENUITEM)
to limit the report objects that the list of drilldown items will apply to.

That allows you to define several drilldown menus for a column, and control which menu applies to each instance.

Thanks J. Just figured that out. I was actually giving the WHEN for each DRILLMENU.

Reddy.