?
Solved

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

Posted on 2003-03-18
6
Medium Priority
?
533 Views
Last Modified: 2008-02-01
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  

0
Comment
Question by:ssan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 100 total points
ID: 8158521
Yes the problem is due to the NULL.  NULL values cause numerous headaches for CR.  They tend to match everything.

Can you build the filter in the database with a stored procedure?


Does data exist for EventDate = 2003/02/27 ?  So far you have only shown that data exists for 2002-12-25

What do you get for
(({tempMonthlyProduction.PROD_DATE} = DateTime (2003, 02, 27, 00, 00, 00))) OR (({tempMonthlyProduction.EventDate} = DateTime (2003, 02, 27, 00, 00, 00)))


Where are you using the formula?

mlmcc
0
 

Expert Comment

by:sscrystal
ID: 8158997
I am using the formula in Record Selection Formula Editor
0
 

Expert Comment

by:sscrystal
ID: 8159144
THANKS I SOLVED THE PROBLEM >>>> I FILTERED THE NULL VALUES
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 8161107
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question