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!
-
datatime selection formula
surely rewrites Crystal SQL in this case: http://support.businessobjects.com/library/kbase/articles/c2015619.asp And I do not need to covert date to char. It was just a workaround to prevent CR from rewriting SQL. And this workaround is not available in CR 10. That is my problem.- martaB
- Post #5
- Forum: Business Objects: Crystal Reports 2 Data Access
-
datatime selection formula
Using auf Command is not possible because we use native Sybase-Server Driver and in this case it is not supported by CR (this option not exist under connection). "we used global convertion of datatime to character" - I meant that we used an CR8.5 Reportoption "convert datatime to". This option...- martaB
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
datatime selection formula
In CR8.5 we used global conversion of datatime to character to prevent CR to rewrite Where-clause. In CR10 it is not more possible and we have the problem that the query using Table.Date_From => 'YYYY.MM.YY' and Table.Date_From < 'YYYY.MM.YY+1' is extremaly slow. How can I convibe CR to...- martaB
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 2 Data Access
