Problem to use @STORE Syntax on P&D

Renan Andrade de Castro

• May 24, 2024 09:32

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:

 

Vote

0

• 

  Geoff Booth

  • May 24, 2024 13:02

  Try changing the SQL to :

   

  SQL: SELECT '@STORE71' FROM Dummy

Please sign in to leave a comment.