Help with Dynamic Row Syntax Respondida
Im trying to get the Dynamic syntax working for a sales history by warehouse SQL Report i have been working on.
For example, I click on the “7” under December, I want to see all the sales for December for Warehouse 05.
The highlighted row is what I have added this morning. If I put this into the SQL Management Studio and change the value to “05” it works fine.
When I try to run the Golden Arrow, I get the below message. If I change the “Focused” to “2” to force the row I get the same error.
I have also tried to change the “warehouse” to the Database column name “whscode” but same result.
Last time i had this problem it was to do with the case of te text but i've tried every variation possible so not sure what i have done wrong.
Thanks!
Comentarios
4 comentarios
Hello Rob,
B1UP (or at least this UF type) is case sensitive, can you verify that the column name is not witha capital letter? "Warehouse" ? It has to be exactly the same way the Id says it is.
Hello Yaremi,
That has worked, thank you for that! However there is still a slight issue.
I have found that .FOCUSED will not return the row I need. It will always return Row 0.
The only way I seem to be able to get it to work is to change .FOCUSED to .SELECTED, click the row then select the Golden Arrow. It adds a few steps to the process. Is there a way around this? Perhaps something like .HOVER? I have looked through the documentation but could only see 5 options for .ROW.
Or is there a reason why .FOCUSED isn't working?
Thanks,
Hello Rob, now with the correct syntax, you can delete the .FOCUSED it is not needed.
Perfect, thank you very much for the help!
Iniciar sesión para dejar un comentario.