A couple of weeks ago Microsoft Visual Studio 2010 was released. Unfortunately we will not be able to support Visual Studio 2010 in Dynamics NAV 2009 when developing SSRS (RDLC) reports.
When you are designing RDLC reports in NAV 2009 you are creating reports in a format known as the “RDL 2005” format. Both Visual Studio 2005 and 2008 supports this format, but not Visual Studio 2010. Visual Studio 2010 is able to open the “RDL 2005” format but will immediately convert the report to “RDL 2008” format. This conversion gives us the some challenges:
So to avoid this confusion we will not open up for Visual Studio 2010 support before our next major version of Dynamics NAV.
If you for other reasons want to use Visual Studio 2010 you can easily have Visual Studio 2008 and Visual Studio 2010 installed on the same machine. We will just open the Visual Studio 2008 version when you select “View / Layout” in the Object Designer.
If you only have Visual Studio 2010 installed you will see this message:
“An error occurred when opening Report Designer. A supported version of Visual Studio could not be found.“
This is the same message you get when you have no Visual Studio installed, because we search for the following Visual Studio versions and in prioritized order. So in case you have both Visual Studio 2005 and 2008 installed, we will use the 2008 version:
In a previous blog post I outlined the Visual Studio options you have for designing RDLC reports for NAV 2009, and this list is still valid.
Hint: If you are using Windows 7 and want to use “Microsoft SQL Server 2008 Express with Advanced Services ” you need to install “Microsoft SQL Server 2008 R2 Express with Advanced Services” to have a successful installation.
Claus Lundstrøm, Program Manager, Microsoft Dynamics NAV
Just to let you know Pivotier support VS 2010 fully for ad-hoc, financial and VS report creation.
So NAV developers can use VS 2010 from inside NAV and create reports which connect to NAV data, use Dundas charts, export to Word, as well as publish and run reports from SSRS against SQL 2008.
Check it out at Directions.
Developing report document layouts (Invoice, Cr. Memo, BOL, etc.) for the RTC using RDLC (RDL 2005) is very time consuming. Any given RTC document layout report take at least twice as long to do for the RTC compared to using the native Navision report designer. Also there are several strange workarounds for displaying data in the header and footer sections, etc. which make it very confusing and un-logical to work with these RTC reports.
Will it be easier to create these types of reports in future version of NAV? For us, this is a major issue and a big concern.
Thanks in advance for any input.
Microsoft Dynamics navision 2009
Tools -Object designer-Report-Any report. Press Alt+D-Go to View(Alt+V) then layout Following error ocuur
Can any one help me.
The following files were specified on the command line:
C:\Users\v-trtoma\AppData\Local\Temp\Microsoft Dynamics Nav\Report50015(0)\ReportLayout\ReportLayout.sln
C:\Users\v-trtoma\AppData\Local\Temp\Microsoft Dynamics Nav\Report50015(0)\ReportLayout\Report.rdlc
These files could not be found and will not be loaded.
I would love to hear your answer to Bruno's question as I think it's something that most of us who have created reports with RDLC feels very strongly about.
I was trying to put comment on following post, but option is not available for comments:
Can you assist me providing solution of applying Filters to a Report using Web Service and generate a PDF with it?