Windows report viewer server 2012

System Requirements

Operating Systems: Windows 7, Windows 8, Windows 8.1, Windows Server 2003 Service Pack 2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Vista Service Pack 2

Installation Instructions

Related Resources

• x86 — SQLSysClrTypes
• x64 — SQLSysClrTypes

If you have enabled dynamic and static reports for the app, then the Reports menu option is available in the user interface.

Картинка с сайта: codeontime.com

Selecting any report option will cause the app to produce a PDF, TIFF, Excel, or Microsoft Word document with reporting data.

Картинка с сайта: codeontime.com

If Report Viewer is not installed on the machine, any attempt to start the application will display the error message below stating that “Could not load file or assembly Microsoft.ReportViewer.WebForms…”.

Картинка с сайта: codeontime.com

If you do not need reporting or have enabled it by mistake, then select your project in the app generator, choose Settings, select Reporting, and uncheck “Enable dynamic and static reports in my application”. Click Finish to regenerate the app. You may also consider refreshing all controllers to remove the reporting actions from the user interface.

If you do need built-in reporting in your app, then you need to install Microsoft Report Viewer on your deployment machine.

You will need the following files. It is advisable to download them on your personal machine and then copy them onto the server over Remote Desktop Connection (RDC).

1. Microsoft Report Viewer 2012 Runtime
2. Microsoft Web Platform Installer

Connect to your server via RDC. Copy the files into the Downloads folder of the server.

Installing SQL Server SQL Types

If SQL Server is not present on the server, then you will need to install Microsoft SQL Server 2012 CLR Types component.

Execute the Web Platform installer file by double-clicking on the “wpilauncher” file.

When installation is complete, the Web Platform Installer will open. In the search box, type in “CLR” and hit Enter on your keyboard.

Картинка с сайта: codeontime.com

Press Add next to the first item in the list, then press Install. Accept the license terms to proceed.

Картинка с сайта: codeontime.com

Installing Report Viewer

Switch back to the Downloads folder. Double-click on the “ReportViewer” file.

Картинка с сайта: codeontime.com

Press Next, then accept the license to install Report Viewer.

This procedure will need to be done on both your development machine and your server.

Картинка с сайта: silentinstallhq.com

This article will serve as an informative guide and give you a clear understanding of how to perform silent or interactive installs and uninstalls of the Microsoft Report Viewer 2012 Runtime using the Powershell App Deployment Toolkit. The PowerShell App Deployment Toolkit can be used to replace your WiseScript, VBScript and Batch wrapper scripts with one versatile, re-usable and extensible tool. This tool is an absolute must for Microsoft Endpoint Manager Configuration Manager (MEMCM) / (SCCM) Administrators or anyone who is responsible for packaging and deploying software.

1. Download the Powershell App Deployment Toolkit 3.8.4:
   • https://github.com/PSAppDeployToolkit/PSAppDeployToolkit/releases/download/3.8.4/PSAppDeployToolkit_v3.8.4.zip
2. Download the zip file to a folder created at (C:\Downloads)
3. Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
4. Enter the following command to remove the Zone.Identifier:
   • Unblock-File -Path C:\Downloads\PSAppDeployToolkit_v3.8.4.zip
5. Enter the following command to extract the contents of the zip file:
   • Expand-Archive -Path C:\Downloads\PSAppDeployToolkit_v3.8.4.zip -DestinationPath C:\Downloads\PADT
6. Enter the following commands to copy the AppDeployToolkit & Files folders to “C:\Downloads\ReportViewer2012RT”:
   • Copy-Item -Path "C:\Downloads\PADT\Toolkit\AppDeployToolkit" -Destination "C:\Downloads\ReportViewer2012RT\AppDeployToolkit" -Recurse
   • Copy-Item -Path "C:\Downloads\PADT\Toolkit\Files" -Destination "C:\Downloads\ReportViewer2012RT\Files"

You should now see the AppDeploymentToolkit folder with files & the empty Files folder at “C:\Downloads\ReportViewer2012RT”

Next we’ll want to download the MSI installer for the Microsoft Report Viewer 2012 Runtime and the Microsoft System CLR Types for SQL Server 2012 prerequisite.

