Trigger user query with variable with Macro Universal Function Respondida

Jay Cheah

 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

Comentarios

1 comentario

Fecha Votos
  • Comment author
    Naama Aharoni
    • Comentario oficial

    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.