Expression for Color property

I keep getting a message when setting the expression for the color property.
When I exit the expression builder an error message is displayed showing the
expression and "not a valid color". I have tried numerous IIF but cannot get
past the error.
IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","Red","Green")
What am I missing? Thanks in advance...Make sure you put a = sign before IIF
so the expression should be
=IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","Red","Green")
Hope this helps
RP
"Stanley Hammer" wrote:
> I keep getting a message when setting the expression for the color property.
> When I exit the expression builder an error message is displayed showing the
> expression and "not a valid color". I have tried numerous IIF but cannot get
> past the error.
> IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","Red","Green")
> What am I missing? Thanks in advance...|||Thanks, that worked great.
"RP" wrote:
> Make sure you put a = sign before IIF
> so the expression should be
> =IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","Red","Green")
> Hope this helps
> RP
> "Stanley Hammer" wrote:
> > I keep getting a message when setting the expression for the color property.
> > When I exit the expression builder an error message is displayed showing the
> > expression and "not a valid color". I have tried numerous IIF but cannot get
> > past the error.
> >
> > IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","Red","Green")
> >
> > What am I missing? Thanks in advance...

expression builder switch()

Via the Expression Builder, I'm using the switch() program flow function to handle my data. I can't seem to figure out how to do the "else" or "default" part of it. Anyone have a clue? Ex:

Switch(
Fields!test.value = 1, "One",
Fields!test.value = 2, "Two",
Fields!test.value = 3, "Three",
)

But what if Fields!test.value is not either 1,2, or 3, how would you set the "else" or "default" part within the switch statement?

Add a condition at the end which always evaluates to true.

Switch(
Fields!test.value = 1, "One",
Fields!test.value = 2, "Two",
Fields!test.value = 3, "Three",
1=1, "Default"
)

Expression Builder question

Hi all of you,

When you're making expressions with your own variables and system variables and so on. How could I see the contents for each variable?

When you have an expression like this:

"Cargas de Hacienda. " + SUBSTRING( @.[System:ackageName], 7,20) + " "

You can perfectly click above "Evaluated value" and see the resutl but I mean, individually over each variable on the variables listview is not possible.

Thanks for any input or advice,

Enric

There is a Variable window. To access the Variables Window, select from main menu View->Other Windows->Variables or right-click in the design pane and select Variables.

|||

Hi,

Thanks for your answer. I've already knew it. Issue comes when you have at the same time Expression Builder window: you can conmute between them.

|||2 ideas: a)make Variables Window floating and adjust Value column width or b)open same

solution in separate Visual Studio window.

|||

Thanks man.

Express Edition and Report Builder

Hi all,
Little question for you all: does the SQL express (Advanced) edition come
with end user report builder tools? Will it be possible for an end user to
build reports itself?
Thanks in advance,
PeterNo, the semantic modelling tool which builds the report models used by
Report Builder is not included in SQL Server 2005 Express, even with
the "Advanced Services" add-on, which gives you some of Reporting
Services, just not all of it.
-Eric
On Thu, 17 Aug 2006 16:53:14 +0200, "Peter Bons" <joepie@.blakjsd.bl>
wrote:
>Hi all,
>
>Little question for you all: does the SQL express (Advanced) edition come
>with end user report builder tools? Will it be possible for an end user to
>build reports itself?
>Thanks in advance,
>Peter
>