locked
Report render on IIS 7 get #error for formular RRS feed

  • Question

  • User1790760290 posted

    Hi There

    I use visual studio 2012 with dotnet 4.5, using report Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, everything is working on visual studio 2012 for the reports rdlc,

    But after I deploy to IIS 7, all reports witch has formular showing #Error.

    I user local report viewer show the reports. 

    Any one has idea why this is happened?

    Thanks 

    Tony

    Monday, July 28, 2014 2:05 PM

Answers

All replies

  • User-734925760 posted

    Hi,

    According to your description, I think you should make sure that you have installed the SSIS in the IIS server.

    There is a similar thread, please refer to the link below:

    http://stackoverflow.com/questions/15893813/hosting-sql-server-reporting-service-to-iis

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    Tuesday, July 29, 2014 5:48 AM
  • User1790760290 posted

    Thanks for quick replay, I am sure the SSRS is installed on the server.

    I can use it to view rdl report without any problem.

    My problem is my rdlc report, when no formular, report is working, any formular will get #ERROR instead of content.

    BTW: I already included ReportViewer.Common.dll and ReportViewer.WebForms.DLL in the bin folder for reference

    Tuesday, July 29, 2014 12:13 PM
  • User1790760290 posted

    Finally, I found solution. it is security issue for rdlc, after I put

        // Added below line to grant additional permission to execute the expression assembly
        report.SetBasePermissionsForSandboxAppDomain(AppDomain.CurrentDomain.PermissionSet.Copy());
        
        report.SetParameters(parameters);

    All my reports working as a rock.

    Hopes this can help other people who update report from vusial studio 2008 to vusial studio 2010, visual studio 2012 or visual studio 2013

    Details please see url (second one code works)

    http://blogs.msdn.com/b/brianhartman/archive/2010/02/18/expression-evaluation-in-local-mode.aspx

    http://dotnetsoldier.blogspot.ca/2014/01/error-in-local-report-parameter-value.html 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 29, 2014 1:16 PM