total record count 1

[JeffSabat]

this is what i want to do. I created a text wherein it will display when there are no records found so i created a formula in the suppress object button.
my problem is what would be the formula. I've tried the formula 'recordnumber=0' yet the text still displays even if there are records found. obviously the formula is wrong. Pls help me what should the formula be... tnx

 

[vidru]

Use a data field that would always have a value if records were actually returned (would never be NULL), and test to see if it's NULL:

IsNull({Table.Field})

-dave

 

[JeffSabat]

tnx Dave..
a star 4 u...