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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.