writing command in sql to set condition to prevent reading of records when params 1, 2, 3 are null. Section in rpt is set conditionally to return a message to user that one param must be used but I'd like to prevent command from reading records also - would this be a case statement or ?
Two separate variables before reading records:
X = number of parameters populated
Y = if X>=2 then TRUE
IF X = FALSE, can I prevent the command from being executed? I don't want the report to return data using the command if user has not populated 2 or more parameters. (Command contains all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.