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:
VB Code:
  1. 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?