SSRS execution warning message

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  January 13, 2014 at 5:28 am

  #284441

  Hi

  When I execute my SSRS report, I am getting a warning message as below:

  Warning1[rsRuntimeErrorInExpression] The Value expression for the textrun ‘studyCode.Paragraphs[0].TextRuns[0]’ contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.C:\Reports\SpecimenLocalisation\DosePreparationReport.rdl00

  How to avoid this warning message popping up?

• David Burrows

  SSC Guru

  Points: 65142

  More actions

  January 13, 2014 at 7:20 am

  #1679578

  What is the expression that is failing?

  Far away is close at hand in the images of elsewhere.
  Anon.

• podmate

  SSCommitted

  Points: 1676

  More actions

  January 13, 2014 at 9:46 am

  #1679639

  I have run into this before and it was because the field in my report could not handle the NULL value.

  Use either IsNULL or Coalesce in SQL or IsNothing in SSRS to take care of the NULL values.