I pass 12 parameters to CR using ASP. 4 of them (username, company name ...) are used directly to display on the report, the rest (including StartDate and EndDate -- as strings) is then passed to stored procedure of MSSQL 7.0. StartDate and EndDate are also used to display directly on the report without using any formula or any means of formating.<br>
When I created the report, I used StartDate , for example, = "June 1, 1999', EndDate = "June 2, 1999". In the original version of CR7, the report works fine. For instance, I use ASP to pass StartDate="Mar 1, 2000" and EndDate="Mar 2, 2000", they are displayed correctly on the report both in the browser and the CR designer. (I have two server, one with original version and one with maintenace release 1 of CR7). In the CR7 with MR1 or CR8, however, only data returned from stored procedure is correct (display data from Mar 1 to Mar 2), but all the parameters I use directly to display are incorrect (as the above example, CR displays StartDate as "June 1, 1999", EndDate as "June 2, 1999" ... )<br>
<br>
Anyone has any ideas to fix this bug? BTW, the only way I can fix it is deleting completely the report then re-create it. Modifying does not help. I try to modify by deleting all except StartDate, but does not work. I am sure that parameters are passed correctly because the returned data is correct.<br>
<br>
CR tech told me that the bug was fixed in CR8, and asked me to change Crystal.CRPE.Application to CrystalRuntime.Application (because CR8 does not use Crystal.CRPE.Application) and some small modifications, but then the application does not run anymore (cannot find the server -- timeout). --- After I change the object component, there is an error like 'object does not provide this property Session().options. If I comment out that line, I have time out error. Just like I am in a maze with no ends.<br>
<br>
Oh, to make sure that the parameters are passed correctly, I also did this test. I use the same ASP files but with new report created in Cr7 with MR1. It works perfectly.<br>
<br>
<br>
Anyone has any ideas please help me. I don't want to re-create 170 reports again.<br>
When I created the report, I used StartDate , for example, = "June 1, 1999', EndDate = "June 2, 1999". In the original version of CR7, the report works fine. For instance, I use ASP to pass StartDate="Mar 1, 2000" and EndDate="Mar 2, 2000", they are displayed correctly on the report both in the browser and the CR designer. (I have two server, one with original version and one with maintenace release 1 of CR7). In the CR7 with MR1 or CR8, however, only data returned from stored procedure is correct (display data from Mar 1 to Mar 2), but all the parameters I use directly to display are incorrect (as the above example, CR displays StartDate as "June 1, 1999", EndDate as "June 2, 1999" ... )<br>
<br>
Anyone has any ideas to fix this bug? BTW, the only way I can fix it is deleting completely the report then re-create it. Modifying does not help. I try to modify by deleting all except StartDate, but does not work. I am sure that parameters are passed correctly because the returned data is correct.<br>
<br>
CR tech told me that the bug was fixed in CR8, and asked me to change Crystal.CRPE.Application to CrystalRuntime.Application (because CR8 does not use Crystal.CRPE.Application) and some small modifications, but then the application does not run anymore (cannot find the server -- timeout). --- After I change the object component, there is an error like 'object does not provide this property Session().options. If I comment out that line, I have time out error. Just like I am in a maze with no ends.<br>
<br>
Oh, to make sure that the parameters are passed correctly, I also did this test. I use the same ASP files but with new report created in Cr7 with MR1. It works perfectly.<br>
<br>
<br>
Anyone has any ideas please help me. I don't want to re-create 170 reports again.<br>