• Navigate to: https://www.microsoft.com/en-us/download/details.aspx?id=35747
• Download & Copy the ReportViewer.msi to “C:\Downloads\ReportViewer2012RT\Files\”
• Navigate to: https://download.microsoft.com/download/F/3/C/F3C64941-22A0-47E9-BC9B-1A19B4CA3E88/ENU/x86/SQLSysClrTypes.msi
• Download & Copy the SQLSysClrTypes.msi to “C:\Downloads\ReportViewer2012RT\Files\”
• Copy the PowerShell script below to “C:\Downloads\ReportViewer2012RT“ & name it Deploy-ReportViewer2012RT.ps1

<#
.SYNOPSIS
	This script performs the installation or uninstallation of Microsoft Report Viewer 2012 Runtime.
	# LICENSE #
	PowerShell App Deployment Toolkit - Provides a set of functions to perform common application deployment tasks on Windows.
	Copyright (C) 2017 - Sean Lillis, Dan Cunningham, Muhammad Mashwani, Aman Motazedian.
	This program is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
	You should have received a copy of the GNU Lesser General Public License along with this program. If not, see <http://www.gnu.org/licenses/>.
.DESCRIPTION
	The script is provided as a template to perform an install or uninstall of an application(s).
	The script either performs an "Install" deployment type or an "Uninstall" deployment type.
	The install deployment type is broken down into 3 main sections/phases: Pre-Install, Install, and Post-Install.
	The script dot-sources the AppDeployToolkitMain.ps1 script which contains the logic and functions required to install or uninstall an application.
.PARAMETER DeploymentType
	The type of deployment to perform. Default is: Install.
.PARAMETER DeployMode
	Specifies whether the installation should be run in Interactive, Silent, or NonInteractive mode. Default is: Interactive. Options: Interactive = Shows dialogs, Silent = No dialogs, NonInteractive = Very silent, i.e. no blocking apps. NonInteractive mode is automatically set if it is detected that the process is not user interactive.
.PARAMETER AllowRebootPassThru
	Allows the 3010 return code (requires restart) to be passed back to the parent process (e.g. SCCM) if detected from an installation. If 3010 is passed back to SCCM, a reboot prompt will be triggered.
.PARAMETER TerminalServerMode
	Changes to "user install mode" and back to "user execute mode" for installing/uninstalling applications for Remote Destkop Session Hosts/Citrix servers.
.PARAMETER DisableLogging
	Disables logging to file for the script. Default is: $false.
.EXAMPLE
    PowerShell.exe .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Install" -DeployMode "NonInteractive"
.EXAMPLE
    PowerShell.exe .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Install" -DeployMode "Silent"
.EXAMPLE
    PowerShell.exe .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Install" -DeployMode "Interactive"
.EXAMPLE
    PowerShell.exe .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Uninstall" -DeployMode "NonInteractive"
.EXAMPLE
    PowerShell.exe .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Uninstall" -DeployMode "Silent"
.EXAMPLE
    PowerShell.exe .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Uninstall" -DeployMode "Interactive"
.NOTES
	Toolkit Exit Code Ranges:
	60000 - 68999: Reserved for built-in exit codes in Deploy-Application.ps1, Deploy-Application.exe, and AppDeployToolkitMain.ps1
	69000 - 69999: Recommended for user customized exit codes in Deploy-Application.ps1
	70000 - 79999: Recommended for user customized exit codes in AppDeployToolkitExtensions.ps1
.LINK
	http://psappdeploytoolkit.com
#>
[CmdletBinding()]
Param (
	[Parameter(Mandatory=$false)]
	[ValidateSet('Install','Uninstall','Repair')]
	[string]$DeploymentType = 'Install',
	[Parameter(Mandatory=$false)]
	[ValidateSet('Interactive','Silent','NonInteractive')]
	[string]$DeployMode = 'Interactive',
	[Parameter(Mandatory=$false)]
	[switch]$AllowRebootPassThru = $false,
	[Parameter(Mandatory=$false)]
	[switch]$TerminalServerMode = $false,
	[Parameter(Mandatory=$false)]
	[switch]$DisableLogging = $false
)

