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.