sql server reporting services: Adding an Expression to a Report Text Box -- sql server reporting services

Re: Adding an Expression to a Report Text Box

EMartinez
6/6/2007 12:00:00 AM

sql server reporting services:

On Jun 6, 6:54 am, Mick Egan <MickE...@discussions.microsoft.com>
[quoted text, click to view]

Are you sure that Fields!BNFITAMT_5.Value is not nothing? The
expression seems to be fine otherwise.

Regards,

Enrique Martinez
Sr. Software Consultant

Re: Adding an Expression to a Report Text Box

Mick Egan
6/7/2007 2:53:01 PM

Enrique,

When I swap places with the "Nothing" value it returns all the values, so
the calculation is valid.

Mick
--
Mick

[quoted text, click to view]

Re: Adding an Expression to a Report Text Box

Lisa Slater Nicholls
6/8/2007 3:12:15 PM

Even though Fields!USCATVLS_1.Value returns "External", or appears to, in
the report, is it possible that there are actually some trailing spaces?

IOW, what if you used the following condition in your expression:

Fields!USCATVLS_1.Value.Trim() = "External"

.... or something like that?

[quoted text, click to view]

Re: Adding an Expression to a Report Text Box

Mick Egan
6/10/2007 7:02:00 PM

Lisa / Enrique,

The .Trim() isn't recogonised, so I tried (Trim(Fields!USCATVLS_1.Value) =
"External", this didn't work either.

So I tried:
Setting the RTRIM on the Dataset and this worked, I needed to add the field
as an expression.
i.e. RTRIM(IV00101.USCATVLS_2) AS CAT2

Thanks heaps for pointing me in the right direction.

Mick

--
Mick

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.