Using the ALL Option
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums
Results 1 to 2 of 2

Thread: Using the ALL Option

  1. #1
    Join Date
    Feb 2009

    Using the ALL Option


    I have the following crystal report formulae which is not working presently. What I want to do is the user can select a system version at the drop down or select all to bring all the system versions ONLY on the list.

    However, this formulae brings all the system versions in the database even those not listed in the drop list. Any help please!!!

    (if {?System Version} = "ALL" then TRUE
    else {DistinctGP27.CLINCOMP} = {?System Version} or
    {DistinctGP27.CLINCOMP} = "In Vision" or
    {DistinctGP27.CLINCOMP} = "INPS London (Vision)" or
    {DistinctGP27.CLINCOMP} = "INPS Vision" or
    {DistinctGP27.CLINCOMP} = "IPS" or
    {DistinctGP27.CLINCOMP} = "IPS In Vision 3" or
    {DistinctGP27.CLINCOMP} = "IPS Reuters Surgery Mgr" or
    {DistinctGP27.CLINCOMP} = "IPS Reuters Vamp" or
    {DistinctGP27.CLINCOMP} = "IPS Reuters Vision" or
    {DistinctGP27.CLINCOMP} = "IPS Reuters Vision 2.1" or
    {DistinctGP27.CLINCOMP} = "IPS Vision" or
    {DistinctGP27.CLINCOMP} = "IPS Vision 3" or
    {DistinctGP27.CLINCOMP} = "ips viso" or
    {DistinctGP27.CLINCOMP} = "Vamp Vision" or
    {DistinctGP27.CLINCOMP} = "Vamp Vision (INPS)" or
    {DistinctGP27.CLINCOMP} = "Vamp Vision INPS" or
    {DistinctGP27.CLINCOMP} = "Vision" or
    {DistinctGP27.CLINCOMP} = "Vision 3" or
    {DistinctGP27.CLINCOMP} = "Vision in Practice")

  2. #2
    Join Date
    Apr 2008

    Re: Using the ALL Option

    Try changing it from an if else statement to a select case statement. That works great for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

HTML5 Development Center