RecRef on Report

NAV1991

Hi,
I use RecRef type to show date on report (navision 2016). The code is:

OnPreReport()
RecRefe.OPEN(50000);
FieldRef:=RecRefe.FIELD(4);
IF RecRefe.FINDFIRST THEN
REPEAT
EmployeeNo:=FieldRef.VALUE;
UNTIL RecRefeR.NEXT=0;

When I show EmployeeNo on report I only get the last value, but I need list of all employees. How to solve this?

Best regards

einsTeIn.NET

OnPreReport is executed before even a single record of your DataItem is touched. You have to move your code to another trigger, e.g. OnAfterGetRecord of your DataItem, or something like that.

If you do so, you don't need a loop anymore. Your DataItem will be looped anyway.

archer89

set your custom table 50000 (employee ?) as first dataitem in your report,
add needed fields as columns under that dataitem.
set needed report layout to display the values.

kriki

[Topic closed because of double posting]
See https://forum.mibuso.com/discussion/69464