CrystalHacker

Does anyone else find the Filtering in the Report Definition completely backwards. 90% of the time I want to eliminate one or two things, like Labor and OFE. However, under the current rules I need to figure out how to include everything except what I want to leave out.

Leaving out one is easy. It is when you want to leave out two that it gets very complicated.

I understand that the current process makes the query much easier but it is not very helpful to me most of the time.

Am I the only one? I've been told that many times, so I am willing to stand corrected on this one as well.

-ch

nkarthick

You can customize your report in Required Filter page and choose the “Not Equal To” operator. For example in your case you need to filter out the Labor and OFE items, the below figure illustrate that.

Filtered out.JPG

FYI – You can filter any existing report by right clicking and selecting “Run report with filters” (for report which supports Filtering) or create new custom reports with filters applied.

run report with filter.JPG

Hope it helps

__________________
Narayana Karthik

grichards

Some "Select All" Check boxes might be nice here and there. In this instance it would facilitate "Filtering Out" with the Contains operator by Selecting all then unchecking what you don't want. It would be really nice in the Product Grid View as well. Feature request??

CrystalHacker

Yes, I used the NotEqualTo, but it when tested it did not seem to work. The logic looks correct. You get a False if any of the "NotEqualTo"s are False. I'm not sure why it did not appear to work. I will retest.

-ch

nkarthick

Ch,

Could you please try changing the "And" logical operator to "OR", so that it will filtered out both Labor and OFE items. Sorry about yesterday's post i used "And" operator instead of "OR"

Hope it helps.

__________________
Narayana Karthik

David_Haddad

Originally Posted by CrystalHacker

Does anyone else find the Filtering in the Report Definition completely backwards.

Yes, not only in reports but the data matrix. And as grichards points out a select all button would go a long way towards fixing it. I would use filters in the data matrix constantly but it's such a PITA because it's backward I don't even bother. All I want to do is filter out one or two categories which requires clicking on 25 others. No thanks!

NareshN

David,

Just to confirm - Are you saying a + and - button on each tab of the PDM Filter to do a "Select All", "Deselect All" would help?

Naresh

CrystalHacker

I think you were correct with the AND. I know OR does not work because they are exclusive sets and as a result, you get no data returned when using NotEqualTo. At first AND looked incorrect, but it was the correct answer, Since BOTH statements had to be true to allow Data to pass.

Type <> Labor (true)
AND
Type <> OFE (true)

If Both are true then include the data. If either are False then the Item would be excluded. I had to build a logic table to get my head around this. I guess that is the reason I was looking for a simpler way to EXCLUDE data.

Originally Posted by nkarthick

Ch, Could you please try changing the "And" logical operator to "OR", so that it will filtered out both Labor and OFE items. Sorry about yesterday's post i used "And" operator instead of "OR" Hope it helps.

grichards

Originally Posted by NareshN

David, Just to confirm - Are you saying a + and - button on each tab of the PDM Filter to do a "Select All", "Deselect All" would help? Naresh

i would say in any location where you have checkboxes related to each field in the entire database (i.e. the MMPD product grid) provide select all and select none buttons.