Hi,

I am working on a project where I need to generate an Invoice for a
client using database tabls. Normal tables are Invoice, Client,
Address, Venue, Event (As this is the invoice for purchasing tickets
for a event), Ticket etc. Invoice can be a simple one or can be in
HTML.

I don't know how to write SQL code to generate this kind of reports. I
have a basic knowledge of SQL and I have written simple reports that
displays data in tabular form(using select statements). But never
written complex SQL to generate Invoice which is not in tabular form.

Tamplete For Invoice :

Company Name
Address, City, St, zip
Phone
Fax
-------

Billing Address and Shipping Address are side by side
------

Invoice
------------------
Event and Ticket Informations with pricing in tabular form


Subtotal and total :


Shipping Information :



Can somebody help to find out how to write this kind of Invoice using
SQL statements. Also how to write this embaded text and SQL queries.

Nick ...

build_ecommerce (AT) yahoo (DOT) com (E-Commerce Developer) wrote in message news:<15891182.0310110042.f03f75e (AT) posting (DOT) google.com>...

You'll need to check the manuals for your DB product to determine the
reporting features. This might involve options in the SQL app (BREAKs,
COMPUTEs and such) or it may require a different Report writer tool.
In the extreme case, you might have to write you own custom
application (in C, COBOL, PERL, whatever).

IOW, there are just too many variations between DB systems. You need
to RTFM. Our crystal balls are all in the shop.

Ed Prochak