Printable View
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
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.
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.