Showing posts with label zero. Show all posts
Showing posts with label zero. Show all posts

Monday, March 19, 2012

How manipulate the color property of a table cell

Hi

I am trying to change the colour of table cell if it's value is less than zero.

I know how to use IIF and have it working fine elsewhere.

My challenge is that I want to set the IIF in the color property of one cell of a table.

I can not seem to get to the property window for a cell. I can get to it for a row or a column or a group but not an individual cell. Any one know how I can do this?

The reason I need to do this is that the the column of interest has a group and a detail and I need to set the IIF expression at detail and group level. The detail works fine but the group needs the IIF with SUM and I need to set it at that level.

Thanks

e.g I want:

-60


-40

-20

but get:

-60


-40

-20

Just select the individual textbox in the table cell and look at the properties window (usually in the right bottom corner of the VS environment). You can set the color expression directly there.

-- Robert

Monday, March 12, 2012

how long does it take to create a database in 2005 ?

I thought database creation was pretty fast in SQL 2005 and there was no
zero initialization
I ran a create database to create one with an initial size of 25GB for data
file and 25 GB of log file and it ran for 11 mins.
I have the dev edition. Could that be the reason ?The service account need certain Windows privileges to do fast init. Also fast init is only for data
files (not log files). I've mentioned a few words about it at:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
"SQL Server 2005:
SQL Server 2005 has "instant file initialization" which means that database files can be created and
also grow very fast since Windows doesn't "zero out" the data in the database file. Instant file
initialization is only available for data files, not log files. Also, instance file initialization
requires that the service account for the SQL Server service has the SE_MANAGE_VOLUME_NAME windows
privilige, which can be assigned using the Perform Volume Maintenance Tasks security policy. This is
by default only granted to Administrators."
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.hotmail.com> wrote in message news:eiiizunkHHA.4872@.TK2MSFTNGP03.phx.gbl...
>I thought database creation was pretty fast in SQL 2005 and there was no zero initialization
> I ran a create database to create one with an initial size of 25GB for data file and 25 GB of log
> file and it ran for 11 mins.
> I have the dev edition. Could that be the reason ?
>
>