Is there a way to used named queries with a start and end date. Something like this?
If there is a way to do that. Can there be a way to use the named query can be used as a data Sources in a report using the Parameters?
Something like this:
I think I’m doing something wrong here but let me know if I can even do this?
Looks fine as far as the parameters go. Most SQL DB’s I’m familiar with will fail if the WHERE clause is after the ORDER BY clause. The error you are getting probably says so. (Show the error next time so we don’t have to guess.)
Moved the where clause too far up. DB’s don’t like them before the FROM clause, either. Consider looking at the manual of your DB for the strict syntax diagram for SELECT queries. (As suggested by the error message, too.)
Thanks, Not getting the error anymore just not getting data, That might be user error.
