How to group a report from a variable value in navision

Lalaka

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?

dans

Hint : Use the integer dataitem.

sameerar

Take a Temporary Record variable and using Integer DataItem and group the data.

Check the report 113.

Lalaka

dans wrote:

Hint : Use the integer dataitem.

Thanks.. I have googled a lot and have not found any way to figure out how to use the integer table. I read once that it is used for looping. But at this instance how do you make use of it.
Do you tie the Volume variable to the Integer data item and loop?
I cannot understand how I should go with this. I started working with Navision only in January.

sameerar

Check the 113 Report - DataItem Integer - Code on OnPreDataItem() and OnAfterGetRecord().

See Below.

Integer - OnPreDataItem()

ValueEntryBuffer.RESET;
SETRANGE(Number, 1, ValueEntryBuffer.COUNT);

Integer - OnAfterGetRecord()
IF Number = 1 THEN
ValueEntryBuffer.FIND('-')
ELSE
ValueEntryBuffer.NEXT;

Lalaka

sameerar wrote:

Take a Temporary Record variable and using Integer DataItem and group the data.

Check the report 113.

Thanks how do you do this? How do you group with the Integer Data item.?

Lalaka

sameerar wrote:

Check the 113 Report - DataItem Integer - Code on OnPreDataItem() and OnAfterGetRecord().

See Below.

Ok

Integer - OnPreDataItem()

ValueEntryBuffer.RESET;
SETRANGE(Number, 1, ValueEntryBuffer.COUNT);

We reset the VE variable and create a filter. What does this do? OK :)Sets the Number's range from 1 to the amount of records in VE.

Integer - OnAfterGetRecord()
IF Number = 1 THEN
ValueEntryBuffer.FIND('-')
ELSE
ValueEntryBuffer.NEXT;

What do we do here? How do we do the calculation?