Hello - I am very new to crystal and am trying to work through a lot on my own, but I'm getting hung up on some things and hoping to get some help.

I am working on some parameters for a report, there are 3 criteria that I would like the user to be able to make selections on. I tackled the one I thought was the easiest first, but it is not working and I'm not sure what I'm doing wrong.

We have 2 districts in the company (A & B). I set up a new parameter - type: string, LOV: static, value field: DISTRICT_CODE, and clicked to Append all database values and A & B show up under the values. Entered it into the report, the prompt to enter values pops up, I select District Code A and it gives me all of the records, not just ones for District A. Same thing when I select District Code B.

The second parameter will need to be an option show all customers including one particular customer or all customers except this one particular customer.

The third is an option to either see any "open" orders (based on order status field) OR to see any orders that have been invoiced MTD (true 1st of the month) AND any open orders.

Any guidance on these would be much appreciated!
Thanks, Kris

As Kevlray indicates, after you create the parameter you have to use that parameter in the select expert to make it act as a filter.
For your specific customer item I would do something like a static parameter that has the value of 1 and 2 with a descriptions of 'include customer XYZ' and 'Exclude customer XYZ'.
In the select expert you would have something like
{?DistrictParam}={table.district} and
({?IncludeCustomer}=1 OR
(({?IncludeCustomer}=2 AND {table.cusotmerID} <> 'ValueHere'))

If for your last item you want to filter to all or only an option that = a value in your data set add another static number parameter with a value of 1 and 2 with whatever descriptions like 'all open invoices' and 'closed only' (or whatever) and add another part to the select statement using that logic
AND
({Param3}=1 or
({Param3}=2 and {CUSTOMER_ORDER.STATE}="Closed"))

you need to parenth the conditions so that each one executes

{CUSTOMER_ORDER.COMPANY} = "110" and
not ({CUSTOMER_ORDER_JOIN.CATALOG_NO} startswith "N") and
{CUSTOMER_ORDER.DISTRICT_CODE} = {?District} and

(
{?IncludeCust}="Yes" or
   (
    {?IncludeCust}="No" and    
    {CUSTOMER_ORDER_JOIN.CUSTOMER_NO}<>"12345"
   )
)

Spoke to soon...prompt 3 works fine if I select value 1 (open orders only), but value 2 (open orders & invoiced MTD orders) gives me a blank report. Here's what I have:

({?Order Status}="1" and {CUSTOMER_ORDER_JOIN.STATE}<>"Invoiced/Closed" or ({?Order Status}="2"
and {CUSTOMER_ORDER_JOIN.REAL_SHIP_DATE}in monthtodate))

I realize because I'm working with old data in a TEST environment that there probably not many (if any orders) invoiced "this month" but it should still be giving me the open orders, correct?

Update: I just ran several orders through quickly in the test envir and invoiced them. They do show up with value 2 selected, but just the invoiced orders, not all of the open orders.

Edited by kris_a - 30 Nov 2018 at 7:21am