T-SQL Statement to Add Report to Screen File

Here is the code that will add a report into the Screen Table in your system files.

You will need to change the information in the VALUES statement to your information.

I ran this in the Query Analyser for SQL Server 2000, and it ran fine. Just remember to select your Dynamics System Database from the drop down box on the menu bar.



INSERT INTO Screen(Module, Name, Number, ScreenType)
VALUES('PA', 'Equipment Rates', 'PA997', 'R')