In the search form of a tabular report, I pass as a external parameter called [@prod] on exit. I want to know how to use the parameter con the formula (SELECT Sum(Entrada) FROM Cuadre_Indigo WHERE Producto=[@prod] ) -
(SELECT Sum(Salida) FROM Cuadre_Indigo WHERE Producto=[@prod] )
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
JORGEYL1997
In the search form of a tabular report, I pass as a external parameter called [@prod] on exit. I want to know how to use the parameter con the formula (SELECT Sum(Entrada) FROM Cuadre_Indigo WHERE Producto=[@prod] ) -
(SELECT Sum(Salida) FROM Cuadre_Indigo WHERE Producto=[@prod] )
Also ignore the criteria if its null.
The formula doesn't seem to work
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.