Are you using DADE? If so, then you can edit the SQL in the SQL tab of the Query Designer. However, you'll lose the other functions, because we validate the SQL, and can't perform any validation, once you've manually edited the SQL text.
To add search criteria to a report (not using DADE) use Report.CreateAutosearchField.
To add search cirteria to a report (with DADE dataviews) then use Report.CreateAutosearchCriteria. See the help file for info on these two methods.
Comments
Query Designer. However, you'll lose the other functions, because we
validate the SQL, and can't perform any validation, once you've manually
edited the SQL text.
To add search criteria to a report (not using DADE) use
Report.CreateAutosearchField.
To add search cirteria to a report (with DADE dataviews) then use
Report.CreateAutosearchCriteria. See the help file for info on these two
methods.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com