How do you view records that have an effective and termination date but are still active. What I mean is we want to see all current records. So in Oracle all we have to do is say termination_date is null, but this does not work in Crystal Reports because of data type issues it seems.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Effective and expiry dates
- Thread starter dplaya66
- Start date
synapsevampire
Programmer
This is Crystal version dependent, which is the minimum information you should supply when requesting technical information.
If isnull() is not working, then you may have turned on the Convert null values to default in report options, or you didn't try it in the right place:
Report->Edit Selection Formula->Record
-k
If isnull() is not working, then you may have turned on the Convert null values to default in report options, or you didn't try it in the right place:
Report->Edit Selection Formula->Record
-k
synapsevampire
Programmer
Sorry, I should also have stated that if you believe it to be a date type issue, why not state the data type that you're using?
Also if you're using Oracle's ODBC driver instead of the Crystal supplied driver, this may cause problems.
Perhaps you can get a technical person there to help you learn the following and post it:
Crystal version
Database version
Connectivity used
Example data (field type)
Expected output
-k
Also if you're using Oracle's ODBC driver instead of the Crystal supplied driver, this may cause problems.
Perhaps you can get a technical person there to help you learn the following and post it:
Crystal version
Database version
Connectivity used
Example data (field type)
Expected output
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question