skgudi2009 (2/10/2013)
I want to add this expression in SSRS 2008R2 For Column HeadingIf {Reportname.value} = 'ABC' And {Reportname.value} = 'S' Then
'Amount1'
Else If {Reportname.value} = 'BAC' Then
'Amount2'
ELSE If {Reportname.value} <> 'ABC' AND {Reportname.value} <> 'BAC' Then
'amount3'
Else
'amount3'
i have added like this
=Switch(Fields!Field.Value = "ABC" And Fields!Field.Value = "S" , "Amount1",
Fields!Field.Value = "BAC" ,
"Amount2",
Fields!Field.Value <> "ABC" AND Fields!Field.Value <> "BAC",
"Amount3","amount3")
But error is comming for column heading #error
please help to adds this for column heading
Well, your Pseudo code doesn't make any logical sense, so why don't you try explaining what you want in natural language?
If {Reportname.value} = 'ABC' And {Reportname.value} = 'S' Then
Reportname.value cannot equal both ABC and S , can it?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);