I use Crystal Reports 10, I am trying to link two tables, one is an SQL table and the other is an AS/400 table. I can only link on the date field, which will work for what I need. My problem is the SQL date field is a Date stamp, the AS/400 field is a Date-Time stamp. Will these link together?
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linking on Date Fields
- Thread starter Maker1
- Start date
synapsevampire
Programmer
A common solution is to LINK (not import) these atbles into an MS Access database and create a query for the Crystal Report.
It's faster and more flexible than Crystal.
-k
It's faster and more flexible than Crystal.
-k
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question
- Locked
- Question