tosscrosby-60625 (3/12/2010)

The town of Cass Lake (specifically fishing on Leech Lake), near Walker and Bemidji. Been going there...

Just out of curiousity, what part of Minnesota are you fishing?

The Twin Cities of Minneapolis and St. Paul, MN.

The Metrodome has to be at the top of the worst places to watch a game list...not sad to see the Twins move at all....

Might not be related, but in the past when I've had timeouts in viewing job history it's been as a result of an Async_Network_IO wait type.

How about using the Having clause to pull only those with a count > 2...

You could try this...

IIF(field!.number.value = 0, field!letter.value, field!number.value)

You'll have to have a true and false option for the IIF statement.

In your report parameters you don't have this set to have available values From Query do you? I think that should stay as Non-Queried.

The error is coming from your code? I think your IIf statement needs a final qualifier...

=IIF(Parameters!PeriodToDate_Parameter.Value ="MTD",

IIF(Fields!Gross_Profit_MTD.Value <> 0 Or

Fields!Adjusted_Gross_Profit_MTD.Value <> 0 Or

Fields!Adjusted_AGP_MTD.Value <> 0 Or

Fields!Product_Sales_MTD.Value <>...

It may work to add an expression to the visibility of the row. Something like iif(nothing, true, false).

You should be able to add a textbox to the report and then in the expression builder you select the parameters that you want to display.