Try converting your IIF result to an integer (or anything numeric i.e. CDbl, CDec, etc.) like this:

=CInt(IIF( Fields!Sales.Value IsNothing or Fields!Sales.Value = 0 , "0", Fields!Sales.Value))

HTH

Here's an item from another forum that may help:

Data Fields in Page Header - a Solution From Bill Miller

Here is an approach I am using to put data items...

These should get you started.

Expressions Commonly Used in Reporting Services

http://msdn2.microsoft.com/en-us/library/ms157328.aspx

List and Links to Visual Basic Function Definitions

http://msdn2.microsoft.com/en-us/library/c157t28f(vs.71).aspx

Common VB/.NET Number Format Codes

Custom formatting:

http://msdn2.microsoft.com/en-us/library/7x5bacwt(VS.71).aspx

Standard formatting:

http://msdn2.microsoft.com/en-us/library/dwhawy9k(VS.71).aspx

If Jack's method and my method didn't work, then I'm stumped (for now)

Sorry

What's your entire filter statement?

SSRS filters are inconsistent comparing numeric data. You may need to be creative and come up with a Boolean filter to accomplish what...

Is your Fields!Totals.Value numeric?

Try the InStr function. It returns an integer specifying the start position of the first occurrence of one string within another.

Rephrasing your example, this is the syntax:

=IIF(InStr("1,5,6,7,8,9,10,12,13,14,16,20,32,36,37,38,39,40", Fields!Item_id.Value) >...

The only way I can think of to do that is to add a "Print Version" parameter. You can then set the backgrounds based on the parameter value.

=IIF(Parameters!Print.Value =...

Why don't you post your query script here. I'm sure someone can direct you once they know how you're collecting your data.

Sounds like some part of your report is extending outside the page dimensions. That'll cause the every-other-page output. Make sure no part of your report plus the margins is...

Try 0.00 instead of #.## or set the Format property of the text box to N2 (numeric with 2 decimal places) or D2 (decimal with 2 decimal places).

Check these links...

I doubt you'll be able to actually programmatically set the number of table columns based on the dataset. At least I've never seen the means to do so...

Does your format demand the time periods across the top and days down the side? If it doesn't, I'd try it the other way around. It seems to...

Try locating your cells in a list data region. If it works the way I think it's supposed to (never use lists myself) that should let you free form...

IIf(A < B, ((A/1000)*C), (B/1000)*C))

Is there ever an instance where A = B?

If so, you'll maybe want to use SWITCH instead of IIF. SWITCH evaluates a list...