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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking in Crystal

Status
Not open for further replies.

wanzek1

Technical User
Jun 13, 2012
79
US
Is there a way to link 2 DateTime values in Crystal without looking at the time value?

Example:

Table 1: 7/8/2013 7:00 am
Table 2: 7/8/2013 12:00 am

I would like the link to only look at the date.

Thanks!
 

You may want to try creating a couple of views in the database (or another database that can reference your source database).

select
cast(YourDateField as date) as MyDateOnly,
*
from Table1

Then use the views in place of the tables, and link on the newly created fields.

You could do the same thing with command objects if creating the views is not an option. The advantage of views is that they would be reusable for future reports that have the same need.

Sometimes views can be performance killers, but I don't think this would be one of those cases.

 
From everything I am finding you can't write a View in Sql with only the Date.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top