Exists in FR equivalent a PrintBand en QR?
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
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
Comments
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
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.