0

Field Matching

Jet Reports Historic Posts

August 09, 2011 07:50

None

Follow

Hi Guys,

I want to create a jet report on item table in which i want to match 2 fields and then display the data.

i.e. Unit price < Unit Cost

Both these fields Unit price and Unit Cost are in the item table. I want to get the items where the unit price is less then the unit cost.

I am using the CSide local database.

Thanks.

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts August 09, 2011 15:29

  Hello,
  You can add both the fields in your list (on hidden columns) and then hide the rows that match your condition (UnitPrice < UnitCost).
  
  Elena

• 0
  
  Jet Reports Historic Posts August 09, 2011 15:54

  Hi!
  
  I think you can also do this with a calculated filter field like this:
  
  =NL("Rows","Item",,"Unit Price","=""<""&NF(,""Unit Cost"")")
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 10, 2011 09:20

  Hello,
  You can add both the fields in your list (on hidden columns) and then hide the rows that match your condition (UnitPrice < UnitCost).
  
  Elena

  
  How do hide the rows based on the condition can you give me the example for this please.
• 0
  
  Jet Reports Historic Posts August 10, 2011 14:55

  Well, let's say you have like this:
  
  E4 = UnitPrice
  F4 = UnitCost
  
  You have to add:
  
  B1 = Hide+?
  B4 = IF(E4>F4;"Hide";"Show")
  
  That's it. This will only show the rows where UnitPrice < UnitCost.
  You should also try Hughes's idea - see what fits you best.
  
  Elena