I'm trying to add Item comments to a Report however the results are coming back blank.
This is my Data set Designer
These are the properties between the Comment Line and Item.
In my code the recCommentLine isn't returning anything it should. RecCommentLine is referring to 'Comment Line' Table.
recCommentLine.RESET;
recCommentLine.SETRANGE("Table Name",recCommentLine."Table Name"::Item);
recCommentLine.SETRANGE("No.", Item."No.");
recCommentLine.SETRANGE("Comment Type", recCommentLine."Comment Type"::LabelRibbon);
IF "Comment Line".FINDLAST THEN
gstrRibbonType := recCommentLine.Comment;
"Comment Line".RESET;
"Comment Line".SETRANGE("No.", Item."No.");
"Comment Line".SETRANGE("Comment Type", "Comment Line"."Comment Type"::LabelIP);
IF "Comment Line".FINDFIRST THEN
gstrIP := "Comment Line".Comment;
"Comment Line".RESET;
"Comment Line".SETRANGE("No.", Item."No.");
"Comment Line".SETRANGE("Comment Type","Comment Line"."Comment Type"::LabelPrinter);
IF "Comment Line".FINDFIRST THEN
gstrPrinter := "Comment Line".Comment;
"Comment Line".RESET;
"Comment Line".SETRANGE("No.", Item."No.");
"Comment Line".SETRANGE("Comment Type", "Comment Line"."Comment Type"::LabelLocation);
IF "Comment Line".FINDFIRST THEN
gstrLocation := "Comment Line".Comment;
