Remote Support Software

Provide instant remote support to customers and employees:

Click here for a free trial

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

There is an amazing pack of free network admin tools. click here to download it






January 27th, 2011 10:06am
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

There is an amazing pack of free network admin tools. click here to download it






January 27th, 2011 10:02pm
Hello Nanda,

Here`s the expression i am using.
=Fields!CONTACTNUMBER.Value +


" - " + Fields!COMPANYNAME.ValueFM

Need to support users over the internet? click here try our remote control online beta






January 28th, 2011 10:40am
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.

Need to support users over the internet? click here try our remote control online beta






February 2nd, 2011 7:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics