October 3, 2013 at 12:29 pm
In a ssrs 2008 r2 report, I have found the following expression and I would like you to explain the following code to me:
=IIF(Lookup(Fields!SK.Value, Fields!SK.Value, Fields!StCount.Value, "DS_StCount") = Nothing, 0, Lookup(Fields!SK.Value, Fields!SK.Value, Fields!StCount.Value, "DS_StCount"))
I know that a lookup function compares the first values to see if they are equal, and if so they value in the third column is returned. However I do not know what this enire
iif statement is doing. Can you explain it to me?
October 3, 2013 at 12:36 pm
It is looking up the value in the SK column from the bound dataset to the "DS_StCount" dataset and if it does not return a value, it uses zero.
The lookup function is a bit like a left outer join in this case between the active groups dataset and "DS_StCount" on SK.value.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
October 3, 2013 at 2:03 pm
What do you mean by the 'bound dataset'?
October 3, 2013 at 3:15 pm
the report item containing the formula must exist within a section off the report that is bound / linked to a dataset
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply