Report Studio Filter

Posted on 2012-08-21
Last Modified: 2012-08-31
I'm trying to filter by "is not missing" in a vendor part id field and when I check for errors there are none yet the blank records remain... is this due to the type of field it is?
Question by:EA_ENT
    LVL 12

    Accepted Solution

    Is the field actually "Blank"?  Or is it "Null"?  Or is it perhaps a space?  Null fields caused by outer joins won't get "filtered" unless the filter is specified as a summary join.  Often, the easiest way to handle those is to make two sub queries (one for each side of the outer join), and construct the join within report studio directly; this gives you the ability to control the order of filtering.

    Author Comment

    To test I tried to just query a seperate report using the field in question and even by itself doesen't work yet no errors at validation.  I did notice when opening in excel some of the records had warnings that a space had been used to start the record.

    Author Closing Comment

    I believe the data entry is the problem with that field ...


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
    Hi, In my previous Article  ( discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now