Hi,
i have a report whose output should be displayed in exl. the problem i am facing is that i am not able to allign the heading of the report. that is in my heading i have to display two different values in a single line separated by some space for example i need to diplay
CARNAME AND MODEL AS A SINGLE HEADING BUT SEPERATED BY SOME SPACE IN BETWEEN AND WHEN I TRY TO DO IT ITS DISPLAYING THEM SIDE BY SIDE. IS THERE ANY WAY I CAN FIX THIS PROBLEM.
Thanks
Maddy

Is this what you want to do? -:

DEFINE FILE CAR
NAM_MODL/A20 = NAME||' '||MODEL;
END

TABLE FILE CAR
PRINT
NAM_MODL AS 'Name and Model'
ON TABLE PCHOLD FORMAT EXL2K
END

Thanks unfocused but that is not what i am looking for . i want to display two fields in my report heading in a single line separated by blank spaces.
TABLE FILE CAR
PRINT
ON TABLE SUBHEAD
"COUNTRY:<COUNTRY DATE:&DATE "
ON TABLE SET ONLINE-FMT EXL2K
END
I NEED MY HEADING TO BE DISPLAYED IN A SINGLE LINE SEPARATED BY SPACES.IS IT POSSIBLE IN EXL2K
THANKS
MADDY

DEFINE FILE CAR
SHEAD1/A100 = 'COUNTRY: ' | COUNTRY || (' DATE: ' | '&DATE');
END
TABLE FILE CAR
PRINT
CAR
BY COUNTRY
ON TABLE SUBHEAD
-*"COUNTRY:<COUNTRY DATE:&DATE "
"<SHEAD1"
ON TABLE SET ONLINE-FMT EXL2K
END

Can you clarify what you mean by :

"the problem i am facing is that i am not able to allign the heading of the report"

and "some space between".

What are you trying to align? The heading fields with columns in the report.

Ken