Exists in FR equivalent a PrintBand en QR?

rogerruiz

Hi

I need no print any records by one condition, in QR are:

PrintBand:=not (tblClientsSales.AsCurrency=0 And tblDetailSales.AsCurrency=0);

tblClients and tblDetails are diferents tables.

I used in FR in OnBeforePrint event

if ([tblClients."Sales"]=0) And ([tblDetail."Sales"]=0) then
MasterData1.Visible:=false
else
MasterData1.Visible:=true;

And not work, always print band.

I used "Enabled" too and not work

Any solution?
thanks and excuseme my bad english.

Roger
Best regards

sandy

Hi Roger,

Maybe, it still shown because you only validating for value is 0, how about if the field is Null?? It won't be validated right??

Why don't use WHERE [Validation] in the IBXQuery, it will be give you more guarantee that the record won't saw.

Correct me if i'm wrong

Thanks,
sandy

rogerruiz

Hi Sandy

Thanks for you response, you are in the correct. I need other solution for
more complex condition. I used in my message a simple example for explain my problem.

Roger
Best regards.