sammydafish
IS-IT--Management
I'm using CR 8.5. I have a query that I need to use a nested select in. I can't seem to get Crystal to format the query as I need in order to take advantage of keys, but I can go to "Show SQL Query" and edit teh query to get my desired results. The problem is, I don't know how to get the data in "Show SQL Query" to use a parameter. I need to let the user enter a date into the subquery. How can I do this?
what I'm trying to do is something like this:
Select [columns] from [tables] where invoice in (select invoice from
where invdate = {parameter})
But if I try to insert something like {?invdate} I get syntax errors. What can I do?
- Anthony
what I'm trying to do is something like this:
Select [columns] from [tables] where invoice in (select invoice from
But if I try to insert something like {?invdate} I get syntax errors. What can I do?
- Anthony