sql server reporting services: Hi,

I have a matrix control with actiondefined on the "Data" cell of the matrix.
The action is jump to the details report. Now I have 4 parameters. Out which
2 CAN be sometimes nulls or not defined.
@month has Fields!Month.Value
@Item_Code has Fields!Item_Code.value.

I tried setting the value of these 2 parameters as:
@month : ISNULL(Fields!Month.Value)
@ItemCode : ISNULL(Fields !Item_Code.value)
But is get the error " The value expression for text box Quantity has error.
Name ISNULL not defined."
How can i assign the the value to @Month & @item_Code such that, they can
have some value or they can be nulls or they can be nothing..?

Please help.

Thanks

--

u should use
@month = iif(Fields!Item_Code.IsMissing, "", Value)

or
@month = iif(Fields!Item_Code.Value = null, "", Value)

Hi Mahesh,

In this statement @month = iif(Fields!Item_Code.IsMissing, "", Value)
Value should be Fields!Item_Code.Value or I should just write Value?
--
pmud


[quoted text, click to view]