title: Adding static data to report builder to use in report
body: <p>I am using report builder 3.0 to create reports in a vendor's environment where I only have access to their data sources.  We have static data that we need to use in conjunction with the datasets we are creating from their models and I am trying to figure out how to add our data to a report to use for looking up values.</p>
  
  <p>For Example:</p>
  
  <p>The data set has AccountNo, OrderNo, ItemNo, Quantity, etc.
  I need to be able to show some attributes about the ItemNo, like ItemName, ItemCost, ItemValue, etc. </p>
  
  <p>I would like to have a dataset I can lookup against to get these values, but the only way I can get this to work is to create a report code function with hundreds of thousands of IF statements:  IF ItemNo = "12345" Then ItemName = "XYZ Product"</p>
  
  <p>This is slow and cumbersome to say the least.  If the data sources were under my control, I could simply add a table in SQL, but I cannot in this environment.  I have even tried linking to external datasource and that is not allowed by the environment.  I am looking into creating some kind of XML data or trying to add data directly to the RDL, but I am running out of options.</p>
  
  <p>Does anyone know of a any way to add a set of data or create an embedded dataset that contains static values.  Any help would be greatly appreciated.</p>
  
  <p>Thank you in advance,
  Eric.</p>