Search results for query: *

presumably you want to do this when users view on demand in CE? If so then the parameter form that appears is part of the crystalreportviewer object and I'm not sure how much of it you can change. Be interested to hear from others on this. If you want to change it for scheduling then you could...

could you do this with a few bits of SQL within your DTS (rather than the conventional transformation mechanism)? 1. insert into tableB values (Select * from tableA where empid < (select max(empID from tableA))) 2. delete from tableA where empid < (select max(empID from tableA)) or does the...

Yes RAS and Pageserver have separate settings. You can increase or even switch off the maxDBResultRecords setting, but I have found that the view on demand fails sometimes with rowsets that are larger than the default setting (e.g. just 40000 rows). Has anyone else experienced this?

I am not a vb programmer but I do want to achive the setting up of a reminder for tasks - I do not need this to be done automatically for now. It sounds like you have achieved this in some way - are you willing to share the code that you created? I understand if you are not. many thanks

well I am running it with no problems so far on both a server and a laptop (for testing). However it is early days...