Record Select. can use parametres?

[Jamfool]

Under database-show sql query is the intial record select query for the report. My question is this. How do you specify at this point that i only want my report to query records with a value higher than @x in column a?

This can be hardcoded for individual values, but i wanted to have a parameter select.

Can this be done?

How do you filter the record out ? Surely you dont select all the records then eliminate them after record select...or do you?

 

[Madawc]

I'm not sure I understand the question. Crystal can select using a parameter value, definitely

Madawc Williams
East Anglia, Great Britain

 

[Thadeus]

Jamfool,
I'm not sure if you figured it out yet, so I figured I'd post.

Here's what you do:
In the Field Explorer window, there is a group listing named Parameters. Right click on that heading and choose New....
Follow the set-up using the dialog. If you need help, refer to the help section for this.

After it is created, you can use it in the Select Expert. The only thing to note here, is that you MUST match data-types... In other words, if you are filtering for a Number field, then when you create the Parameter, you MUST create it as a Number type... Then when you use the Select Expert, you will be able to click on the combo box to the right of the words "is equal to" (or whatever you choose from that combo)... Your parameter will be in the drop list if you set this up correctly.

Refresh records and you will be prompted for the parameter.

Thadeus

 

[Jamfool]

yeah thanks i got it know, cheers