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 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
Free Windows Admin Tool Kit Click here and download it now
January 27th, 2011 10:02pm

Hello Nanda, Here`s the expression i am using. =Fields!CONTACTNUMBER.Value + " - " + Fields!COMPANYNAME.ValueFM
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.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 7:29pm

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

Other recent topics Other recent topics