Connect text box and drop down list parameters
Hello! I need to do the following: display information about specific organization using organization name selected in drop down list connected to parameter in dataset query. The thing is that the list of available values in drop down list is too big to work with. I need to make users be able to do some search on organization name, so that only values that contain searched text will be present in drop down list to choose from. I created parameter Organization which receives values from separate dataset, connected report data to this parameter. Then I added text parameter SearchValue and in query for Organization dataset specified usage of this parameter. When I try to run the report it brings the following error: The report parameter ‘Organization’ has a DefaultValue or a ValidValue that depends on the report parameter “SearchValue”. Forward dependencies are not valid. How can I solve this problem? Or is there any workaround to achieve the result needed some other way? Any help would be grealy appreciated!!!
November 23rd, 2011 8:46am

Hi, Change the Order of parameter i.e. Organization parameter will come second in list and searchvalue comes first. You can do it by Up, Down keys present on Report data window. Regards.
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2011 8:55am

Hi, Change the Order of parameter i.e. Organization parameter will come second in list and searchvalue comes first. You can do it by Up, Down keys present on Report data window. Regards.
November 23rd, 2011 4:48pm

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

Other recent topics Other recent topics