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

Comments

  • edited 6:55PM
    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
  • edited 6:55PM
    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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.