Conditional formatting for missing numeric data

I created a matrix report which includes numeric data to be formatted as
currency. In cases where the data is missing, the empty cell displays "$".
If I use the iif() function for conditional formatting, it inserts the entire
expression into all of the cells. Does anyone know how I can format the
cells that do not contain any data so that nothing will be displayed?
thanks!It sounds like you need Nothing:
=iif(Fields!MyValue.Value Is Nothing,"","C0")
Put the expression in the Custom field in the Textbox Properties window.
I think you can use "". If not, choose something else.
"Anna" wrote:
> I created a matrix report which includes numeric data to be formatted as
> currency. In cases where the data is missing, the empty cell displays "$".
> If I use the iif() function for conditional formatting, it inserts the entire
> expression into all of the cells. Does anyone know how I can format the
> cells that do not contain any data so that nothing will be displayed?
> thanks!

conditional color formatting

i'm using SQL Server Reporting Services 2005 and have a simple report that
essentially pulls back a bunch of database records and displays the results
in the excel-like grid. I want to shade an entire row, based on the value
of a field contained in that row, but i can't figure out where (and how) to
do this.
any help is much appreciated..
tia
jtOn Apr 3, 6:26 pm, "JTL" <j...@.clickstreamtech.com> wrote:
> i'm using SQL Server Reporting Services 2005 and have a simple report that
> essentially pulls back a bunch of database records and displays the results
> in the excel-like grid. I want to shade an entire row, based on the value
> of a field contained in that row, but i can't figure out where (and how) to
> do this.
> any help is much appreciated..
> tia
> jt
In the Layout view, select the left-most cell in the table and click
F4 (for the Properties window). Below the Appearance property, in the
Properties window, select '<Expression...>' from the drop-down list to
the right of 'BackgroundColor.' Enter something like the following
below 'Edit Expression:'
=iif(Fields!FieldName.Value <> SomeValue, "BackgroundColorIfTrue",
"BackgroundColorIfFalse")
Then select the cell directly to the right of the left-most one and
repeat the same steps. Continue in this manner until all cells all the
way across have the same expression used.
Regards,
Enrique Martinez
Sr. Software Consultant

Conditional Cascading Parameters

Hi,
I am looking for some help with builing parameters in a report. A have a
report that displays sales persons. What I need to do is either allow entry
of the sales person number directly OR use a set of cascading parameters that
start at country, then region, then state, followed by office. The office
parameter/query would display all salespersons for that office.
Is there any way that when the salesperson number is entered directly to
disable all other parameters and render the report? On the flip side, if the
salesperson number is not entered, then allow all other parameters.
Thank you,
BobI am not aware of a way to do this, although I have messed with it a
little... It would be a nice feature to have, but right now I think you'd
have to do this in HTML in front of the report
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob" <Bob@.discussions.microsoft.com> wrote in message
news:DFACCE39-01A3-495F-BBD1-0013A6CA1D62@.microsoft.com...
> Hi,
> I am looking for some help with builing parameters in a report. A have a
> report that displays sales persons. What I need to do is either allow
> entry
> of the sales person number directly OR use a set of cascading parameters
> that
> start at country, then region, then state, followed by office. The office
> parameter/query would display all salespersons for that office.
> Is there any way that when the salesperson number is entered directly to
> disable all other parameters and render the report? On the flip side, if
> the
> salesperson number is not entered, then allow all other parameters.
> Thank you,
> Bob|||I thought I may need to put a front end on the report. Thank you for
comfirming this.
Bob
"Wayne Snyder" wrote:
> I am not aware of a way to do this, although I have messed with it a
> little... It would be a nice feature to have, but right now I think you'd
> have to do this in HTML in front of the report
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Bob" <Bob@.discussions.microsoft.com> wrote in message
> news:DFACCE39-01A3-495F-BBD1-0013A6CA1D62@.microsoft.com...
> > Hi,
> >
> > I am looking for some help with builing parameters in a report. A have a
> > report that displays sales persons. What I need to do is either allow
> > entry
> > of the sales person number directly OR use a set of cascading parameters
> > that
> > start at country, then region, then state, followed by office. The office
> > parameter/query would display all salespersons for that office.
> >
> > Is there any way that when the salesperson number is entered directly to
> > disable all other parameters and render the report? On the flip side, if
> > the
> > salesperson number is not entered, then allow all other parameters.
> >
> > Thank you,
> >
> > Bob
>
>

Condensed Data Type

(SQL Server 2000 or later.) Displays text describing this column. To edit the description, select the property, click the ellipsis ( ) that appears to the right of the property value and edit the description in the Description Property dialog box.

Is what the SQL Server documentation says for ‘Condensed Data Type’. I do not understand the design idea behind this property? What is the necessity of this property?

‘Data Type’ and ‘Length’ properties are already used to describe the ‘Condensed Data Type’.

Thank you,

Smith

My guess is that this is for those who perfer to write varchar(20) instead of first specifying varchar, then in some other place saying 20.|||

any other thoughts, please?

Thank you,

Smith

Condensed Data Type

(SQL Server 2000 or later.) Displays text describing this column. To edit the description, select the property, click the ellipsis ( ) that appears to the right of the property value and edit the description in the Description Property dialog box.

Is what the SQL Server documentation says for ‘Condensed Data Type’. I do not understand the design idea behind this property? What is the necessity of this property?

‘Data Type’ and ‘Length’ properties are already used to describe the ‘Condensed Data Type’.

Thank you,

Smith

My guess is that this is for those who perfer to write varchar(20) instead of first specifying varchar, then in some other place saying 20.|||

any other thoughts, please?

Thank you,

Smith