Counting for different items

[tjcusick]

I'm new to this Actuate 8 SP1 reporting tool but am really enjoying working with it.

I'm having just one slight issue:
The data I'm reading in has a column called TORT_OPT and can either be a F or L. I want to put a count line at the end of the group section that has the agency id and the F count and the L count.

so im looking to have [AGENCY_ID] [COUNT() OF 'F'] [COUNT() of L]...

i tried to use iif statement but it's not working the way i would think it would.

I had IIF([TORT_OPT]="F", COUNT( ), 0) but everything came out as a 0...

Should i be putting code in the onRow or onFinish sections?

Any suggestion or help is greatly appreciated.

Tom C

 

[ASG0856]

For starters, I think using IIF is wrong, as IIF is to insert a value if the stated value is false. IE, if you are insrting a 'Data AS At' DTG, but can report against a backup or live DB, then the expression is IIF(IsNull(BackupDTG,Now(),Backup DTG)) - If BackupDTG Is Null, insert Current DTG (because this is the live DB), else insert BackupDTG (because it's the Backup DB).

Count should be in the After Frame, and an expression in ValueExp like Count Where ([FieldName] = 'T') and a second for ='F'

 

[tjcusick]

That works.. thanks for the advice