I have created Dynamic Cascaded prompt display in the Business view Manager.
FOr example:
Deleted is the Top prompt (values --> *ALL/Deleted/Not deleted)
Program is its child prompt
Rotation is its sub-Child prompt to program
Based on my selection *ALL or Deleted or Not-Deleted, it would populated the LOV’s in my report.
Now , how can I write a formula in record selection box in crystal report, such that when I select appropriate LOV’s it would display the corresponding data?
I used this formula, but it is not correct exactly… Can anyone help me out?
If {?Program} = ’ *ALL’ then true
else if {?Rotation} = ’ *ALL’ then true
else if {?Deletion} = ’ *ALL’ then
{Command.PROGRAMTITLE} = {?Program}
else ( {Command.PROGRAMTITLE} = {?Program}
and {Command.ROTATIONTITLE} = {?Rotation} )
rollings007 
(BOB member since 2007-02-15)