Try {
	## Set the script execution policy for this process
	Try { Set-ExecutionPolicy -ExecutionPolicy 'ByPass' -Scope 'Process' -Force -ErrorAction 'Stop' } Catch {}

	##*===============================================
	##* VARIABLE DECLARATION
	##*===============================================
	## Variables: Application
	[string]$appVendor = ''
	[string]$appName = 'Microsoft Report Viewer 2012 Runtime'
	[string]$appVersion = ''
	[string]$appArch = ''
	[string]$appLang = ''
	[string]$appRevision = ''
	[string]$appScriptVersion = '1.0.0'
	[string]$appScriptDate = 'XX/XX/20XX'
	[string]$appScriptAuthor = 'Jason Bergner'
	##*===============================================
	## Variables: Install Titles (Only set here to override defaults set by the toolkit)
	[string]$installName = ''
	[string]$installTitle = 'Microsoft Report Viewer 2012 Runtime'

	##* Do not modify section below
	#region DoNotModify

	## Variables: Exit Code
	[int32]$mainExitCode = 0

	## Variables: Script
	[string]$deployAppScriptFriendlyName = 'Deploy Application'
	[version]$deployAppScriptVersion = [version]'3.8.4'
	[string]$deployAppScriptDate = '26/01/2021'
	[hashtable]$deployAppScriptParameters = $psBoundParameters

	## Variables: Environment
	If (Test-Path -LiteralPath 'variable:HostInvocation') { $InvocationInfo = $HostInvocation } Else { $InvocationInfo = $MyInvocation }
	[string]$scriptDirectory = Split-Path -Path $InvocationInfo.MyCommand.Definition -Parent

	## Dot source the required App Deploy Toolkit Functions
	Try {
		[string]$moduleAppDeployToolkitMain = "$scriptDirectory\AppDeployToolkit\AppDeployToolkitMain.ps1"
		If (-not (Test-Path -LiteralPath $moduleAppDeployToolkitMain -PathType 'Leaf')) { Throw "Module does not exist at the specified location [$moduleAppDeployToolkitMain]." }
		If ($DisableLogging) { . $moduleAppDeployToolkitMain -DisableLogging } Else { . $moduleAppDeployToolkitMain }
	}
	Catch {
		If ($mainExitCode -eq 0){ [int32]$mainExitCode = 60008 }
		Write-Error -Message "Module [$moduleAppDeployToolkitMain] failed to load: `n$($_.Exception.Message)`n `n$($_.InvocationInfo.PositionMessage)" -ErrorAction 'Continue'
		## Exit the script, returning the exit code to SCCM
		If (Test-Path -LiteralPath 'variable:HostInvocation') { $script:ExitCode = $mainExitCode; Exit } Else { Exit $mainExitCode }
	}

	#endregion
	##* Do not modify section above
	##*===============================================
	##* END VARIABLE DECLARATION
	##*===============================================

	If ($deploymentType -ine 'Uninstall' -and $deploymentType -ine 'Repair') {
		##*===============================================
		##* PRE-INSTALLATION
		##*===============================================
		[string]$installPhase = 'Pre-Installation'

		## Show Welcome Message
		Show-InstallationWelcome

		## Show Progress Message (with the default message)
		Show-InstallationProgress

        ## Remove Any Existing Versions of Microsoft Report Viewer 2012 Runtime
        Remove-MSIApplications -Name 'Microsoft Report Viewer 2012 Runtime'
  
		##*===============================================
		##* INSTALLATION
		##*===============================================
		[string]$installPhase = 'Installation'

        ## Install Microsoft System CLR Types for SQL Server 2012
        $SQLSysClrTypes = Get-ChildItem -Path "$dirFiles" -Include SQLSysClrTypes.msi -File -Recurse -ErrorAction SilentlyContinue
        If($SQLSysClrTypes.Exists)
        {
        Write-Log -Message "Found $($SQLSysClrTypes.FullName), now attempting to install Microsoft System CLR Types for SQL Server 2012."
        Show-InstallationProgress "Installing the Microsoft System CLR Types for SQL Server 2012. This may take some time. Please wait..."
        Execute-MSI -Action Install -Path "$SQLSysClrTypes"
        Start-Sleep -Seconds 5
        }

        ## Install Microsoft Report Viewer 2012 Runtime
        $MsiPath = Get-ChildItem -Path "$dirFiles" -Include ReportViewer.msi -File -Recurse -ErrorAction SilentlyContinue
        If($MsiPath.Exists)
        {
        Write-Log -Message "Found $($MsiPath.FullName), now attempting to install the $installTitle."
        Show-InstallationProgress "Installing the Microsoft Report Viewer 2012 Runtime. This may take some time. Please wait..."
        Execute-MSI -Action Install -Path "$MsiPath"
        Start-Sleep -Seconds 5
        }
    
		##*===============================================
		##* POST-INSTALLATION
		##*===============================================
		[string]$installPhase = 'Post-Installation'

	}
	ElseIf ($deploymentType -ieq 'Uninstall')
	{
		##*===============================================
		##* PRE-UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Pre-Uninstallation'

		## Show Welcome Message
		Show-InstallationWelcome

        ## Show Progress Message (With a Message to Indicate the Application is Being Uninstalled)
        Show-InstallationProgress -StatusMessage "Uninstalling the $installTitle. Please Wait..."


		##*===============================================
		##* UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Uninstallation'

        ## Uninstall Any Existing Versions of Microsoft Report Viewer 2012 Runtime
        Remove-MSIApplications -Name 'Microsoft Report Viewer 2012 Runtime'


		##*===============================================
		##* POST-UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Post-Uninstallation'


	}
	ElseIf ($deploymentType -ieq 'Repair')
	{
		##*===============================================
		##* PRE-REPAIR
		##*===============================================
		[string]$installPhase = 'Pre-Repair'


		##*===============================================
		##* REPAIR
		##*===============================================
		[string]$installPhase = 'Repair'


		##*===============================================
		##* POST-REPAIR
		##*===============================================
		[string]$installPhase = 'Post-Repair'


    }
	##*===============================================
	##* END SCRIPT BODY
	##*===============================================

	## Call the Exit-Script function to perform final cleanup operations
	Exit-Script -ExitCode $mainExitCode
}
Catch {
	[int32]$mainExitCode = 60001
	[string]$mainErrorMessage = "$(Resolve-Error)"
	Write-Log -Message $mainErrorMessage -Severity 3 -Source $deployAppScriptFriendlyName
	Show-DialogBox -Text $mainErrorMessage -Icon 'Stop'
	Exit-Script -ExitCode $mainExitCode
}

