cancel
Showing results for 
Search instead for 
Did you mean: 

Dispaly "No data" message

Former Member
0 Kudos
49

Hi,

Can anyone let me know how to display " No data" message in crsytal report if no data has been transferred from 'Data base'.

Thank you,

Regards,

Preetham

View Entire Topic
Former Member
0 Kudos

Hi Preetham,

This works on Crystal Reports 2008. The week_id is the main key of the query

if ((OnFirstRecord and OnLastRecord) and IsNull(Count({Command.Week_id})) ) then "No records" else "Records"

Regards

Alan