Versions Compared

Version Old Version 2 New Version 3
Changes made by

Documentation Reviewer

Documentation Reviewer

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

See Import the MobileTech Woodford Project.

Step 7: Deploy Any Updated SSRS Reports

The Readme will indicate if any SSRS Reports are included in the download file that need to be updated with the upgrade. Copy this .rdl file and place in the appropriate product folder found in the Microsoft Dynamics GP install directory\Signature\SRS Reports folder.

To deploy SSRS Reports:

To start the Signature SQL Reporting Wizard, navigate to your Microsoft Dynamics GP install directory, then open the Signature\SRS Reports folder and launch the file Signature.Dynamics.GP.BusinessIntelligence.SRSDeployment.exe.

You can also run this wizard from the following locations within Microsoft Dynamics GP:

  • From Service Management, choose Run Wizard in the Service Options window.
  • From Job Cost, choose Run Wizard in the Job Cost Setup Options window.
  • From Equipment Management, choose SRS Wizard in the System Setup window.
  1. On the Welcome screen, choose Next >.
  2. Enter the Microsoft Dynamics GP Server name and instance. For example, if the server name is Fred and the instance Fred1, you would enter Fred\Fred1.
  3. Enter your server User Name and Password, then choose Next >.
  4. Select the company database for which to enable reports, for example, TWO. You must run the wizard multiple times if you wish to deploy SRS reports for multiple companies.
  5. Enter the Report server URL. This is the location of the reporting server site that hosts the web service. You specified this location when you installed SQL Server Reporting Services. Enter: http://MyMachine/MyReportServerName where MyMachine is your machine name and MyReportServerName is the name of the report server given when you installed SQL Reporting Services.
  6. Enter the Dynamics/Signature Directory. This is the directory where Microsoft Dynamics GP and Signature are installed.
  7. Choose Next >.

  8. All SSRS report folders found in the Dynamics/Signature directory appear on the next wizard screen. Unmark the check box next to any folder, or expand a folder and unmark the check box next to any report, that you do not want to deploy. 

    To use KPI reports and report templates, you must be running SQL Server Reporting Services 2008 R2 or later. Additionally, you must have SQL 2008 R2 Business Intelligence Studio installed to deploy the Signature Template Pivot report template.

  9. Choose Deploy. It will take a few moments to deploy the reports. A message appears when the deployment is successful. Choose OK. The Signature SQL Reporting Wizard starts over again. You can either deploy reports for an additional company database by choosing Next, or you can exit the wizard by choosing Cancel.