Multiple date lines in report

Veselin
Veselin Member Posts: 19
in NAV/Navision Classic Client
Hello!
How it's possible to print different shipment date in report?

Example:

Lines:
For line 1 No. -> Shipment Date: 12.12.18
For line 2 No. -> Shipment Date: 13.12.18

Report should be like this:
No. | Shipment Date
Line 1 No. | 12.12.18
Line 2 No. | 13.12.18

Answers

  • ishyampandey@live.com
    ishyampandey@live.com Member Posts: 4
    Take your line Level Table as a data item.
    if the table have the line no then no issue otherwise take an integer type variable
    init it onpredata item (LineNo := 1) and on OnaftergetTrigger (LineNo+=1)
    and your date will print according to your data. assign them on section system will print as you want.
  • Veselin
    Veselin Member Posts: 19
    ishyampandey@live.com wrote: »
    Take your line Level Table as a data item.
    if the table have the line no then no issue otherwise take an integer type variable
    init it onpredata item (LineNo := 1) and on OnaftergetTrigger (LineNo+=1)
    and your date will print according to your data. assign them on section system will print as you want.

    Would you like to explain in code. It's hard for me to understand you in that way.
  • Veselin
    Veselin Member Posts: 19
    I was trying:

    ProdOrderLine.RESET;
    ProdOrderLine.SETRANGE("Prod. Order No.", "No.");
    IF ProdOrderLine.FIND('-') THEN BEGIN
    ProdOrderLine.CALCFIELDS(ProdOrderLine."Shipment Date");
    REPEAT
    i+=1;
    arrDate := ProdOrderLine."Shipment Date";
    UNTIL ProdOrderLine.NEXT = 0;
    END;

    Now I have error:
    Type conversion is not possible because 1 of the operators contains in invalid type.
    Char := Date

    When I change arrDate to be DATE, it's give me another error:


    There are too many dimensions. The Variable is defined with fewer dimensions. For example:

    MyVar
    MyArray[MyVar]
    MyArray[1,2]
    MyArray[1][2]
  • wolfskin
    wolfskin Member Posts: 84
    ishyampandey@live.com has a good point.

    Take the Prod. Order Line as a data item. You can see report object ID: 5500 - "Prod. Order Comp. and Routing" for example.

Categories