RAVE REPORTS
-
I have searched all over for a proper manual - alas! I need to produce a Rave Report from an SQL statement in Delphi7, something like SELECT * FROM tblTransaction WHERE TransDate>=[Starting Date] And TransDate<=[End Date] ORDER BY Category, TransDate; (TransDate and Category are fields in the table) The report must look like an MS Access report GROUPED by Category, then all the Transactions in that group (Category) ordered by TransDate, followed by a sub-total for the group and, finally, an overall TOTAL for all the transactions. The transactions are invoices with such information as supplier, date paid, detail, etc. The SQL must be passed to Rave Reports from Delphi, as must be the ConnectionString to the database. There are sites advertising examples of Rave for sale but, they are not specific and I do not want to spend unless I know it's what I'm looking for. Hannes