Problem to use @STORE Syntax on P&D

Hello,

I'm having an issue to use the parameter set of P&D, When I set one of the parameter on the Crystal Configuration to consume the value of a Variable using the syntax of the documentation, don't works, I already checked all other configurations and it's possible to understand that the syntax is not trying to get the value into the Store used:

The only problem is the VisOrder@ Parameter not receiving the data of the @STORE71, here is the syntax:

 

SQL: SELECT '@STORE71' as Dummy

 

When I changed the value of it for a fixed number the layout works, I already debugged to check the data into @STORE71 and it's correct!

I Already tryed changing the parameter data type to Number and string but both i had the same error:

 

Comentarios

1 comentario

  • Comment author
    Geoff Booth

    Try changing the SQL to :

     

    SQL: SELECT '@STORE71' FROM Dummy

    0

Iniciar sesión para dejar un comentario.