data selection based on condition
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).