<div>Hi,<br />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.<br />My formula is being changed by:<br /><blockquote><pre> rptSub.DataDefinition.FormulaFields("ShiftLetter").Text = <font color="#00007f">Me</font>.ShiftLetter</pre><pre><br />and the SelectExpert is using the @ShiftLetter formula to filter the information like this: {rpt.....Shift} LIKE @ShiftLetter<br /><br />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 i.e. how do I pass a wildcard into @ShiftLetter so that the SelectionFormula looks like: "LIKE %".<br /><br />ANy ideas how to fix this?</pre></blockquote></div><!-- / message -->