Auto Filtering

[Hawkeye97]

I know the answer to this is probably dead obvious but I must be having one of those blank days.

Anyway, I've created a couple of reports taken from the one query. The main report looks at all sales for a given month (showing order numbers and credits notes primarily).

The second report just looks at credit notes. This is done by simply putting a filter on <Order_no> and look for anything with a CN prefix.

However, this is only good for one day because when Broadcast Agent does an update the following day the query will bring back new orders and credits but the filter on the second query won't automatically pick up these new credits without manual intervention.

I know this could be resolved by simply creating a brand new query just for Credits, but I just wondered if there was a formula or procedure that could be added in the existing query to get round this

Any help would be appreciated (btw. I'm using BO v5.1.6)

Thanks

 

[blom0344]

Are you using a compex filter?

A complex filter will have a formula to work with, making it dynamic. Another solution is to introduce a checking variable (except for aggregated measures) and apply the filter on this variable, like:

=If Match(<field>,"%CN%") Then "True" Else "False"

I do not fully understand if this will be enough in your case. You may post the query and we can see if we can modify that instead......

T. Blom
Information analyst
tbl@shimano-eu.com