Line loop on SQL Report
Answered
Hello,
I'm new to B1UP and learning.
I created a sql report with first column (Checkbox) add a function button that trigger a Line loop to get all lines that have a check mark . That line loop open a macro to update a sales order, up to here all is fine. My problem is with ether the lineloop or macro it always ignore the last line(yes the option is off). When I click on the button in debug mode I see the first attemp the sales order is empty then the second open correctly and the third is fine too, but I have selected 3 sales orders the last one is not processed.
anyone had that problem before ?
Thank you
-
Official comment
Hello,
Normally the line loop doesn't ignore the last line in reports, so if you want us to investigate further please contact your local partner.
As a workaround, yes, you can use the extended Boyum syntax and read the last line using $[$item.colum.type.line] where line can be replaced with the command LAST.
-
Make the [fainal result value] blank
and then in the Macro write as follows;
@STORE1=$[$BOY_1.DocNum.String]
OpenForm(17|@STORE1);
Activate();
......
I am not sure ,please have a try.
Please sign in to leave a comment.
Comments
2 comments