How to display a custom message in the report when no data is fetched from query?
pawan8785 (BOB member since 2008-09-09)
USe the below function with if…else to show custom message.
=if(NumberOfRows([Query 1])=0;“No data returned”;“data returned”)
Please let me know if it helps…
Satyaa 
(BOB member since 2008-04-02)
check these links:
https://bobj-board.org/t/15226/19
https://bobj-board.org/t/72584
ajitha (BOB member since 2008-07-28)