Help Excluding Records - Crystal Reports

P

Patrick A

Can someone help me with a formula? I have it 2/3 working, can't seem
to get the last part, can't seem to find info in Help or my 3 books.

I'm using a formula that looks at the selection a user makes in a
parameter field, PCode, and passes info on to a filter for record
selection.

The firm has various PCodes. 9999 indicates a non-billable item. 10,
11, 12...100 indicate billable items.

I have the logic for selecting just the 9999's, and for selecting
everything, but I don't know how to put together the logic for
selecting everything except the 9999s.

Select {?PCode}
Case "Non-Billable": //If the user selected the parameter "Non-
Billable"
9999 //Set the PcodeVar to 9999 - only 9999's
are returned.
Case "All": //If the user selected the parameter "All"
{praccode.pcode} //Select all of the records in the source
column.
Case "Billable": //If the user selected the parameter
"Billable"
//Not 9999 //Set the PcodeVar to "anything other than
9999" > error: A Boolean is required here.

Suggestions?

Thanks.

Patrick
 
D

Duane Hookom

If this is truly a Crystal Reports question, you should either convert your
reports to Access (good idea) or find a CR news group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to get my head around reporting fields...help!? 1
on report open, query date 3
45 RPM Record Catalog 10
Totalling a field that lives on a report only 7
Problem with totals in report 2
Assign Alpha Code to Child Record 2
I get so close, but in the end I can't seem to get the results I w 2
Formatting reports 2

Top