Warnings and error Messages.... SSRS 2008
I get about 12 messages like below with different Textbox78, textbox 86,textbox 90 so on... My report runs fine but i get these messages in the warning section.. ANy idea whats going on ?????????
Warning 6 [rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox78.Paragraphs[0].TextRuns[0]’ contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null. C:\Users\mohiuddinf\Documents\Visual
Studio 2008\projects\RELEASE _INVENTORY\RELEASE _INVENTORY\RELEASE_INVENTORY_NOT_SHIPPED.rdl 0 0 FM
January 27th, 2011 1:06pm
Hi Farhan1,
This is expression issue which you have used in TextBox78, check whether you handling null values like
=IIF(IsNothing(Fields!DataSetField.Value),"NULL",Fields!DataSetField.Value).
Post the expression to suggest better way.Nanda
Free Windows Admin Tool Kit Click here and download it now
January 28th, 2011 1:02am
Hello Nanda,
Here`s the expression i am using.
=Fields!CONTACTNUMBER.Value +
" - " + Fields!COMPANYNAME.ValueFM
January 28th, 2011 1:40pm
Hi Farhan1,
Try to modify your expression to this =IIF(IsNothing(Fields!DataSetField.Value),"NULL",CStr(Fields!CONTACTNUMBER.Value) & " - " & CStr(Fields!COMPANYNAME.Value))Challen Fu [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 10:29pm