mibuso.com

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?

Hint : Use the integer dataitem.

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

Check the report 113.

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.

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;

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

Ok




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.




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