Wednesday, March 21, 2012

Multiple expressions.

Good Morning all.

Is it possible to put multiple expressions in one cell.

Here is an example of the expressions I'm using. I'm currently having to put them horizontally in a seperate cell.

=Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "Y", 1, Nothing))

=Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "N", 1, Nothing))

=Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "NA", 1, Nothing))

Desired output will look sim to this in one cell

Y = 5

N = 3

NA = 0

Thanks,

Rick

Yes you can use line feed and carriage return characters like this to achieve your result:

="Y = " & CStr(Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "Y", 1, Nothing))) & Chr(10) & Chr(13) &

"N = " & CStr(Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "N", 1, Nothing))) & Chr(10) & Chr(13) &

"NA = " & CStr(Count(IIf (Trim(Fields!NOB_Pickup_L_D_T.Value) = "NA", 1, Nothing)))

Shyam

sql

No comments:

Post a Comment