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

Thread: Using the ALL Option

  1. #1
    Join Date
    Feb 2009
    Posts
    190

    Using the ALL Option

    Hallo,

    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
    Location
    Pittsburgh
    Posts
    103

    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

This is a CodeGuru survey question.


Featured


HTML5 Development Center