Share via

Report viewer smart tag, 'Design a new report' is missing

  • Article

Question

Monday, July 17, 2017 4:54 AM

Installed Report viewer control in VS2017, but it seems 'Report server Url' & 'Design a new report' are missing from the smart tag, not sure why, would be appreciated if anyone could help on this, cheers.



All replies (6)

Tuesday, July 18, 2017 3:11 AM ✅Answered

Dear friend,

Thanks for your post.

To help you I need more info to repro it, allow me to ask some questions.

Have you downloaded the extension from here?

if so you need to update the Nuget:

Win:

https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.Winforms/140.340.80

Web:

https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/140.340.80/

Please feel free to let me know if misunderstood it.

 

Best regards,

Fletcher

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected].

Thursday, July 20, 2017 6:40 AM ✅Answered

Dear friend,

Thanks for your response.

Actually,  I just installed this version in my VS:

https://marketplace.visualstudio.com/items?itemName=SqlReportingServices.MicrosoftRdlcReportDesignerforVisualStudio-18001

To test this, I added the ReportViewer control to a new web project:

  1. Create a new ASP.NET Empty Web Site or open an existing ASP.NET project.

   2. Install the ReportViewer 2016 control nuget package via the Nuget package manager console.

Install-Package Microsoft.ReportingServices.ReportViewerControl.WebForms

  3. Add a new .aspx page to the project and register the ReportViewer control assembly for use within the page, and final page looks like below:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Sample" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="X-UA-Compatible" content="IE=edge" /> 
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager runat="server"></asp:ScriptManager>        
        <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote">
            <ServerReport ReportServerUrl="http://AContosoDepartment/ReportServer" ReportPath="/LatestSales" />
        </rsweb:ReportViewer>
    </form>
</body>
</html>

Updating an existing project to use the ReportViewer control

To make use of the ReportViewer 2016 control in an existing project, add the control via Nuget and update the assembly references to version 14.0.0.0. This will include updating the project's web.config and all .aspx pages that reference the ReportViewer control.

Sample web.config changes

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <system.web>
    <compilation debug="true" targetFramework="4.5.2">
      <assemblies>
        <!-- All assemblies updated to version 14.0.0.0. -->
        <add assembly="Microsoft.ReportViewer.Common, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.DataVisualization, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.Design, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.ProcessingObjectModel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.WebDesign, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.WebForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.WinForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
      </assemblies>
      <buildProviders>
        <!-- Version updated to 14.0.0.0. -->
        <add extension=".rdlc"
          type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
      </buildProviders>
    </compilation>
    <httpRuntime targetFramework="4.5.2"/>
    <httpHandlers>
      <!-- Version updated to 14.0.0.0 -->
      <add path="Reserved.ReportViewerWebControl.axd" verb="*"
        type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"
        validate="false"/>
    </httpHandlers>
  </system.web>
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false"/>
    <modules runAllManagedModulesForAllRequests="true"/>
    <handlers>
      <!-- Version updated to 14.0.0.0 -->
      <add name="ReportViewerWebControlHandler" verb="*" path="Reserved.ReportViewerWebControl.axd" preCondition="integratedMode"
        type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
    </handlers>
  </system.webServer>
</configuration>

and I could see the ReportViewer like :

This official page demonstrate it much better then me:

/en-us/sql/reporting-services/application-integration/integrating-reporting-services-using-reportviewer-controls-get-started

Really hope above helps.

 

Best regards,

Fletcher

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected].

Tuesday, July 18, 2017 12:47 PM

Hi Fletch,

Thank you very much for the reply.

Tried your solution, unfortunately it still doesn't work.

Tried to install in another computer, still the same problem, here are my steps.

1) installed 'Microsoft Reporting Services Projects' from here.

2) installed 'Microsoft Rdlc Report Designer for Visual Studio' from here.

then installed 2 Nugets in your reply.

Not sure what the problem is, will be appreciated if you help to find it, thanks.

Wednesday, July 19, 2017 5:29 AM

Dear friend,

You installed the different extension, mine which posted above is this:

https://marketplace.visualstudio.com/items?itemName=SqlReportingServices.MicrosoftRdlcReportDesignerforVisualStudio-18001

Please try it and let me know the result.

 

Best regards,

Fletcher

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [email protected].

Wednesday, July 19, 2017 2:29 PM

Dear Fletch,

I did install the same extension, which is the 2nd step in my last reply, but it seems I installed another one as well, 'Microsoft Reporting Services Projects', as 1st step, tried to uninstall this one, still doesn't work.

here are the installed extension and Nugets for your reference, many thanks.

Thursday, July 20, 2017 11:45 AM

Dear Fletch,

Thank you so much for your attention and efforts.

Although I couldn't start a new report from smart tag, I still can design a report from 'Add a new item', I am happy with that, it's time to move on.

Thank you again for your help ^0^.

Cheers,

Jie