Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Report - Table cell not displaying correct data
rico1931
Member Posts: 295
Hello folks!
I seem to have a little problem.
I have a table in the body of my report that is suppose to display the sales line data from an order that was just placed. Here is the layout from the RDLC
As you can see "Net Unit Price " is on the same line as the "Unit Price" which is located 2 cells to the left of "Net Unit Price" This price should display the price for that line item.
Here is what is displayed from the classic client and RTC and how it's suppose to look
You see that the first line item is suppose to have a Net unit price of $55.60 and the 2nd line item is $6.28 ... but here is how the report prints out the prices
It takes the Net Unit Price for the 2nd Line Item and places it where the first one is. I did not make any modification to the C/AL code in the report. This Net Unit Price is a function that is located in the Sales Line Table and all I do in the sections view is call the function to display in the body.
Can anyone give me any insight to what i'm doing wrong? I haven't come across this problem before and I don't know where to begin to tackle this problem.
Thanks again! Any insight would be greatly appreciated!
I seem to have a little problem.
I have a table in the body of my report that is suppose to display the sales line data from an order that was just placed. Here is the layout from the RDLC
As you can see "Net Unit Price " is on the same line as the "Unit Price" which is located 2 cells to the left of "Net Unit Price" This price should display the price for that line item.
Here is what is displayed from the classic client and RTC and how it's suppose to look
You see that the first line item is suppose to have a Net unit price of $55.60 and the 2nd line item is $6.28 ... but here is how the report prints out the prices
It takes the Net Unit Price for the 2nd Line Item and places it where the first one is. I did not make any modification to the C/AL code in the report. This Net Unit Price is a function that is located in the Sales Line Table and all I do in the sections view is call the function to display in the body.
Can anyone give me any insight to what i'm doing wrong? I haven't come across this problem before and I don't know where to begin to tackle this problem.
Thanks again! Any insight would be greatly appreciated!
-rico1931
0
Answers
did you try adding the field in body(below section)?
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
It's because the next body line is for KitSales which means if there is another subitem attached to the main item it will print.. if there is nothing then that line will not print but I figured it out! Here is the solution:
***NOTE: THis is for NA report 10075 "Sales Order"***
Go to Classic report and make sure your textbox properties - MultiLine is set to NO and BlankZero is set to Yes . Next is to make sure you are using the "TempSalesLine.FieldName" variable instead of "Sales Line".FieldName ...
Then in the RDLC make sure to put in a IIF statement like so in the visable property like so : =IIF(Fields!TempSalesLine__No__.Value="",TRUE,FALSE) and the =Code.BlankZero( ) expression to the cell box