You’re offline. This is a read only version of the page.
After installing updates to Dynamics SL 2011 we have experienced a situation where we are not able to access custom reports through the ROI. Thru necessity or ignorance we end up resetting the RPTCONTROL table (and maybe another table) back to default. Once it is restored everything is fine again, but should this be a part of a feature pack install process? Or are we doing something in error. Our reseller and Microsoft have both apparently indicated this is expected behavior, but I have a hard time believing that.
Thanks,
Alan
*This post is locked for comments
Hi
During Database Maintenance update the RptControl and Pvrec tables under the Solomon system database will be get overridden with standard values. This will impact your custom reports and pvrec execution. To avoid this we need to take a backup of both tables before Database maintenance update and restore it after the upgrade process.
Hope this helps
Thanks
Your reseller is correct if the report control customizations are to standard SL report controls. The database update (under database maintenance) process clears out the report control table for all standard SL modules and when you run the database update process under Administration to put in the standard report controls you are at the level of report controls that are standard with the version of SL you just installed.
What you did will bring back your customized report controls but will also lose and changes to report controls that came with the new SL update. Sometimes that can even cause a report to fail under the new release because the new release may have changed where it pulled something like the current posting period so your approach may result is some ROI errors when you attempt to launch a report. This is not a high probability but you need to be aware of it.
Before I do any SL update I always use SQL to copy the rptcontrol table to another table name in the system database so that I still have my customized report controls. I can then cut and paste in (from the alternate rptcontrol table) the custom report control changes that were made. Not exactly an easy task but better than losing customized controls.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (