How do I modify several report destinations in DRM following a recent migration?
To mass-modify all the report destinations in DRM, we recommend using an experienced SQL person to update the DRM tables in the back-end with an UPDATE statement. If there are only a few reports, updating the destination manually is an alternative route. The DRM tables can be located using the Tables Resources available in GP. This is under Tools >> Resource Descriptions >> Tables. The DRM table holding the Reports is in the DYNAMICS database and is called DRM101. The Destinations related to these reports are in the DRM104 table. The field in the DRM104 table to update would be the DRM_PDF_Filename field. An update statement would look something like this: USE DYNAMICS UPDATE DRM104 SET DRM_PDF_Filename = ‘new stuff’ WHERE etc. etc. etc.
