Subject Re: SQL Query Front End From Mervyn Bick <invalid@invalid.invald> Date Thu, 14 Feb 2019 09:13:15 +0200 Newsgroups dbase.getting-started Attachment(s) firebird_report1.jpg, firebird_report2.jpg On 2019-02-14 12:30 AM, Dan Bernard wrote: > Is it possible to build a front end to a SQL query that would allow my users to enter variables, ie. a date range, and run a report?  If so, are there examples? > The short answer is yes. :-) In practice it probably depends on the SQL you will be using. If you have Firebird 2.5 installed I can give you example code. I tried this using ADO in dBASE 12.3.1 but there is a bug which causes the report to only show 1 record.  Accessing the Firebird table via the BDE with a normal query works just fine. It is quite possible that accessing a different SQL server using ADO will work. Two screenprints are attached.  The first shows a section of the report for all records. The second shows records for date between 1990-01-01 and 1990-12-31.  I haven't ordered the records for the examples. Mervyn.