January 13, 2014 at 5:28 am
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?
January 13, 2014 at 7:20 am
What is the expression that is failing?
Far away is close at hand in the images of elsewhere.
Anon.
January 13, 2014 at 9:46 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply