IIF Statement

[avent]

Runnng Report Builder 2005...

Have a break group called Resource ID. The footer of this group has 1 line with a SUM field that adds up "Required Qty"
If the Resource ID = ABC or DEF ... I want to see the SUM(Required Qty) line , if it does not, I do not want to see that line .

I cannot figure out how to create this in the conditional display area. Any help would be greatly appreciated.

al

[avent]

HELPPPPPPPPPPPPPPPPPPPP. urgent... Jeff .. any suggestions at all???????????????

Al

[Jeff Luther]

You need to put together a test case for this, Al. As I mentioned when you called the support hotline, that's helpful for both you and to post here so someone can look at it.

[TerryP]

Hi Al,

If I'm understanding your question correctly, you just need to create a ReportBuilder formula that determines if the Resource ID item value is either 'ABC' or 'DEF', and select that formula in the conditional display field. Unfortunately, there's no Decode function in RB, so the formula itself is a bit unwieldy:

Code: Select all

NumberIFF( StrCompare( ResourceID, 'ABC' ), 0, 1, 0 ) + NumberIFF( StrCompare( ResourceID, 'DEF' ), 0, 1, 0 )

Of course, if the report is based on a database query, you may be able to calculate the value in the query and pass it in as a report item, e.g. (for SQL Base):

Code: Select all

@DECODE( ResourceID, 'ABC', 1, 'DEF', 1, 0 )

Hope that helps,