Prompt Select from user

[tdong]

Is there a way in CR 9 that you can create a report and it will prompt the user to narrow their view ? for example if I have item from 1 to 10 default view is there a way for user to select just 3 to 5 to view. I need a prompt like use choose start item choose 3 and end item choose 5.

The thing is I am using VB6 and crytal report. I have a view already but I need a prompt for the user to narrow down from start date to end date and series and type too. I did it with VB6 report ok since below is my code for VB6 report I need to do the same for CR6

those cmbBox are drop down so that user can select the view
first they can choose serier->then provider then assetgroup then date need to have the same prompt using CR9

If cmbSeries <> "" Then
If cmbProvider <> "" Then
If cmbAssetGroup <> "" Then
DataEnvTrade.rsCPIssueLiquidity.Filter = "[series_id]='" & cmbSeries & "' and [maturity_date]>'" & fromdate & "' and [maturity_date]<'" & todate & "' and [provider]='" & cmbProvider & "' and [program_group]='" & cmbAssetGroup & "'"
Else
DataEnvTrade.rsCPIssueLiquidity.Filter = "[series_id]='" & cmbSeries & "' and [maturity_date]>'" & fromdate & "' and [maturity_date]<'" & todate & "' and [provider]='" & cmbProvider & "'"
End If
Else
DataEnvTrade.rsCPIssueLiquidity.Filter = "[series_id]='" & cmbSeries & "' and [maturity_date]>'" & fromdate & "' and [maturity_date]<'" & todate & "'"
End If
Else
DataEnvTrade.rsCPIssueLiquidity.Filter = "[maturity_date]>'" & fromdate & "' and [maturity_date]<'" & todate & "'"
End IfThanks

 

[tdong]

Thank to Synapsevampire I copy your reply from other post here for my question

synapsevampire (Programmer) Mar 7, 2004
Select Insert->Field Object->Right click parameters and select new->name it

Select the data type that is consistent with the type of data being filtered on the database.

Example: Date

If you want a range of dates, select the Range check box, and Crystal will propmt for 2 dates.

Now select Report->Edit selection formula->Record

Enter in something like:

{table.date} = {?My DateParm}

Run the report.