Yesterday and tomorrows information???

[mheilbut]

I have a report that show me the following:

Product Order_number Shift

Group 1 - Machine 101
7250125 658665 06/06/2002 18:24:20
7522548 256588 ....
Group 1 - Machine 123
8347373 683234 06/06/2002 18:24:20
3837647 398373 ....

I want to somehow be able to put in a parameter which allows me to choose an order_number. I want the report then to print for the chosen order then information for yesterday's shift at the same time, todays shift and tomorrows's shift at the same time.

Something like this: If I chose order 659665:
Product Order_number Shift
Machine 101
7250125 658665 06/06/2002 18:24:20
... 658665 06/07/2002 18:24:20
... 658665 06/08/2002 18:24:20

Is this possible? Please help me out! Thanx! Michel, São Paulo, Brazil

 

[synapsevampire]

Try creating a parameter to enter the shift.

Then place something like this in the record selection criteria:

{MyTable.MyOrder} = {?Order}
and
({Mytable.MyDate} >= currentdate-1
and
{Mytable.MyDate} <= currentdate+1)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com