Right Click Row No in SQL Report

Respondida

Bo Peng

• 26 de junio de 2020 12:14

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

Vote

0

• 

  Rasmus Jensen

  • 26 de junio de 2020 12:18

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

  Bo Peng

  • 26 de junio de 2020 12:58

  Thank you, Rasmus,
• 

  Nadav Caridi

  • 26 de junio de 2020 14:06

  Hi, 

  not sure but maybe 

  $[$item.col.0.Selected] 

  that works ?

  update with the dynamic syntax of your report columns ..
• 

  Bo Peng

  • 28 de junio de 2020 02:19

  Hey Nadav:

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

  Rasmus Jensen

  • 28 de junio de 2020 04:37

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

  Bo Peng

  • 29 de junio de 2020 02:05

  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

Iniciar sesión para dejar un comentario.