I am attempting to add parameters to a query that is run via ODBC. When I use a "?" in my query to indicate a parameter, it gives me an error but seems to work ok, but if I change the name of the parameter it loses the connection between the query parameter and the report parameter. What is it that connects query parameters to report parameters? Also, since a query parameter is defined by a single "?" with no variable name, what do you do if you want to prompt once for a value, and then use it multiple times in a query?
Report parameters (defined at the report level) and query parameters are independent. By default, we will generate 1 report parameter for each query parameter we detect but the binding is up to you. If you go to the data tab and bring up the dataset properties (the elipsis beside the dataset drop down), you can see the binding. Since ODBC does not support named parameters, you need to make sure that the order of the parameters still maps to the correct report parameters if you change the query.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment