[SOLVED] Types of Filters in Impromptu

[elisha]

We have two types of filters in Impromptu i.e., Detail filter & summery filter.
Ã,  Ã,  Ã,  Ã, My question is
Ã,  Ã,  Ã,  Ã, a) When we apply Detail filter where the query will we processed ? .
Ã,  Ã,  Ã,  Ã, Is it processed locally or Server Database ?Ã,  Ã, And why ?
Ã,  Ã,  Ã,  Ã, b) When we apply Summary filter where the query will we processed ? .
Ã,  Ã,  Ã,  Ã, Is it processed locally or Server Database ?Ã,  Ã, And why ?

[anoop_ind2]

Your detail and summary filter works more for the "Where" clause and your "Having" clause and it itself doesn't dictate where it is getting processed.... your query processing can be deferred to Database or Local on the client/server tab.... if there are sorts on calculated fields or filtering on sub totals etc the action is done more on the local side than on the database server... You can in general say that the detail filter gets processed on the database side and the summary filters on the local side though it may not hold true in all cases..

[Sridark]

Hi Team,

Well, when we talk about filter, most of the time it works on database side.  If itââ,¬â,,¢s a detailed level, one way we can make sure itââ,¬â,,¢s on database side by viewing the query created by impromptu. Here impromptu will apply the query directly to database.

In the case of Summary level, the SQL is no more summarised.  It will be an ordinary query.

I would like Mr. Darek to suggest regarding this issue.

Regards,
Sridar K