How can i do an LB: Macro from a SQL Report on the B1 Dashboard ?

In B1 Dashboard you can host SQL Reports, but many ask us how they can reference the values of that SQL Report when doing LB: Golden arrows (aka where the action of a Golden Arrow is macro that custom open something).

The answer is quite simple. You just do the same as if it was a normal SQL Report on an SAP screen.

To reference it the syntax needs to be $[$BOY_1.<ColName>.0]

NB: It is only possible to read values in a B1 Dashboard SQL Report. You can't set values in them

Here is an example (image is high-resolution click link below to see in high resolution):