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!
connecting 2 databases....
- Thread starter 3dthies
- Start date
synapsevampire
Programmer
Change the numeric to a date.
If you need specific answers, post specifics, such as Crystal version, database version and connectivity type.
If possible, use a View or SP to CAST/CONVERT the date.
-k
If you need specific answers, post specifics, such as Crystal version, database version and connectivity type.
If possible, use a View or SP to CAST/CONVERT the date.
-k
If you don't have the option of creating a view or SP for whatever reason, I think you could also bring in the second database in a subreport, and create a formula within the subreport that converts the numeric date field to a date and then link the subreport to the first database on this formula. Of course, this would slow the report and make it more difficult to work with data between the tables, since you'd have to use shared variables for calculations, etc.
-LB
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question