We help IT Professionals succeed at work.

Crystal Report Selection Formula Button

736 Views
Last Modified: 2014-09-09
HI,

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?
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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

http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
http://www.emoreau.com/Entries/Articles/2006/10/Crystal-Reports--Part-II.aspx

mlmcc
Professor Emeritus of MIS at Penn State Erie and Owner, Millet Software
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.