How to group a report from a variable value in navision

Hi! I want to group a report from variable value. Is there anyone who knows how to do it.

This is my task. I have created a report using the Prod. Order Line table and I have extracted the Volume field from the Item using GET, this I have assigned it to a variable GTextVolume. These volume values contains volumes of the specified items (750,350,150 etc…). Now when the report is running I want to group the reports records from this field, GTextVolume.

Ex:

150
ProdOr1
ProdOr2
ProdOr3
ProdOr4
ProdOr5

750
ProdOr6
ProdOr7
ProdOr8
ProdOr9
ProdOr10

Is this possible? How do I specify a key?

Hi…

I’m guessing you have Prod Order Line as the data item? if so then this is not possible.

can your code be changed either be adding a second data item (item table) indented or just using the item table instead?

Yeah! I thought of doing a quick GET by the Source No in Prod Order Line Table and sorting through!

Is this method OK

I can’t think of all the Keys on your Prod Order Line table?

is Source No. a key? if so then yes …

Yeah Thanks! It works [:D]

Yeah Thanks! It works