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 Error: Attempted to divide by zero.

i'm trying to calculate a percent field with the following expression and
getting the error message above:
=IIF(Fields!valorPrevisto.Value = 0, 0, Fields!valorRealizado.Value /
Fields!valorPrevisto.Value)
what am i doing wrong ?
thanks.Hi levogiro -
Check out this thread. It describes the problem and offers a couple of
solutions.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/481dcece9e84c707/d34656d64a7f39a9?q=divide+by+zero+expression&rnum=4&hl=en#d34656d64a7f39a9
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Tue, 13 Sep 2005 07:08:05 -0700, "levogiro"
<levogiro@.discussions.microsoft.com> wrote:
>i'm trying to calculate a percent field with the following expression and
>getting the error message above:
>=IIF(Fields!valorPrevisto.Value = 0, 0, Fields!valorRealizado.Value /
>Fields!valorPrevisto.Value)
>what am i doing wrong ?
>thanks.

Express 2005 - Database Diagram Error

Installed adventure works..and when creating a database diagram giving
a message says that it does not have valid owner.
The adventure works database is in SQL 2005 compatibility mode.Perhaps the database owner doesn't exist? Try below:
SELECT * FROM sys.databases AS db
WHERE NOT EXISTS
(
SELECT * FROM sys.server_principals AS sp
WHERE sp.sid = db.owner_sid
)
If above returns any rows, try changing the database to a valid login using sp_changedbowner.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141080017.869972.135450@.j33g2000cwa.googlegroups.com...
> Installed adventure works..and when creating a database diagram giving
> a message says that it does not have valid owner.
> The adventure works database is in SQL 2005 compatibility mode.
>|||The above query returns a row.
Tibor, my login is sysadmin fixed server role. I have right clicked on
the database (properties) on the file groyp it says that owner is my
windows domain login.|||Ok, so if the owner is a valid login, then the problem is somewhere else...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141137171.049927.50760@.p10g2000cwp.googlegroups.com...
> The above query returns a row.
> Tibor, my login is sysadmin fixed server role. I have right clicked on
> the database (properties) on the file groyp it says that owner is my
> windows domain login.
>

Express 2005 - Database Diagram Error

Installed adventure works..and when creating a database diagram giving
a message says that it does not have valid owner.
The adventure works database is in SQL 2005 compatibility mode.
Perhaps the database owner doesn't exist? Try below:
SELECT * FROM sys.databases AS db
WHERE NOT EXISTS
(
SELECT * FROM sys.server_principals AS sp
WHERE sp.sid = db.owner_sid
)
If above returns any rows, try changing the database to a valid login using sp_changedbowner.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141080017.869972.135450@.j33g2000cwa.googlegr oups.com...
> Installed adventure works..and when creating a database diagram giving
> a message says that it does not have valid owner.
> The adventure works database is in SQL 2005 compatibility mode.
>
|||The above query returns a row.
Tibor, my login is sysadmin fixed server role. I have right clicked on
the database (properties) on the file groyp it says that owner is my
windows domain login.
|||Ok, so if the owner is a valid login, then the problem is somewhere else...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141137171.049927.50760@.p10g2000cwp.googlegro ups.com...
> The above query returns a row.
> Tibor, my login is sysadmin fixed server role. I have right clicked on
> the database (properties) on the file groyp it says that owner is my
> windows domain login.
>

Express 2005 - Database Diagram Error

Installed adventure works..and when creating a database diagram giving
a message says that it does not have valid owner.
The adventure works database is in SQL 2005 compatibility mode.Perhaps the database owner doesn't exist? Try below:
SELECT * FROM sys.databases AS db
WHERE NOT EXISTS
(
SELECT * FROM sys.server_principals AS sp
WHERE sp.sid = db.owner_sid
)
If above returns any rows, try changing the database to a valid login using
sp_changedbowner.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141080017.869972.135450@.j33g2000cwa.googlegroups.com...
> Installed adventure works..and when creating a database diagram giving
> a message says that it does not have valid owner.
> The adventure works database is in SQL 2005 compatibility mode.
>|||The above query returns a row.
Tibor, my login is sysadmin fixed server role. I have right clicked on
the database (properties) on the file groyp it says that owner is my
windows domain login.|||Ok, so if the owner is a valid login, then the problem is somewhere else...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1141137171.049927.50760@.p10g2000cwp.googlegroups.com...
> The above query returns a row.
> Tibor, my login is sysadmin fixed server role. I have right clicked on
> the database (properties) on the file groyp it says that owner is my
> windows domain login.
>