Can I inject a customized SQL "Where Clause" or other expression into my queries?
Yes, you can perform this in a couple of ways.
Lets say you have the following situation:
You have 2 views: invoices and payments. But when you run a report where the invoice date is a range and you want to display any blank payments also included in this report, you will have an issue where the payment date will show blanks if the payment amount is blank.
There are 2 basic ways to address this problem.
In your filter, select Use Previous Or to bring in payments.
Last edited by Joseph Adams, 2014-05-20 17:17:12