GROUP/RECORD SELECTION CRITERIA

[CPKB]

I have 3 tables (CUSTOMER,LOCATION,ORDERS). The links are from CUSTOMER to LOCATION (Equal join). LOCATION to ORDERS(Left Outer join). I need to group data in the order
Group 1-CustomerID
Group 2-Location
Group 3-Order
Now, ORDER table has a field called ORDER_DATE(nullable).
I need to print data out in the report so that I get details of all orders for a location, whose ORDER_DATE is = 'a given date'(input parameter field).
The issue is as follows:
1) If I specify the above criteria in the record selection formula, and a customer has no orders with the given date, then details of the entire customer, like customer and location are not printed out(group 1 and group 2), and if no customer has any order with the given date , I get an empty report.
I need to get the details of Group 1 and Group 2 out so that I can indicate the value of zero Group 3 records.

 

[Nuffsaid]

See my response in the formula forum.

Nuffsaid.

 

[IdoMillet]

Change the condition from:

ORDER_DATE is = 'a given date'(input parameter field).

to

IsNull(Order_Date) OR ORDER_DATE is = 'a given date'

Cheers,
- Ido

ixm7@psu.edu