Create Summary List

[fofofo2554]

Hi guys,

I have 2 list in my reports
1) Error List
>this list will display records which status is "Error"
2) Success List
>this list will display record which status is "Success"

Now I want to find the count of records for each of the Lists (Error List, Success List), & this count will be use to display in another Summary List.
So that in the Summary List, it will display the number of Error records and Success records.

Any ideas how can I find the COUNT from the 2 lists and display the counts in the Summary List.

Thanks.

[Pratap Reddy]

I have 2 list in my reports
1) Error List
>this list will display records which status is "Error"
2) Success List
>this list will display record which status is "Success"

Now I want to find the count of records for each of the Lists (Error List, Success List), & this count will be use to display in another Summary List.
So that in the Summary List, it will display the number of Error records and Success records.

Any ideas how can I find the COUNT from the 2 lists and display the counts in the Summary List.

create a data item with below

Count(case [Dataitem from error list]
when 'error'
then [Dataitem]
end)

or

if you have all error msgs in list
then

create a dataitem with below

count(dataitem of error list)


use this in other list.

Regards,
Pratap

[fofofo2554]

Thanks.

When the Error list has no record, the count suppose to return '0'.
However I faced some issue which I will explain with below scenarios.

Scenarios:
1: Error list has 0 record
2: Success list has 3 records

I have a Summary list with 3 columns:
1: Total Count
2: Error Count
3: Success Count

Note:
1: Total Count is the aggregate for Error Count and Success Count
2: Error Count is the counting of record from the Error list
3: Success Count is the counting of record from the Success list

Everything is fine if there're records in the Error list or Success list. If the Error list record is 0, the Summary list does not show 0 at the Error Count column, it is blank at the Error Count column.  The Success Count column will still show '3', but the Total Count Column does not show the total which should be 3, it is blank.

I was wondering if the count for Error list is 0, it should return 0. Or it return null? For this I have tried to add IF THEN ELSE to check on the null in the Expression Definition, if null return 0 else return the actual count. However this doesn't seem to work.

Any clues what are happening? Thanks.