Kumar,
Your posting is somewhat confusing. I had to read it over a few times.
Are you trying to produce something like the following:
Car Name : Audi
Car Details:
Car Model Manufacture Date Body Type
--------- ---------------- ---------
xxxxxxxxx 99/99/99 xxxxxxxxx
xxxxxxxxx 99/99/99 xxxxxxxxx
Sales: 99999.99 Incremental Sales 999999.99
Dealers:
Dealer Name Location Sales Quantity Sold
----------- -------- -------- -------------
xxxxxxxxxxx xxxxxxxx 99999.99 999
xxxxxxxxxxx xxxxxxxx 99999.99 999
xxxxxxxxxxx xxxxxxxx 99999.99 999
Ken
Prod - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Dev - WF 7.6.4 Unix/Solaris - Self-Service, BI Dashboard, MRE
Databases: Oracle 10g, SQL Server 2000, DB2.