RDLC Report Designer

Reedberg
Reedberg Member Posts: 68
in NAV Three Tier
Hello NAV experts!
I can’t open RDLC report for NAV 2013 R2 using report designer. I can only open it using XML editor, which is not very useful.

DISCLAIMER: I already used google and found a lot of solutions, but none of them solved my problem.

My system configuration:
Windows 8.1, SQL Server Express 2012, Dynamics NAV 2013 R2, Visual Studio Professional 2012.

What I already did in order to solve the issue:
I Installed:
- Microsoft SQL Server Reporting Services;
- SQL Server System CLR Types;
- Report Viewer 2012;
- Microsoft SQL Server Data Tools;
- Tried to repair Visual Studio from Control Panel;

It doesn’t help. When I open RDLC report with Visual Studio and select “Open With” in “Solution Explorer” I don’t see any RDLC constructor (kindly refer to the screenshot attached). Could you please advise how to solve it? I am totally stuck with this issue, so any advice would be really appreciated.

Best Answers

  • gbierkens
    gbierkens Member Posts: 49
    Answer ✓
    I think the main difference is that you are using VS 2012.
    http://community.dynamics.com/nav/f/34/t/93996

    BriteBlue Solutions BV | briteblue.nl

Answers

  • gbierkens
    gbierkens Member Posts: 49
    pjej8dkskd5y.png


    Did install the Microsoft sql server data tools ?
    VS.png 33.1K
    BriteBlue Solutions BV | briteblue.nl
  • Reedberg
    Reedberg Member Posts: 68
    Hi, gbierkens,
    Man, thank you for your effort. Yes, I did install it - at least I can see it from "Programs and Features" tab. However, when choosing to "Modify" Visual Studio "Microsoft sql server data tools" is not listed.
    It seems that Visual Studio does not recognise that "sql server data tools" are installed..
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    Hey,

    Did you tried opening it with Report Builder. I too have NAV 2013 R2 but Visual Studio Professional 2013 which runs with no issue.
    NAV Dev Environment --> Tools --> Option --> Use Report Builder.

    Try once executing this.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • Reedberg
    Reedberg Member Posts: 68
    Hey, RockWithNAV,
    Thank you for your reply. Yes, I didn't mention it, I can open report with Report Builrder. That part works well.
    However, I need to open it with Visual Studio 2012.
  • JonasA
    JonasA Member Posts: 29
    Have you remembered to install "Web Developer Tools"?
    Reference: https://clauslblog.wordpress.com/2014/11/26/free-visual-studio-designer-for-nav-2015-and-nav-2013-r2/
  • Reedberg
    Reedberg Member Posts: 68
    Hi, JonasA,
    Yes, "Web Developer Tools" is installed (can be seen on my second screenshot). Thank you for the provided link.
  • gbierkens
    gbierkens Member Posts: 49
    Answer ✓
    I think the main difference is that you are using VS 2012.
    http://community.dynamics.com/nav/f/34/t/93996

    BriteBlue Solutions BV | briteblue.nl
  • ievasimplanova
    ievasimplanova Member Posts: 45
    HI,
    If You are interested in creating Dynamics NAV reports more quickly, we suggest Dynamcis NAV RDLC report designer tool. You can request DEMO version here
    Tired of Dynamics NAV Report Upgrades? - Convert automatically Classic NAV reports to RDLC format with Simplanova Report Converter

Categories