How can I filter out a group of customers in a report

JBeck

Hi There,

I have a filtering problem in a report of mine and I hope u guys can help me.

A few of my customers are registered under a V-number e.g. V001, V002, V003 etc.
When running my report I wish to filter out this group.
In the filter section of the report I've used <>V* and when I ran the report my data still showed all the customers with a V-number.
Does anyone know how to filter out a group in a report?

Thanks in advance,
JBeck

jannestig

Are you using an SQL DB or a Native DB the format you used works in an SQL environment but not Native

Use a filter like A..KZ|M..ZZ

JBeck

I'm using a Native DB.
That explains why it didnt work.
How can I do this in a native db?

Thanks in advance.
JBeck

jannestig

just a note the filter i used was A..KÖ|M..ZÖ where Ö is the last letter of the swedish alphabet. if your language is different from standard english letters as well putting your last character there will suffice i imagine

kriki

filter : '<V|W..'

JBeck

Well I have many customers and almost all of the have a number ID or are in a letter group. Only a group of customers have the V-number ID. I just want to filter out the V-numbers.
I dont know how I should implement your method. Isnt there another way?

kriki

JBeck wrote:

Well I have many customers and almost all of the have a number ID or are in a letter group. Only a group of customers have the V-number ID. I just want to filter out the V-numbers.
I dont know how I should implement your method. Isnt there another way?

Well, instead of putting '<>V*' in your filter, you put '<V|W..'

JBeck

THANKS kriki!!! the '<V' worked great!
Many many Thanks!

dianepiper12

You want to do it in the DataItemTableView property of the report.

Pick the Key, then apply your filter in the Table Filter area.

Field = the field you want to filter, Type = Filter, Value = <>V*