something interesting guys. I've a small software developed in visual foxpro 8 and using crystal 8.5 for reporting. there are majorly 3 reports in the project. Everything works fine when i'm running it on the development PC. I've prepared installation using Installshield Developer. Now when i install the report on client system. one reports shows proper datas and other 2 show everthing as blank. I'm passing recordselectionformula from VFP.
eg. ( {file.date} in datetime(2004,1,1,0,0,0) to datetime(2004,12,31,0,0,0) ) ) and ( (file.frgkey}=10 or {file.frgkey} = 11 )
one thing i could notice is that the formula works ok when i have only the date part ( {file.date} in datetime(2004,1,1,0,0,0) to datetime(2004,12,31,0,0,0) and the time i put the {file.frgkey} the report goes blank. But on the same data, same ODBC it works fine on machine which has VFP8 and crstal 8.5 installed. what could be this all about??????
looking for your help guys. i'm stuck up with this quite long enough.
regards,
svu
eg. ( {file.date} in datetime(2004,1,1,0,0,0) to datetime(2004,12,31,0,0,0) ) ) and ( (file.frgkey}=10 or {file.frgkey} = 11 )
one thing i could notice is that the formula works ok when i have only the date part ( {file.date} in datetime(2004,1,1,0,0,0) to datetime(2004,12,31,0,0,0) and the time i put the {file.frgkey} the report goes blank. But on the same data, same ODBC it works fine on machine which has VFP8 and crstal 8.5 installed. what could be this all about??????
looking for your help guys. i'm stuck up with this quite long enough.
regards,
svu