Good morning!

People I'm learning to use the tool of Crystal and I m facing with some doubts.

Come on ..

I have a report as well

Cod. Drive -------consumer product --- ----- --- Balance

Grade 1
Type: 9
Class: 65
Sub-Class: 23

9999 - Olive ----- 1 --- 10 ---   23
9456-Maçã  ----- 1 --- 23 --- 0


I was wondering how do I not aparec the line containing the product with the balance equal to ZERO.


I hope you understand.

Thank you.!

Does this suppress using a formula work just for the textbox containing the data or can it be applied to the label that is also associated with it so the line that the label and data item would just be 'skipped' when there is no value or that value is zero?

I've got a standard (boiler plate) report header that I want to create, but there are some pieces of data (right now usually on their own line of the report) that I not only want suppressed, but I also want that line ignored and the next line of the report to print where this line would have been.  Sort of like the address1 and address2 then city,state, zip lines on a label - you don't want to see a blank line if address2 is 'empty', you'd like to have the city, state zip info print right below the address1 information.

Thanks in advance.

Todd

Thanks, I'll look at that.  Appreciate the quick reply!

Todd

correction formula is as follows:
if Sum ({@ConsumoMedio}, {AGR_DEM_MOV_ITENS_V.ID_PRODUTO}) = 0 then true

and
  balance if {@Saldo} = 0 then true

But who are the products keep coming up with a negative balance.

I like putting the formula is showing the following message:

Sum ({@ConsumoMedio}, {AGR_DEM_MOV_ITENS_V.ID_PRODUTO}) and {@Saldo} <= 0  then true

"Remaining the text does not Appear to be part of the formula"

And so the formula:

Sum ({@ConsumoMedio}, {AGR_DEM_MOV_ITENS_V.ID_PRODUTO}) and {@Saldo} <= 0  then true
 
  the message that appears is:
  "a boolean is required here"