data selection based on condition

[Former Member]

Hi all,

In my report(shipped but not invoiced) i want to bring data based on the status.

for e.g  i have a shipment which is invoiced.

Actual shipment status : shipped

invoice status : invoiced

pack id  : 556564

shipment date: 03/08/2015

invoice date : 17/08/2015

my parameter is shipment date.

for e.g when i give the parameter 15/08/2015 my report should not bring this record.  i need to writed logic so that system should bring all the packid's which are not invoiced as on date(shipped date).

[former_member292966]

Hi,

Here's the formula I came up with based on the information you gave: 

{table.ShipmentDate} = Date (2015-08-15)

And {table.ShipmentStatus} = "shipped"

And {table.InvoiceStatus} <> "invoiced";

This should return all shipments for the date that have no invoices. 

Hope this helps,

Brian