[RESOLVED] Formula.Text PRoblem

[dec_obrien]

Hi,
I have a CrystalReport that is using a Formula in the SelectExpert to filter the information for the report. It is a report that displays output per Shift. I want to be able to run the report for a selected shift or for all shifts.
My formula is being changed by:

rptSub.DataDefinition.FormulaFields("ShiftLetter").Text = Me.ShiftLetter

and the SelectExpert is using the @ShiftLetter formula to filter the information like this: {rpt.....Shift} LIKE @ShiftLetter

This is all working fine for any particular shift but when I want to run the report for all shifts, I can't get it to work. I have been trying to set ShiftLetter to % or '%' etc but none of the combinations seem to work.

ANy ideas how to fix this?

[dec_obrien]

ANy ideas?

[mabbas110]

dont do this thing.
just try to use selection formula
means
rpt.selectionformula='shiftletter=' & me.shiftletter

see also the help of crystal report for using selection formula.

[dec_obrien]

Hi,
I've figured this out. I didn't think that the IN operator was available in CR formulas but it is.

RptToView.DataDefinition.FormulaFields("Shift").Text = "' [A, B, C, D, E]'"

or

RptToView.DataDefinition.FormulaFields("Shift").Text = "' [A]'"

Then, in the SelectExpert use

MyTable.Shift IN @Shift

Dec.