Originally posted by DBlank
Use whatever your data manipulation process is for that in the select expert.
Hi Dblank...When I select 'Deleted' value from Deleted prompt
& select all from program child prompt
& select specific rotation, it fails to display the resultset in the report..
It is working fine upto 2 level hierarchy...but it fails to display the right data when I select a specific value from the rotation subchild dropdown...
I have used this formula
{?Deletion}=' *All' or {?Deletion} = {Command.DELETION_STATUS})
and
{?program}=' *All' or {?program}={Command.PROGRAMTITLE}
and
{?Rotation}=' *All' or {?Rotation}={Command.ROTATIONTITLE}