Scope of Filters

[rajivgupta1107]

Hi,

Please explain the concept of 'Scope of summary filters' with some example and where it is used?

Regards

[Gopinath]

Scope determines the level at which the filter shouild be applied.

for example
you have Region, country, State and Revenue data items in your report.
Region, Country and State were grouped.
If you Total the Revenue field you will get footers(sub totals) for Country and Region.
Now if you want to filter Country which has > 50000 revenue, then create a summary filter like Total(Revenue) > 50000 and set the scope to Country.

[rajivgupta1107]

okk thanks a lot..

One more thing:
Suppose I have a query in the report:

select sum(revenue), region from table group by region having sum(revenue) >100;

Data is:

Revenue  Region
200   A
40  B
500 G


Now in report I show only the region. Its showing A,B,G. But it should show only A and G. For 'B' the having clause is false.

Why it is so?

[Gopinath]

try total(revenue for Region) > 100 in your summary filter

[rajivgupta1107]

I have put the filter in summary filters.

But when i try to show the region, its showing A, B and G all. But it shud be A and G only.


Regards

[Gopinath]

Try placing the filter condition at Detail Filters and change the application property to After auto aggregation.