changing queries using crystal report!

[kingz2000]

Hi,

I am a holder of crystal reports IX. I have managed to make a report with a query. I was wondering if it was possible to parameterise my query using crystal report. In another words, I would like to change my query,but only in the sense that the customerID would be different or the date range would change. Is it possible to control that this with crystal report or do I have to build a new query using Access or something?

Kingsley

 

[MisterMo]

If by query you mean a command, then the answer is yes

Mo

 

[kingz2000]

by query I mean like a view!!

 

[MisterMo]

have you tried using the record selection formula

something like

{table.clientId}= 1234

if this works then simply create a parameter and use it instead of the value

{table.clientId}= {@MyParam}

Mo