Help with Dynamic Row Syntax

Respondida

Rob

• 30 de mayo de 2016 08:46

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!

Vote

0

• Comentario oficial

  

  Yaremi Miranda Lopez

  • 31 de mayo de 2016 16:02

  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.
• 

  Rob

  • 1 de junio de 2016 01:31

  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,

   
• 

  Yaremi Miranda Lopez

  • 15 de junio de 2016 14:34

  Hello Rob, now with the correct syntax, you can delete the .FOCUSED it is not needed.
• 

  Rob

  • 16 de junio de 2016 01:16

  Perfect, thank you very much for the help!

Iniciar sesión para dejar un comentario.