i have a ms access database with a table called daily . This table has 2 date column declared as string data type, now i have created a crystal report , now on reports-> select expert -> i have chosen the field name daily.indate and the value as parameter it works fine
But i have to select two columns daily.indate and daily.outdate . These two column is declared as string datatype hence i am using "starts with" function on crystal report so i can get the data show on reports.
This is the formula i use to do this.
{daily.indate} startswith {?date}
now if i use {daily.indate} startswith {?date} and {daily.indate} startswith {?odate}
i get error, i am not able to figure out what the formula is,
i am using crystal report version 10. professional edition . (stand alone not from visual studio).
Edit!!
Thanks all of you! now i got the error resolved
i used {daily.indate} startswith {?date} or {daily.outdate} startswith {?date}
now report is showing the data as i required,
startswith
instead of checking equality. – mechanical_meat