web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Report Control - DSL2011SP2

(0) ShareShare
ReportReport
Posted on by

Hi 

Wondering why RPTControl Table would have data that doesn't show in Report Control Maintenance. These are all custom reports that were added at some point or another. Long story short we upgraded one system to DSL2011SP2, then added in all the custom reports. I copied the newly updated Rptcontrol table to the new server. However, reports aren't in the Report Control maintenance screen. I ran DB maintenance (sync views, ownership/security) to no avail.

What am I missing?

Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    be nice if we could delete our questions and start again. A bit of an oversight (report names don't match the report number)...So I'm going to retract the above.  They actually show in both places - however when I try to run the report system message 9804 pop ups (unable to locate report file xxxx.rpt for selected report format. All of these reports are in the usr_report directory.

  • Kevin Graham Profile Picture
    2 on at

    Hi there, 

    Did you resolve the 9804 error message?

  • HolliV Profile Picture
    235 on at

    Did you ever resolve this issue?

  • CFROTON Profile Picture
    4,710 on at

    9804 indicates that SL cannot find the report.  Please make sure the usr_rpts folder is directly underneath the SL /Applications, that there are no spaces, etc, and that the folder is located on the main SL server and any other TS servers or full installs.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans