Right Click Row No in SQL Report Respondida

Bo Peng

Hello Expert:

   I have a scenario where I need to use the right-click $[CURRENT_ROW] in the resulting SQL Report. However, when I put the value there it give me error message. If I put in select statement I get 

select '$[CURRENT_ROW]'. I just get the text $[CURRENT_ROW] in the screen. 

Any Ideas? Thank you! 

Bo

Comentarios

6 comentarios

  • Comment author
    Rasmus Jensen

    Moved to Community Q&A as this is not a feature request

    0
  • Comment author
    Bo Peng

    Thank you, Rasmus,

    0
  • Comment author
    Nadav Caridi

    Hi, 

    not sure but maybe 

    $[$item.col.0.Selected] 

    that works ?

    update with the dynamic syntax of your report columns ..

    0
  • Comment author
    Bo Peng

    Hey Nadav:

        The line has to be selected on the document, but this is a nice workaround. Thank you so much., 

    0
  • Comment author
    Rasmus Jensen

    If selecting the line is an annoyance then try using the .FOCUSED instead of .SELECTED

    0
  • Comment author
    Bo Peng

    Hello Rasmus:

       Unfortunately, this is on a closed AP invoice, so focused does not work. It will return line 1 regardless of which line I pick.

       Thank you.

    Bo

    0

Iniciar sesión para dejar un comentario.