Hi Nav Experts!!
I am developing one report, I am facing problem, unable to print values as per area code
I am getting records as follows:
batchno area code quantity
C01 001 2
C01 002 1
C01 003 4
C01 004 1
C02 001 3
C02 002 2
C03 001 4
C03 003 4
I want to print total quantity as per area code,
example as follows:
area code quantity
001 9
002 3
003 8
004 1
I want to use integer dataitem or any other solution,as don't want to change the structure of database as it will refluct on other areas.
Can I get any help
Thanks
0
Comments
You can use (or create if needed) a key on the area code and then use the TotalFields and GroupTotalFields properties (or use the createtotals command)
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
I created key for area code but not use.
My Dataitems are:
Item Journal Batch
>Item Journal Line
>>Posted Count/Picking Header
>>>Posted Count/Picking Lines
Item Journal Batch - for Item Journal batch no.
Item Journal Line link with Item Journal Template Name
Posted Count/Picking Header Linked with Iem Journal Batch Name,Document Date
here the problem arising with Posted Count/Picking Lines
Posted Count/Picking Lines Linked with Type,Batch No.( 1. Type --> either Count/Picking and 2. batchno --> Count/Picking batchno.)
Area Code is located in Posted Count/Picking Header and Posted Count/Picking Lines.
so getting the result as mentioned.
Not as simple as it first seemed. As I see it you have two options
1. Create a temporary table and store the area value in there and use an integer dataitem to print it.
2. Restructure your report by i) putting an area loop outside or ii) use the Posted Count/Picking Lines as the primary dataitem with the batches as lookups.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html
I don't have idea on temporary integer dataitem, I never used. I requested for this help!
Thanks
Can get any example. the same way as the situtaion..
Thanks
Here is a sample report object for your solution. It stores the "Entry Type" in an array and "Quantity" for corresponding "Entry Type" in another array. In integer dataItem, the array values are getting printed.
I hope it helps :P
Technical Consultant, MS Dynamics NAV
Excellent !
Thanks a lot....
I am really looking for this type solution, as I never worked on integer, I don't know the process,
Thanks for providing good solution.