Hi I would like to create prompt with LOV’s including N/A.When user selects N/A it has to show No data to fetch window from report.Basically it has to return no rows form database.Please let me know if somebody knows this.
m_vontikommu (BOB member since 2006-01-25)
What a weird question ? You want it to be possible for someone to run a report in which he says I don’t want data ??? What’s the use of this ?
But, yes, it can be done. Just add this text ‘N/A’ to the LOV list and as long as it’s not a real value nothing will be returned…
(how to add: https://bobj-board.org/t/15227/9)
Regards,
Gerard
highandstoned 
(BOB member since 2005-08-01)