referencing parameter in sql query

[ttchimera]

I need to use a parameter passed by a user to a sql query. Is there a way in CR8 to do this? I try passing it within curly braces, but it did not work. Thanks

 

[lbass]

You cannot reference parameters directly in the "Show SQL Query" area in 8.0. You should just go to report->edit selection formula->record and use the parameter in the formula, as in:

{table.value} = {?parameter}

The value will appear in the where clause of the Show SQL Query if it is set up correctly.

-LB