Ok, all the hard work is done and now you can install or uninstall the Microsoft Report Viewer 2012 Runtime using one single PowerShell script. Simply change the DeploymentType parameter to install or uninstall. Logging functionality is built-in automatically and you can view the log files under “C:\Windows\Logs\Software”.

Microsoft Report Viewer 2012 Runtime NonInteractive Install (PowerShell)

NonInteractive means Very Silent, i.e. no blocking apps. This is automatically set if it is detected that the process is not running in the user session and it is not possible for anyone to provide input using a mouse or keyboard.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\ReportViewer2012RT”
  • PS C:\Downloads\ReportViewer2012RT>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Install" -DeployMode "NonInteractive"

Microsoft Report Viewer 2012 Runtime Silent Install (PowerShell)

Silent means no dialogs (progress and balloon tip notifications are suppressed).

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\ReportViewer2012RT“
  • PS C:\Downloads\ReportViewer2012RT>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Install" -DeployMode "Silent"

Microsoft Report Viewer 2012 Runtime Interactive Install (PowerShell)

Interactive means the install will show dialogs including progress and balloon tip notifications.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\ReportViewer2012RT”
  • PS C:\Downloads\ReportViewer2012RT>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Install" -DeployMode "Interactive"

Microsoft Report Viewer 2012 Runtime NonInteractive Uninstall (PowerShell)

NonInteractive means Very Silent, i.e. no blocking apps. This is automatically set if it is detected that the process is not running in the user session and it is not possible for anyone to provide input using a mouse or keyboard.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\ReportViewer2012RT“
  • PS C:\Downloads\ReportViewer2012RT>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Uninstall" -DeployMode "NonInteractive"

Microsoft Report Viewer 2012 Runtime Silent Uninstall (PowerShell)

Silent means no dialogs (progress and balloon tip notifications are suppressed).

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\ReportViewer2012RT“
  • PS C:\Downloads\ReportViewer2012RT>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Uninstall" -DeployMode "Silent"

Microsoft Report Viewer 2012 Runtime Interactive Uninstall (PowerShell)

Interactive means the install will show dialogs including progress and balloon tip notifications.

• Open Windows PowerShell by Right-Clicking on Windows PowerShell and selecting Run as Administrator
• Change the directory to “C:\Downloads\ReportViewer2012RT“
  • PS C:\Downloads\ReportViewer2012RT>
• Enter the following command:

Powershell.exe -ExecutionPolicy Bypass .\Deploy-ReportViewer2012RT.ps1 -DeploymentType "Uninstall" -DeployMode "Interactive"

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.