Accessing data from 2 datasets in a Tablix

• power.ravi2000

  SSC-Addicted

  Points: 483

  More actions

  August 25, 2015 at 8:38 pm

  #320881

  Hi,

  I have to create tablix report using data from 2 datasets. The data source for one of the dataset, DataSet1 is Microsoft SQL Server and the data source for the other dataset, DataSet2 is Excel.

  I have to pic 3 columns from DataSet1 and one column from DataSet2.

  I tried using a lookup function

  Expression: =Lookup(Fields!ProgrammerName.Value,Fields!ProgrammerName.Value,Fields!Skill.Value, "DataSet2")

  The above expression is throwing #Error on that column in the output

  Any suggestion what should I do?

  Thanks

• power.ravi2000

  SSC-Addicted

  Points: 483

  More actions

  August 26, 2015 at 9:05 am

  #1822521

  I think the issue is not the lookup, but the excel data source which probably have to read differently in the lookup.

  I am not getting any error message. I am getting warning message and also the column where Excel data needs to shown is showing #Error.

  The warning message is

  Warning 1 [rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox6.Paragraphs[0].TextRuns[0]’ contains an error:

  Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException_ComparisonError' was thrown.

  H:\SomePath\Report1.rdl 0 0