How can I include two expressions in one textbox?

Here are the expresstions:
=(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
Fields!Transfer.Value + Fields!Spent.Value)
=iif(fields!Purchase.Value=0, "black", "red")
Thanks,
TrintIt appears that your expressions are doing two different things. I will
infer from this that you want the first expression to yield the value, and
the second to yield the font color.
Therefore, you would set the "Value" property to the first expression. Then
under the font settings, set the font color equal to the second expression.
Brian
"trint" <trinity.smith@.gmail.com> wrote in message
news:1122298713.103364.68910@.g14g2000cwa.googlegroups.com...
> Here are the expresstions:
> =(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
> Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
> Fields!Transfer.Value + Fields!Spent.Value)
> =iif(fields!Purchase.Value=0, "black", "red")
> Thanks,
> Trint
>|||But, how do I add a second expression?
=(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
Fields!Transfer.Value + Fields!Spent.Value) +
=iif(fields!Purchase.Value=0, "black", "red") ?
I know that doesn't work, but that is what I mean.
Thanks,
Trint|||Write this in Purchase Textbox -> Rightclick -> Expression
=(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
Fields!Transfer.Value + Fields!Spent.Value)
go to Purchase Properties, click on FontColor -> Choose Expression and write
the foll.
=iif(fields!Purchase.Value=0, "black", "red")
Hope it helps.
Girija
"trint" wrote:
> But, how do I add a second expression?
> =(Fields!Purchase.Value + Fields!Matrix.Value + Fields!QualiFly.Value +
> Fields!Dist.Value + Fields!SM.Value + Fields!BreakAway.Value +
> Fields!Transfer.Value + Fields!Spent.Value) +
> =iif(fields!Purchase.Value=0, "black", "red") ?
> I know that doesn't work, but that is what I mean.
> Thanks,
> Trint
>