Thursday, January 27, 2011 5:47 PM
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.TextRuns’ 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
Friday, January 28, 2011 5:43 AM
This is expression issue which you have used in TextBox78, check whether you handling null values like
Post the expression to suggest better way.
- Proposed As Answer by Challen FuModerator Thursday, February 03, 2011 3:13 AM
Friday, January 28, 2011 2:20 PM
Here`s the expression i am using.
" - " + Fields!COMPANYNAME.Value
Thursday, February 03, 2011 3:13 AMModerator
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.
- Marked As Answer by Farhan1 Thursday, February 03, 2011 2:58 PM
Monday, July 02, 2012 4:09 AM
i have tried it but nothing solves my problem..this is an error.i delete the report and redo it again but i got the same error.i receive Textbox5 but when i click on that error it takes me to that report but i cant have any textbox5.
[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox5.Paragraphs.TextRuns’ contains an error: The query returned no rows for the dataset. The expression therefore evaluates to null.
my table in Design looks like this
when i run the report i got this
the cat doesn't display on my Table...where i got this error
thanks in advance