CODEWITHSUNDEEP
sqloracle-databasecrystal-reports
aestet
aestet

Reputation: 357

How to call SQL Command with custom parameters in field (Crystal Reports)?

I have a custom SQL expression with some parameters. I've added it to Field Explorer correctly. But I couldn't find an example of syntax for using pre-defined parametrized SQL command with my own non-default parameters. For example, there is a SQL expression like this (it's body of SQL command):

select count(*) from table A where A.col1 > {?param}

I want to create a set of fields with different parameters. What should I to do? Is it possible? Version of CR is 11, SQL syntax is Oracle SQL. Thank in advance.

Upvotes: 0

Views: 2675

Answers (1)

campagnolo_1
campagnolo_1

Reputation: 2750

You can't use parameter field in a SQL-expression field.

You can, however, use a parameter field with a Command object (assuming that the parameter was defined in the Command object)

Upvotes: 1

Related Questions