none
SQL Server 2012, Visual Studio 2017 and Report Builder RRS feed

  • Question

  • Hello:

    This is my first foray into SSRS reports. I have installed and configured SQL Server 2012, Visual Studio 2017 and have access to report builder.

    My question is, can I build/author reports in Visual Studio 2017 and deploy to SSRS target server or do I need to use Sql Server Report Builder to author reports?

    Can someone please provide pointers?

    Thanks!

    Monday, June 4, 2018 4:49 PM

Answers

  • Hi diffident,

    First of all, to author SSRS reports you need to install SQL Server Data Tools(SSDT) which a separate installer then Visual Studio. SSDT provides you the required project templates for building SSIS, SSAS and SSRS projects which is not present in regular Visual Studio installation. Using SSDT you can author predesigned reports and deploy them to Report Server where your users can access those reports. Read more about SSDT here: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

    However, Report Builder is a different tool which meant for being a reporting tool for business users who are not too technical but yet have require report authoring abilities for their dynamic reporting needs. Read more about Report Builder here: https://www.mssqltips.com/sqlservertutorial/2100/report-builder-30-tutorial/

    While SSDT is targeted for developers for creating canned reports with minimal user interaction (parameters), the report builder provides easy report authoring methods for business users to create their own reports as and when needed (self served reports).


    HTH,
    Cheers!!
    Ashish
    Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.


    Monday, June 4, 2018 5:20 PM
  • yes

    You can use Visual Studio 2017 to author reports for SSRS 2012

    But you need to ensure BI templates are installed in VS 2017

    Another way to get it is to directly install corresponding  SSDT version inline with VS 2017

    see

    https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

    You need to ensure that TargetServerVersion is correctly set as SQL Server 2012 in project properties


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Marked as answer by diffident Tuesday, June 5, 2018 2:45 PM
    Monday, June 4, 2018 5:27 PM

All replies

  • Hi diffident,

    First of all, to author SSRS reports you need to install SQL Server Data Tools(SSDT) which a separate installer then Visual Studio. SSDT provides you the required project templates for building SSIS, SSAS and SSRS projects which is not present in regular Visual Studio installation. Using SSDT you can author predesigned reports and deploy them to Report Server where your users can access those reports. Read more about SSDT here: https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

    However, Report Builder is a different tool which meant for being a reporting tool for business users who are not too technical but yet have require report authoring abilities for their dynamic reporting needs. Read more about Report Builder here: https://www.mssqltips.com/sqlservertutorial/2100/report-builder-30-tutorial/

    While SSDT is targeted for developers for creating canned reports with minimal user interaction (parameters), the report builder provides easy report authoring methods for business users to create their own reports as and when needed (self served reports).


    HTH,
    Cheers!!
    Ashish
    Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.


    Monday, June 4, 2018 5:20 PM
  • yes

    You can use Visual Studio 2017 to author reports for SSRS 2012

    But you need to ensure BI templates are installed in VS 2017

    Another way to get it is to directly install corresponding  SSDT version inline with VS 2017

    see

    https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

    You need to ensure that TargetServerVersion is correctly set as SQL Server 2012 in project properties


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Marked as answer by diffident Tuesday, June 5, 2018 2:45 PM
    Monday, June 4, 2018 5:27 PM
  • Thank you. Is there one better than the other? Should I be using Visual Studio or report builder to develop reports?
    Monday, June 4, 2018 8:55 PM
  • Hi different,

    I think they have their own advantages, and can't simply think which is better. In report manager, we could use report builder to open and edit the report directly instead of downloading the report and re-deploying it. And with SSDT, you could choose the target version of  SSRS to deploy without compatibility issue.

    Both of two  tools could design the report, you could choose which you like. Or  you could download both for design

    Best Regards,
    Zoe Zhi


    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 MSDNFSF@microsoft.com.

    Tuesday, June 5, 2018 1:36 AM
    Moderator