Report problem...any ideas?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a report that outputs pricing. I have cases where the price for an
item is zero, in which case I want to replace the string that was going to
be printed next to the price (normally holding a few characters to show the
currency type) with the string "Quote". So, in the data source property for
the data item in the report I have the following:

=iif([pricebookprice]>0,[currency],"Quote")

The report runs fine, but in the spot where I would expect to see the
contents of [currency], or "Quote" if the price is zero, I see "#Error". I
don't know why!

[pricebookprice] is a number, [currency] is a 50 character string (longer
than necessary, I know).

HELP!

Thanks!

Steve
 
I have a report that outputs pricing. I have cases where the price for an
item is zero, in which case I want to replace the string that was going to
be printed next to the price (normally holding a few characters to show the
currency type) with the string "Quote". So, in the data source property for
the data item in the report I have the following:

=iif([pricebookprice]>0,[currency],"Quote")

The report runs fine, but in the spot where I would expect to see the
contents of [currency], or "Quote" if the price is zero, I see "#Error". I
don't know why!

[pricebookprice] is a number, [currency] is a 50 character string (longer
than necessary, I know).
Click to expand...

Is the price actually zero, or might it be NULL? Try

=IIF(NZ([pricebookprice]) > 0, [currency], "Quote")
 
Back
Top