Trigger user query with variable with Macro Universal Function

Respondida

Jay Cheah

• 25 de junio de 2016 07:23

 I want to trigger a user-query that contains variables after a user has tabbed away from a UDF. 

At the moment, I can successfully trigger the user-query, that's simple enough, but I cannot seem to transfer the data that the user has just keyed into the UDF into the user-query input box

The user-query looks like the following:

Declare @JobNum varchar(20)
Set @JobNum = (select min(S0.U_CBS_Job_No) from ORDR S0 Where S0.U_CBS_Job_No >= [%0])

SELECT DocNum, CardName, U_CBS_JobAddress, U_CBS_Job_No FROM ORDR WHERE U_CBS_Job_No = @JobNum

Vote

0

• Comentario oficial

  

  Naama Aharoni

  • 27 de junio de 2016 15:23

  Hi Jay,

  You should create this query as an SQL report UF which should provide with more formatting options. One of them is to define the [%0] variable input as an SQL query - that query should be taking the value of the UDF.

  There is no need for a macro in that case. You can link the SQL Report UF as the result of your validation.

  Thanks, Naama

Iniciar sesión para dejar un comentario.