title: Reporting Services - translating labels into different languages
body: <p>I'm finishing up my reports in my SQL Server 2008 Reporting Services project, and as one of the last steps, I need to make things translateable.</p>
  
  <p>Since I have a bunch of reports, and they all share some identical labels, I decided to put all those labels I need to show into a SQL Server table, and I am surfacing that contents as a DataSet <code>dsReportLabels</code> in my reports.</p>
  
  <p>This DataSet basically contains two fields: <code>LabelName</code> is the name of the label (e.g. "Count of items"), and <code>Caption</code> contains the text in the chosen language to be shown on the report. </p>
  
  <p>But now here comes my mental block: how do I assign the <code>dsReportLabels.Caption</code> value to a e.g. textbox, based on the <code>dsReportLabels.LabelName</code> ?</p>
  
  <p>So I need something like (pseudo-LINQ statement):</p>
  
  <pre><code>Textbox1.Value = from dsReportLabels 
                   where LabelName = "some value" 
                   select Caption;
  </code></pre>
  
  <p>but how do I express that in a Reporting Services code snippet? </p>
  
  <p>I know how to reference things like <code>Parameters!MyParameterName.Value</code> and so on - but that doesn't really work here when I'm trying to extract a value from one column of the DataSet, given the value of the other column in that DataSet.</p>
  
  <p>I bet this is totally easy to do in the end.... just can't seem to wrap my head around this right now.... anyone out there know how to do this?</p>