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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics