crystal reports

[rzarc]

I'm having a problem in generating my report when I use the selectionformula the first time it is ok but when I select another criteria it will not display because the conditions I made with my first report will not be replace with the present criteria I inputed instead it will combine with the new condition. Can any body help me on how to replace the first condition with a new one

[bsmith]

There is a property in crystal reports to discard or clear the data in the report. I am not exactly sure what the name of the property is and I don't have anyway to look it up right now. You might want to look under Discard or Clear and see what you find.

[jedjed]

you don't need to erase it.
when you place the recordselectionformula on the report leave the selection expert blank.
in code, for example;

Report.RecordSelectionFormula = "{dao.OrderID} = " & Chr$(34) & Combo1.Text & Chr$(34)

' Refresh the smartviewer if its being used.
CRViewer1.Refresh

this will take OrderID out of a combobox and make a recordselection based on it.

it will always only be equal to that line.