NAV2015 export and edit custom RDL(C) report layout
Miklos_Hollender
Member Posts: 1,629
So when I go to custom layouts, make one and export it, it makes an RDL file. Not RDLC. And I can edit that in SQL Server, but in Visual Studio 2012 not, as it opens in XML view. Tried using Claus's OfflineReport project then Solution Explorer -> Add Existing Item, still just XML view. So I cannot edit it in Visual Studio. SQL Server Report Builder works, but it is subpar (no Document Outline -> how do you find the CustAddr textbooks in order to add new fields to the Code.SetData?)
If I use the development environment and go View, Layout, it opens the standard layout, not a custom.
The only option would be to edit a custom layout would be to do it from the client i.e. Custom Layouts page. But that is what I cannot do because I don't have Visual Studio 2012 installed on the server. Only locally on my laptop. And I cannot run the NAV RTC client locally, only on the server due to the usual communication protocol mismatch etc. things, they are in different domains, different activedirectory or what is this thing called, I can run the development environment locally and connect to the server as it accepts NAV password authentication (formerly SQL Auth) but the client not.
(Note: behold the masterful wording of the article: https://msdn.microsoft.com/en-us/librar ... 80%29.aspx it manages to dance around the issue by not mentioning at all how to open the RDL file in Visual Studio. It is excellent at giving the impression that it should be possible without literally doing so! =D> )
If I use the development environment and go View, Layout, it opens the standard layout, not a custom.
The only option would be to edit a custom layout would be to do it from the client i.e. Custom Layouts page. But that is what I cannot do because I don't have Visual Studio 2012 installed on the server. Only locally on my laptop. And I cannot run the NAV RTC client locally, only on the server due to the usual communication protocol mismatch etc. things, they are in different domains, different activedirectory or what is this thing called, I can run the development environment locally and connect to the server as it accepts NAV password authentication (formerly SQL Auth) but the client not.
(Note: behold the masterful wording of the article: https://msdn.microsoft.com/en-us/librar ... 80%29.aspx it manages to dance around the issue by not mentioning at all how to open the RDL file in Visual Studio. It is excellent at giving the impression that it should be possible without literally doing so! =D> )
0
Comments
-
Note: manually changing the extension from RDL to RDLC does enable the opening in VS2012, and ctrl-alt-t does bring document outline, but still the website menu is missing in order to run a build and check for errors.
Googling is telling me RDL and RDLC are basically the same thing except there is some client-side data-binding in RDLC that enables Visual Studio to do some stuff. I guess that is why Website / Build is not displayed with such an RDL file renamed to RDLC!
I think I could live without that if someone could just promise that this export-RDL-rename-to-RDLC-edit-import is safe enough to base my invoices etc. on it without potentially losing days of work.0 -
Aaargh, this doesn't actually work because the smallest mistake results in definition of the report is invalid report when running, without actually telling _what_ is wrong. I must ignore custom layouts and modify the build in.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions