Link fields of the same table

MarkReedaMarkReeda Posts: 3Member
Good morning everybody,

I'm developing a RDLC report (a Sale) and I'm stuck in linking rows of the same order: I will explain it more in details. I have a particular "function" that for specific articles in an order, will generate two additional rows connected to that line. For instance, let's call the article "article1"; when I insert this in an order, they are generated two rows (artDetails1 and artDetails2) linked to "article1".How could I reference the article? Simply with a field called "linked to line number". In substance, I have written this piece of code:


Tax.RESET;
Tax.SETRANGE(Tax."No.","Sales Line"."No.");
Tax.SETRANGE(Tax."Linked to Line No.","Sales Line"."Line No.");
IF Tax.FIND THEN;


Where "TAX" is the "Record Variable" that refers to Sales Line table. I'm trying to "link to the same table", I think the approach could be correct. Anyway, I cannot see any result.
What I would like to obtain is a report in which for all the lines of the "Sale Order" I have the article with its relative description contained in the rows "artDetails1 and artDetails2) .

Is anyone able to explain me how to proceed?


Thanks in advance

Best Answer

Answers

  • Slawek_GuzekSlawek_Guzek Posts: 1,488Member
    It looks like you have duplicated the standard Extended Text functionality pretty much.

    The Extended text works by inserting sales lines with Type = '' after the line with the item for which extended text is generated. This way the extra description lines are visible naturally on all pages and reports.

    If your solution is different as it needs to keep some other details than just a description then you need to modify the report dataitem structure, insert your table a level down from the Sales Line, and link both tables there
    Slawek Guzek
    Poszukuje programistow znajacych Microsoft Dynamics NAV
  • MarkReedaMarkReeda Posts: 3Member
    Unfortunately I don't need simply a description, I should take some other "parameters" in the future. Then I cannot do what you suggested, 'cause I have the DataItem Sales Line, then at the same level an "Integer for the Loop" with all the fields. Where can I insert this new item? If you put this one level down the "loop" you'll receive the message that "the father should be a DataItem and not a Column"
  • MarkReedaMarkReeda Posts: 3Member
    Great Sir!! It works! Thank you very much!
  • krikikriki Posts: 8,479Member, Moderator
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
Sign In or Register to comment.