Crystal Report Selection Formula Button

Posted on 2014-08-08
Last Modified: 2014-09-09

Is it possible to have a button on my VB form that modifies the crystal report selection formula (not the sql but the select expert filter formula)

All I really want is that when I click the button the following filter is applied :
{projects.stage} <> "Completed"
If I click it again : {projets.stage} = "Completed"

Is it possible?
Question by:FCapo
    LVL 100

    Expert Comment

    How are you calling the reports?
    The method and APIs used will control how you pass the formula.

    You can pass a selection formula to the report.  When you change the formula you will have to refresh the report for the change to take effect.

    One easy method would be to PUSH the data to the report from the application.  In that method the application has full control over the data passed

    See eric moreau's articles

    LVL 22

    Accepted Solution

    One of the 3rd-party Crystal Report Viewers listed at provides that functionality.
    If a parameter that has only two possible values is placed on the report layout, each click on it flips it to the other value.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now