Print Page | Close Window

Base a Parameter on a Formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22861
Printed Date: 30 Apr 2024 at 2:17pm


Topic: Base a Parameter on a Formula
Posted By: jsh8286
Subject: Base a Parameter on a Formula
Date Posted: 09 Feb 2020 at 8:16am
Have a formula in a crystal report (works fine) that is the following:

If InStr({OEOrdDetailwHead__ao93a171.Description}, 'ML') > 0 then 'Yes ML' else

If InStr({OEOrdDetailwHead__ao93a171.Description}, 'L') > 0 then 'Yes L'

else

'OVER OR UNDER??'

The above formula separates items into their respective groups based where they fall.

How do I incorporate this into a parameter so that I can run the report only to show one of the results?

Thanks in advance.


Replies:
Posted By: DBlank
Date Posted: 10 Feb 2020 at 2:31am
create a static parameter with your 3 options then in the select criteria use the two fields to = each other.


Print Page | Close Window