CRystal Reports formula for Does Not Contain

Posted on 2009-12-16
Last Modified: 2012-05-08
I have a report where I only want to show records where a value is not shown, what can I put in the formula where a record does not contain a value
Question by:GiaHughes
    LVL 9

    Accepted Solution

    LVL 13

    Assisted Solution

    Assuming the record select formula.


    If the 'value' is actually a linked table, and there is no record in that table, you need to link the table a a left outer join in the database expert and then use the above in select formula for any field in this table.

    If you want to show "No Value" where the report currently shows blank, create a formula like

      "No Value"

    Author Comment

    Hi Guys

    Thanks for your speedy input
    I have overcome the problem by adding a numeric number to the transaction and then using the supress function against the record
    This seen to achieve what I wanted
    Thanks again
    LVL 13

    Assisted Solution

    Beware of using suppress instead of record select.
    Suppressed records are still included in summary calculations, and if you suppress a lot, then moving the same rule to the selection formula will dramatically decrease the time taken to fetch the data from the database....

    Author Comment

    I do appreciate what you say, in this instance I don't think I need any summary information, so supressing I think is Ok

    Featured Post

    IT, Stop Being Called Into Every Meeting

    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

    Suggested Solutions

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    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…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now