"Bruce Johnson [MSFT]" <brucejoh@online.microsoft.com> wrote in message
news:O1EwsFWVEHA.3988@tk2msftngp13.phx.gbl...
> Are you using Fields!<FieldName>.Value in the actual RDL expression? Your
> example is using Value? For example: =iif(Fields!Quantity.Value = 32,
> "Center", "Right").
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Scott Bieker" <sbieker@yahoo.com> wrote in message
> news:5981b520.0406180613.7dfaee42@posting.google.com...
> > I am having troubles trying to make an expression work in a TextBox.
> > Can someone please provide some guidance. I am able to make
> > expressions work for most properties, but not for TextAlign. Here are
> > two examples, the TextDecoration works, but TextAlign does not.
> >
> > TextAlign
> > =iif(Value = 32, "Center", "Right")
> >
> > TextDecoration
> > =iif(Value = 32, "Underline", "LineThrough")
> >
> > The TextBox is in a Table. The resultset for the datasource returns 4
> > rows. The value is 32 in the first row and 0 in the next 3 rows. The
> > TextDecoration is Underline for the first and LineThrough for the next
> > 3. The TextAlign is Right for all rows.
> >
> > Thanks
> >
> > scott
>
>

"Scott Bieker" <sbieker@yahoo.com> wrote in message
news:eH1edD9VEHA.2816@TK2MSFTNGP11.phx.gbl...
> Just a repost of my former question. Is there something I am doing wrong
> or is there an issue with expressions in TextAlign?
>
> Thanks
>
> scott
>
> Yes, I have used many variations of Fields!<FieldName>.Value and actually
> tested using another textbox (column) in the same row/table and
referencing
> it using ReportItems!<TextBoxName>.Value.
>
> As far I can see it always has the same issue. So the sample I provided
> just
> used the Value property of the TextBox that it is associated with.
>
> The issue only occurs when using this expression in TextAlign, but not
> in TextDecoration, FontStyle or FontWeight. I use the exact same syntax
> in all of these expressions and it works for all but TextAlign.
>
> any thoughts?
>
> scott
>
> "Bruce Johnson [MSFT]" <brucejoh@online.microsoft.com> wrote in message
> news:O1EwsFWVEHA.3988@tk2msftngp13.phx.gbl...
> > Are you using Fields!<FieldName>.Value in the actual RDL expression?
Your
> > example is using Value? For example: =iif(Fields!Quantity.Value = 32,
> > "Center", "Right").
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Scott Bieker" <sbieker@yahoo.com> wrote in message
> > news:5981b520.0406180613.7dfaee42@posting.google.com...
> > > I am having troubles trying to make an expression work in a TextBox.
> > > Can someone please provide some guidance. I am able to make
> > > expressions work for most properties, but not for TextAlign. Here are
> > > two examples, the TextDecoration works, but TextAlign does not.
> > >
> > > TextAlign
> > > =iif(Value = 32, "Center", "Right")
> > >
> > > TextDecoration
> > > =iif(Value = 32, "Underline", "LineThrough")
> > >
> > > The TextBox is in a Table. The resultset for the datasource returns 4
> > > rows. The value is 32 in the first row and 0 in the next 3 rows. The
> > > TextDecoration is Underline for the first and LineThrough for the next
> > > 3. The TextAlign is Right for all rows.
> > >
> > > Thanks
> > >
> > > scott
> >
> >
>
>
>

"Brian Welcker [MSFT]" <bwelcker@online.microsoft.com> wrote in message news:<exMtm1BWEHA.2844@TK2MSFTNGP09.phx.gbl>...
> Hmmm. I can't get it to work either. I'll see what's up...
>
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Scott Bieker" <sbieker@yahoo.com> wrote in message
> news:eH1edD9VEHA.2816@TK2MSFTNGP11.phx.gbl...
> > Just a repost of my former question. Is there something I am doing wrong
> > or is there an issue with expressions in TextAlign?
> >
> > Thanks
> >
> > scott
> >
> > Yes, I have used many variations of Fields!<FieldName>.Value and actually
> > tested using another textbox (column) in the same row/table and
> referencing
> > it using ReportItems!<TextBoxName>.Value.
> >
> > As far I can see it always has the same issue. So the sample I provided
> > just
> > used the Value property of the TextBox that it is associated with.
> >
> > The issue only occurs when using this expression in TextAlign, but not
> > in TextDecoration, FontStyle or FontWeight. I use the exact same syntax
> > in all of these expressions and it works for all but TextAlign.
> >
> > any thoughts?
> >
> > scott
> >
> > "Bruce Johnson [MSFT]" <brucejoh@online.microsoft.com> wrote in message
> > news:O1EwsFWVEHA.3988@tk2msftngp13.phx.gbl...
> > > Are you using Fields!<FieldName>.Value in the actual RDL expression?
> Your
> > > example is using Value? For example: =iif(Fields!Quantity.Value = 32,
> > > "Center", "Right").
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Scott Bieker" <sbieker@yahoo.com> wrote in message
> > > news:5981b520.0406180613.7dfaee42@posting.google.com...
> > > > I am having troubles trying to make an expression work in a TextBox.
> > > > Can someone please provide some guidance. I am able to make
> > > > expressions work for most properties, but not for TextAlign. Here are
> > > > two examples, the TextDecoration works, but TextAlign does not.
> > > >
> > > > TextAlign
> > > > =iif(Value = 32, "Center", "Right")
> > > >
> > > > TextDecoration
> > > > =iif(Value = 32, "Underline", "LineThrough")
> > > >
> > > > The TextBox is in a Table. The resultset for the datasource returns 4
> > > > rows. The value is 32 in the first row and 0 in the next 3 rows. The
> > > > TextDecoration is Underline for the first and LineThrough for the next
> > > > 3. The TextAlign is Right for all rows.
> > > >
> > > > Thanks
> > > >
> > > > scott
> > >
> > >
> >
> >