Wednesday, February 20, 2013

Updating ReportViewer to VS2010

OK, today I blew the dust off of a project that had ReportView 9.0.  Since I had coded that website many moons have pasted and we have upgraded to VS2010.

I tried to just stay on RV9 however, one of the reports was erroring and I had javascript issues with the handler page that it inserts.

So, upgrade I did and not without google's help!

  1. Install on your machine ReportViewer 10
  2. change the references in your project to point to version 10 of Microsoft.ReportViewer.Common and Microsoft.ReportViewer.WebForms
  3. If you registered your control, change this tag in your .aspx or control 
    1. <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0...
 If you have .rdlc files that you need to upgrade, some work and some don't

I had a report that was cause compile errors (The processing of Parent for the tablix ‘table1’ cannot be performed) with the grouping.  I had to take out the "parent" tag and then all was well.  Basically old versions glossed over this mishap, but not version 10.  For the long explanation of why you need to do this, go here.

            OrderNumGrp
">
              <GroupExpressions>
                <GroupExpression>=Fields!ClientOrderNum.Value</GroupExpression>
              </GroupExpressions>
              =Fields!ClosedDate.Value
           

Finally, when you are deploying to a server with IIS7.  Make sure that you add the following to your web.config

webServer
>
...
      ReportViewerWebControlHandler
" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
...
   
  webServer>

Finally, as it always happends, when you get it onto the production server something else goes wrong.  I was getting this error

Compiler Error Message: CS0433: The type 'Microsoft.Reporting.WebForms.ReportDataSource' exists in both 'c:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.WebForms\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.WebForms.dll' and 'c:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.WebForms\9.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.WebForms.dll'

If you add the following to your web.config it tells .net to always direct to the new version


                                                publicKeyToken="b03f5f7f11d50a3a" />
                                              newVersion="10.0.0.0"/>
      


Happy Reporting

No comments:

Post a Comment