Report Filter ?

RKM

I have created a report from the items table. The report can be searched upon 1 field the [No.] field. When I enter a item number say 100000 it gets the correct data. If i dont enter a item number in this field and click preview it gets all the data how can i stop this. Are there different ways to prevent this if so can some explain them to me.

Thanks alot for your time and assistance

RKM

Soft_Tod

Try in the PreDataItem Section:

IF NOT HASFILTER() THEN
   CURRREPORT.BREAK();

or
IF (GETFILTER("No.") = '') THEN
   CURRREPORT.BREAK();

RKM

Thank you very much sir worked like a treat

RKM