Problem with SSRS running in Local Mode when a parameter is blank

Zolotoy 226 Reputation points
2022-09-16T21:09:21.217+00:00

I have a very basic test report where I am using a parameter in a query. It is a visible text parameter with no default value.
When I run it it looks like this:
242003-image.png

If I click on View Report not providing any value for the parameter I am not getting anything back, it just shows the same screen. If I check the Console then I see something like this:
241988-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,911 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,576 Reputation points
    2022-09-19T02:25:28.41+00:00

    Hi @Zolotoy ,
    If you read the complete error message solution of this was in message. You have to add below given declaration in web.config HTTPHANDLERS section.

    <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />  
    

    Here is the e.g.:

     <system.web>  
        <httpHandlers>  
          <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />  
        </httpHandlers>  
      </system.web>  
    

    Or declare the below given code in web.config in Handelrs section.

    <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />  
    

    Here is the example:

      <system.webServer>  
        <handlers>  
         <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />  
        </handlers>  
      </system.webServer>  
    

    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Olaf Helper 43,901 Reputation points
    2022-09-19T06:31:03.023+00:00

    Have you read the error message?

    Your browser does not support scripts or has been configured not to allow scripts.

    Which browser are you using and are scripts allowed to execute?

    SSRS running in Local Mode

    In local means, you have no SSRS server at all, only some RLDC reports rendering local?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.