TABLE FILE TFSP5014
PRINT
'TFSP5014.ANSWER.4' AS 'Last Date,'
'TFSP5014.ANSWER.5' AS 'Comments,'
'TFSP5014.ANSWER.6' AS 'Ticket,' OVER
'TFSP5014.ANSWER.7' AS 'Issued Date,'
'TFSP5014.ANSWER.8' AS 'License Plate,'
'TFSP5014.ANSWER.9' AS 'State,'

The output of this query diplaying only data values, not the column headings. How can i get column headings also for each of the field.This is a Developer studio-Report Painter(HTML format)
thanks for the help,
ram

This message has been edited. Last edited by: Kerry,

I don't know if this is your problem but a fieldname should begin with a letter not a number.

The focus query:
TABLE FILE TFSP
PRINT
'TFSP.ANSWER.4' AS 'Last Date,'
'TFSP.ANSWER.5' AS 'Comments,'
'TFSP.ANSWER.6' AS 'Ticket,' OVER
'TFSP.ANSWER.7' AS 'Name,'
'TFSP.ANSWER.8' AS 'License Plate,'
The output of this query is:
2006-7-10 Notinuse
123 John AIX45

The result of the output should be with column heading:
Lastdate Comments
2006-7-10 Notinuse

Ticket Name LicensePlate
123 John AIX45

thanks for the help,
ram

Please post your master file description.

Hi,

Have you tried removing the comma in the column heading name (ie. 'Last Date,')?

It might be causing a problem with multiple lines with a OVER command.

Best Regards,

Jimmy Pang

Here is one possibility using the CAR file as an example. This is not very elegant but it may give you output similar to what you want.

DEFINE FILE CAR
 COLTITLE1/A10 = 'Country';
 COLTITLE2/A10 = 'Car';
 COLTITLE3/A10 = 'Model';
 COLTITLE4/A10 = 'Body Type';
 COLBLANK/A10  = ' ';
END
-*
TABLE FILE CAR
 PRINT
  COLTITLE1 AS ''
  COLTITLE2 AS '' OVER
  COUNTRY AS ''
  CAR AS '' OVER
  COLTITLE3 AS '' COLTITLE4 AS '' OVER
  MODEL AS ''
  BODYTYPE AS '' OVER
  COLBLANK AS ''
  COLBLANK AS ''
END

HI JIMMY,
I removed commas, it is working fine.But the new issue is, data values are displaying side of the Column title. I really needs data values below the Titles.The reason why i put commas.How can i display data values below column titles?.I need this help.
i.e
col1 col2 col3
45 123 45

col4 col5 col6
675 34 2356

thanks for the help,
rama

Then you can't use OVER. You haven't provided sufficient detail regarding sort fields and number of rows per sort field. So here are a couple of ideas. You could put the information in a subheading. That way you control the formatting. If there are more than one entry per sort field, you could make up a phony one, i.e. a counter, and break on that.

Another way is to use MacGuyver or an alternate master and force the sets of columns into two separate records per sort field and have rows for the column headings as well. This is a sophisticated technique, though.

Let us know if any of these ideas helps you.

Sounds like the same question posted a fourth time!!