Hello....
I want to group my report by various fields
My report is about the item ledger entry and i want that the report groups whenever a "item No.", "variant code" or "location code" of a item changes.
And it is possible to have a total field in group header instead of group footer?
Thanks in advance....
Junior Consultant & Developer in Dynamics NAV
"I'm worse at what I do best
And for this gift I feel blessed
Our little group has always been
And always will until the end"
Nirvana - Nevermind - Smells Like Teen Spirit
0
Answers
P.S.: totalscausedby is not the only way to go, you can (for example) create a new dataitem on "item" table, and then indent and link your item ledger entry dataitem to it...but i don't want to mess up your ideas: it's better for you to read some manuals
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
What i want is this:
Grouping Item Ledger Entry by Item No., Variant Code, Location Code
Standart Report:
Item Nr 1
Variant GREEN
Location 10
Order XPTO Quantity 10
Variant BLUE
Location 10
Order XPTO Quantity 10
What i want to show:
Item Nr 1 Variant GREEN Location 10
Order XPTO Quantity 10
Item Nr 1 Variant BLUE Location 10
Order XPTO Quantity 10
But if i remove the Showoutput(TotalsCausedby) the report shows me 3 equal lines
How can i solve this?
"I'm worse at what I do best
And for this gift I feel blessed
Our little group has always been
And always will until the end"
Nirvana - Nevermind - Smells Like Teen Spirit
I don't know which key you are using, but if the key starts with Item No. , Variant Code, Location Code , you should try to set the GroupField only to 'Location Code' (and delete the Groupfields Item No. & Variant Code). You will not need the TotalsCausedBy anymore , and it will print 1 time for every combination of Item No, Variant Code and Location Code.
Spectacular answer..........
It worked.............
Thank you.............
"I'm worse at what I do best
And for this gift I feel blessed
Our little group has always been
And always will until the end"
Nirvana - Nevermind - Smells Like Teen Spirit