Skip to Content
0
Former Member
Dec 01, 2008 at 10:12 AM

Creating 'Dynamic' queries -

18 Views

Hi there,

I am use dto using Actuate reports where I can build up some SQL as a string before processing it.

Doing this allows me to totally alter the SQL that is run based on various parameters (using IF THEN ELSE statements to build up the SQL string)

How can I do this in Crystal Reports (if I can at all)?

I know I can create parameters which add to the WHERE clause.

But is there a way I can change the rest of the SQL that is run based on parameters?

Thanks in advance,

Matt