Skip to Content
0
Former Member
Aug 05, 2016 at 07:40 PM

Ad Hoc Report - Missing items

359 Views

Hello,

I'm working on an ad hoc report and when I select all of the items for selection an output I then filter out the selection values to generate more specific items I want to see. One of the items I have for selection when I select certain values it excludes everyone who doesn't have that value. How can I get the report to show all line items that have that value plus those who may not have it at all?

I have tried exluding certain values or including certain values but it seems to still only give me a few line items. When I don't use that selection value at all everyone shows up on the report. Some show up multiple times because they may have other items listed but I only want them to show up if they have lets say 0-2 of the 10 values I could choose from.

Any help with this would be greatly appreciated.

Elizabeth