asked on

Crystal report ----Record Selection Formula (DATE)----HELP ---URGENT

The Formula what i had written is

(({tempMonthlyProduction.PROD_DATE} = DateTime (2003, 02, 27, 00, 00, 00))) OR (({tempMonthlyProduction.EventDate} = DateTime (2003, 02, 27, 00, 00, 00)))

With this it only shows the result with PROD_DATE = 2003/02/27 and does not show the results where EventDate = 2003/02/27 ....IS THERE ANY THING WRONG !!!

Result i get ---

15469 2002-12-25 00:00:00.000 NULL
15469 2002-12-25 00:00:00.000 NULL
15469 2002-12-25 00:00:00.000 NULL

WHAT I WANT : I WOULD LIKE TO GET ALL THE RECORDS WHERE
PROD_DATE = 2003/02/27 or EventDate = 2003/02/27 .

If i use sql like
Select SHOP_ORDER_NR ,PROD_DATE , EventDate from tempMonthlyProduction_WIP where EventDate = '2002-12-25 00:00:00.000' or PROD_DATE = '2002-12-25 0:00:00.000'
I get following results

15469 NULL 2002-12-25 00:00:00.000
15469 NULL 2002-12-25 00:00:00.000
15469 NULL 2002-12-25 00:00:00.000
15469 2002-12-25 00:00:00.000 NULL
15469 2002-12-25 00:00:00.000 NULL
15469 2002-12-25 00:00:00.000 NULL

IS the problem due to null

IS THERE ANY OTHER WAY OF WRITING THE FORMULA ....

PLEASE HELP

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sscrystal

I am using the formula in Record Selection Formula Editor

sscrystal

THANKS I SOLVED THE PROBLEM >>>> I FILTERED THE NULL VALUES

Mike McCracken

If you feel my suggestion to build a filter through a database stored procedure was any help in providing an answer, lease accept it.

mlmcc