Eclipse Community Forums: BIRT » Need help on using a filter in Total.count()

Home » Archived » BIRT » Need help on using a filter in Total.count()

Need help on using a filter in Total.count() [message #146160]

Mon, 20 March 2006 16:04

Eclipse User

Hi,

I'm trying to use a filter in the Total.count BIRT function but get errors
when I try to add something like row["statusCodes"]='A'. I don't see any
other way in the expression builder to add anything explicitly called a
filter. This is in a cell in a grid component. So far the only way I can
see to get around this is to use a seperate dataset with the filter set
there.

Basically I want to create something like the following:

Status Code Number of Records Percent of Total
A 10 13.5
B 12 16.2
C 5 6.8
D 43 58.1
E 24 32.4
Total 74

Any help would be appreciated.

Thanks,
Jim

Re: Need help on using a filter in Total.count() [message #146169 is a reply to message #146160]

Mon, 20 March 2006 16:25

Eclipse User

Originally posted by: vladperl.semanticprogrammer.org

"Jim Norris" <james.norris@pb.com> wrote in message
news:dvn5co$veb$1@utils.eclipse.org...
> Hi,
>
> I'm trying to use a filter in the Total.count BIRT function but get errors
> when I try to add something like row["statusCodes"]='A'. I don't see any
> other way in the expression builder to add anything explicitly called a
> filter. This is in a cell in a grid component. So far the only way I can
> see to get around this is to use a seperate dataset with the filter set
> there.
>
> Basically I want to create something like the following:
>
> Status Code Number of Records Percent of Total
> A 10 13.5
> B 12 16.2
> C 5 6.8
> D 43 58.1
> E 24 32.4
> Total 74
>
> Any help would be appreciated.
>
> Thanks,
> Jim
>

Re: Need help on using a filter in Total.count() [message #146177 is a reply to message #146160]

Mon, 20 March 2006 16:28

Eclipse User

Originally posted by: vladperl.semanticprogrammer.org

> I'm trying to use a filter in the Total.count BIRT function but get errors
> when I try to add something like row["statusCodes"]='A'. I don't see any
> other way in the expression builder to add anything explicitly called a
> filter. This is in a cell in a grid component. So far the only way I can
> see to get around this is to use a seperate dataset with the filter set
> there.

try:
row["statusCodes"]=='A'

> Basically I want to create something like the following:
>
> Status Code Number of Records Percent of Total
> A 10 13.5
> B 12 16.2
> C 5 6.8
> D 43 58.1
> E 24 32.4
> Total 74

I suppose is better to use group item to do this.

Re: Need help on using a filter in Total.count() [message #146431 is a reply to message #146177]

Tue, 21 March 2006 07:40

Eclipse User

Thanks Vladimir,

That did the trick. This is another one of those 'duh' moments for me :-)

Jim

"Vladimir" <vladperl@semanticprogrammer.org> wrote in message
news:dvn6o7$9ia$1@utils.eclipse.org...
>> I'm trying to use a filter in the Total.count BIRT function but get
>> errors when I try to add something like row["statusCodes"]='A'. I don't
>> see any other way in the expression builder to add anything explicitly
>> called a filter. This is in a cell in a grid component. So far the only
>> way I can see to get around this is to use a seperate dataset with the
>> filter set there.
>
> try:
> row["statusCodes"]=='A'
>
>> Basically I want to create something like the following:
>>
>> Status Code Number of Records Percent of Total
>> A 10
>> 13.5
>> B 12
>> 16.2
>> C 5
>> 6.8
>> D 43
>> 58.1
>> E 24
>> 32.4
>> Total 74
>
> I suppose is better to use group item to do this.
>

Previous Topic:	internationalization
Next Topic:	General question of design --> Reporting in a Three-Tier-Architecture with RMI

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Sep 14 01:11:59 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter