Quick report - 2 SQL queries
Posted on 1998-05-01
I want to make a quick report in Delfi 3. In this quick report
there should come a line from one query followed by one or more lines from another query.
I am new to Delfi, but have much experience with other programming platforms.
I have to use queries because the data is in several tables.
However to simplify the problem consider it to be :
Query 1 : select name from customers
Query 2 : select amount from order
I would of course want the two queries to be linked, thus query 2 should be something like
select amount from order where customId = customers.customid.
How do I excatly set up the bands (title band, detail band,...) in order to accomplish this.
Is there a good description of the quick reports available?