Skip to Content
author's profile photo Former Member
Former Member

Missing Result Rows on Query with Conditions

I have a query that has a condition to show only items over $2500.00. We have a result row that shows for plant when the condtions is not on but once the condition is set that result row goes away. Does anyone know how to get a result row to show up on reports with conditions? Thank you.

Caroline

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 11:14 PM

    Hi Caroline,

    In BI 7.0, you goto do this in Query Designer.

    Select any of your characteristic in the designer and choose Display Properties to always display result.

    Then run the query.

    Assign Points if Helps !!

    Regards,

    Naveen Rao Kattela

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      we are not in 7.0 we are in 3.5....this does not work in 3.5 as we have tried every combination of characteristics and we either get a really strange result or none at all....the condition is what is causing the issue...if the condtion is off it works fine.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.