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

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

|||This is perfect! Thanks|||

Please mark my post as answer. Thanks.

Shyam

Multiple Expressions in Precedence Constraints

Is it possible in a precedence constraint to have multiple expressions evaluated? IE

Operation set to Expression and expression to evaluate is: @.File = x or @.File = y

Thanks

(@.File == "x" || @.File == "y")|||

I am an idiot!

Thanks

|||If this was correct for you, please mark this thread as answered.

Multiple datasets

I have an area of my report that needs multiple data sets to be used to
populate the area. I keep getting the error "Report item expressions can only
refer to fields wtihin the current data set scope". Does anyone know how to
make the area allow me to use one data set in one row and one in data set in
the other? I have tried a table within a table, a list within a table....I
cannot find the fix to this problem. Please help!Have a look at subreports.
"KimB" <KimB@.discussions.microsoft.com> wrote in message
news:C6D864D3-BED0-48D2-BB39-C4C642A2B9C0@.microsoft.com...
> I have an area of my report that needs multiple data sets to be used to
> populate the area. I keep getting the error "Report item expressions can
only
> refer to fields wtihin the current data set scope". Does anyone know how
to
> make the area allow me to use one data set in one row and one in data set
in
> the other? I have tried a table within a table, a list within a
table....I
> cannot find the fix to this problem. Please help!|||Thank you. I will try.
"AshVsAOD" wrote:
> Have a look at subreports.
> "KimB" <KimB@.discussions.microsoft.com> wrote in message
> news:C6D864D3-BED0-48D2-BB39-C4C642A2B9C0@.microsoft.com...
> > I have an area of my report that needs multiple data sets to be used to
> > populate the area. I keep getting the error "Report item expressions can
> only
> > refer to fields wtihin the current data set scope". Does anyone know how
> to
> > make the area allow me to use one data set in one row and one in data set
> in
> > the other? I have tried a table within a table, a list within a
> table....I
> > cannot find the fix to this problem. Please help!
>
>