Cool wIntegrate Query Builder Techniques

Let's say that you want to use the wIntegrate Query Builder to create a new query. Building a query is simple enough, but what you really want to do to allow users of the query to specify the records to be included in the report based on criteria they enter when they run the report.

This article illustrate the technique by describing the process of selecting records by Date Range, i.e. when you run the Query it will prompt for the Beginning and Ending Dates, which will then be used to limit the records being reported. The approach will be to modify an existing report that has a hard-coded date range in its definition.