Grouping And TotalsCausedBy

Kc_Nirvana

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....

rhpnt

Lookup "Totalscausedby" in NAV online help.

Belias

Kc_Nirvana wrote:

And it is possible to have a total field in group header instead of group footer?

Not out of the box. You have to use RDLC layout (if possible). Otherwise you have calculate the total (or subtotal) by code before the group starts.

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

Kc_Nirvana

I am doing a report that objective is to count the itens that arrived in a date and then show the order lines that are pending for that item.

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?

PeterVersteege

You write : Grouping by Item No., Variant Code, Location Code.

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.

Kc_Nirvana

PeterVersteege wrote:

You write : Grouping by Item No., Variant Code, Location Code.

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.............