Selection on data on Crystal Report

[MJB]

I'm new with Crystal Reports in VB. Now I've created a report within Crystal Reports. This works well. The source for the report is the database that also is being used by my VB-application. Now I Call the report from my VB-application and it is being shown, but with all the data from the database of course. How can I do a selection on the data being showed? The user can select a week in the VB-app for example and only the appointments for that week have to be shown in the Crystal Report. How do I do this? Thnx a lot 4 the reply's in advance...

[Kunchesm]

use .RecordSelectionFormula property

[MJB]

With replaceselectionformula, I have to give a string as a parameter. Is this a SQL string, beacause if I do so, nothing happens.

[Kunchesm]

didnt u ever try the record selection formula from crystal reports?? .. from vb interface also u shud use the same format..


crystalreport1.replaceselectionformula = "{tablename.fieldname}='" & strValue & "'"

where strValue is the value for the field