Hiddenm parameters in functions
I am using a custom function in the query to define a dataset for a report. The function has parameters that are defined in the query. When testing the function I passed specific values into the function. When I changed the specific values
to @ParameterValues the function and report worked as desired. However, two of the parameters' values are defined by a query and are not selected by the user in the typical drop list selection process. To insulate these parameters from the user
I defined them as hidden and used default values defined by the dataset query. Again, this worked with specified values. However, when the parameters are defined as hidden with default values defined through a query I get error messages related
to defining the hidden parameters as scalar variables. Are my expectations for using parameters in a function that are hidden but provided as default values with a query not consistent with the capabilities of Reporting Services?
If not, any suggestions to accomplish my intent are appreciated.Leo
December 7th, 2010 6:54pm
Hi Leo,
Try to change it from Hidden parameter to Internal. If it does not wrok, describe your expectation in more details. In addtion, your another thread
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/16985ef8-5cbd-40b6-82f3-a91469661ed7 has no issue decription, please either add content or delete it.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
December 8th, 2010 10:02pm