Get the value from dialogue form to sql statement
I have a problem about getting a value from dialogue form to sql statement.
When I add a parameter to create a data set, I choose expression -> dialogue controls -> [textbox1.text] from the list.
After that, I preview it, a error(parameter: error BC 340034: missing right bracket ']' ) stops it . How can I solve it?
When I add a parameter to create a data set, I choose expression -> dialogue controls -> [textbox1.text] from the list.
After that, I preview it, a error(parameter: error BC 340034: missing right bracket ']' ) stops it . How can I solve it?
Comments
Don't use square brakets when referring to the report objects. Brakets are needed for data columns, totals, system variables, and report parameters.
It works! Thanks so much