Hello friends,
i need to create a report according to the below example.
in that example carname,CARID,CARMODEL,MANUFACTURE DATE ,BODY TYPE,Sales $,Incremental Sales $,DEALER NAME,DEALER LOCATION,DEALER SALES,QUANTITY SOLD are my columns in the masterfile and the names CAR DETAILS,SALES,DEALERS are the virtual names that are to be assigned to these particular columns accordingly. i tried using over to display the COLUMNS TO BE DISPLAYED AS ROWS across carname but i couldnt place the virtual names to that groups of data.thanks for your help
KUMAR
CAR Name AUDI BENZ BMW HONDA
CAR DETAILS CAR ID
CAR MODEL MANUFACTURE DATE BODY TYPE
SALES Sales $ Incremental Sales $
DEALERS DEALER NAME DEALER LOCATION DEALER SALES QUANTITY SOLD

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