title: Reporting Services problem. Forward dependencies are not valid
body: <p>I have a problem with a Reporting Services report. My report has two datasets, one that fetches the actual report data and one that fetches translated resource strings for displaying wherever literal text is used on the report. This dataset requires three parameters, a language set id, a language code and a string to match against resource names.</p>
  
  <p>Following an example I found <a href="http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a7d59224-0ee5-491e-883b-2e5fcb3edeab" rel="nofollow">here</a> (the reply by Miguel Catalão) I have created a multivalue parameter @Resources that will be populated from the resource dataset and a code function that looks up specific values from the multivalue query. This function will then be called from expressions wherever literal strings are used.</p>
  
  <p>I think that this should work but I have run into a problem that I can't quite figure out a workaround for. There is a dependency problem in the @Resources parameter being dependent on the Resources dataset which in turn is dependent on three parameters; @LanguageSetID, @LanguageCode and @ResourceNameLookup. I have read that the order of declaring parameters is important so I have made sure that the last three parameters appear above the @Resources one and that all three of them have default values that will result in data being retrieved by the dataset.</p>
  
  <p>Yet I am still getting the following errors when previewing the report; any advice or guidance would be most appreciated.</p>
  
  <pre><code>The report parameter ‘Resources’ has a DefaultValue or a ValidValue that depends on the report parameter “LanguageCode”. Forward dependencies are not valid.
  The report parameter ‘Resources’ has a DefaultValue or a ValidValue that depends on the report parameter “ResourceNameLookup”. Forward dependencies are not valid.
  </code></pre>