Adding fields to an existing report
impetus
Member Posts: 10
Situation; NAV 2009 R2 and VS 2008 installed. Modifying a report for the RTC. I am halfway of modifying report 206 Sales - Invoice.
Now I need to add an extra field to the report which is not present in the dataset and this is the procedure I would like to follow not (yet) knowing if this procedure could mess-up everything.
In Classic, design and then layout, which opens VS
Going to the report.xsd
Add column and type in the extra field needed; Sales_Invoice_Header___Customer_Order_No.
Save the report.xsd and the .rdlc (save all) and close VS 2008
In the Classic save the changes and compile the report
Open design and layout again, which opens VS again and the extra field is available and can be used in the .rdlc
Can someone confirm that the procedure I would like to follow is correct and workable and/or has someone have additional remarks I have to take into account.
Now I need to add an extra field to the report which is not present in the dataset and this is the procedure I would like to follow not (yet) knowing if this procedure could mess-up everything.
In Classic, design and then layout, which opens VS
Going to the report.xsd
Add column and type in the extra field needed; Sales_Invoice_Header___Customer_Order_No.
Save the report.xsd and the .rdlc (save all) and close VS 2008
In the Classic save the changes and compile the report
Open design and layout again, which opens VS again and the extra field is available and can be used in the .rdlc
Can someone confirm that the procedure I would like to follow is correct and workable and/or has someone have additional remarks I have to take into account.
0
Comments
-
I believe you have to add the field in the classic section part of the field and assign a DataSetFieldName to it, to be able to use it in your VS layout.0
-
Dear Shedman,
Thanks, that is one way of doing it, and it worked. I just took the report, design, sections and added the field, compiled it and started over again with the layout for the RTC. It was there and I could select it.
Thanks again, this one is solved.
Serge0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 322 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