I am creating a report using Crystal Reports XI that accesses a Foxpro database. I need to use a date parameter so that the report will work in a .net application that will pass in a date parameter.
I guess there is a known issue using Crystal Reports and Foxpro with date record selection. (See this article:
http://www.hexcentral.com/articles/crystal-date-error.htm ) Crystal tries to send a CONVERT expression that is valid with SQL Server, but not with Foxpro. The workaround in the article is to use a SQL Expression, but you can't use parameters in an expression.
If I could convert the date parameter into a string like "9/5/2012" than I could probably use a Foxpro function to do something like {DateField} = CTOD("9/5/2012"). But I cannot figure out how to convert the date parameter into a string in the record selection formula.
I have also tried to create a Command Query but that seems even more limited with what you can do with parameters.
Thanks