Error While Creating PPS SP2 Reporting Services 2008 Report...The Fix
While working on a proof this past week, I installed PerformancePoint 2007 SP2...wishing to use it with SQL Server 2008's Reporting Services. However, when creating a report which was of Reporting Services type, I recieved the following error - "Could not load file or assembly Microsoft.ReportViewer.WinForms". See image of the error below.
Well...what I learned is that Report Viewer wasn't installed by PerformancePoint 2007 SP2, so you'll need to install it on the workstations where you are going to use PPS Dashboard Designer. Luckily installing is very easy using the Report Viewer 2008 Redistributable installer found here: https://www.microsoft.com/downloads/details.aspx?familyid=CC96C246-61E5-4D9E-BB5F-416D75A1B9EF&displaylang=en.