We use MS RMS with 6 HQ users. We have encountered a problem whereby it is not possible for the item movement report to be run more than once at any one time. It appears that the report creates a view in the database which gets dropped and created every time the report runs. This appears to have the effect that only the latest run of the report works. Refreshes of the earlier reports fail. This appears to be true for two reports run in different windows by the same user and also for different users. A further consequence appears to be that if users with different database logins run the report and the view fails to be dropped at the end of their session, other users cannot run the report either - because they dont have rights to drop the report. Has any one else encountered anything like this?
- posted
17 years ago