Hi All,

I have a table in the following format

 
CAR    COUNTRY  COST  LENGTH  QUEST  ANS 

 
JAGUAR ENGLAND  7,427  190      A    B
                                C    D
                                E    F 
JENSEN ENGLAND  14,940 188      A	 B
			     C    D
			     E    F
			     G    H
			     I    J

Country England	
CAR      Jaguar	
Cost Information	
COST	7,427
Size Related Information	
LENGTH	190
OTHER Detail	
A	B
C	D
E	F
CAR  Jensen	
Cost Information	
COST	14,940
Size Related Information	
LENGTH	188
OTHER Detail	
A	B
C	D
E	F
G	H
I	J
CAR  Triumph	
Cost Information	
COST		
Size Related Information	
LENGTH		
OTHER Detail	
	

Country Italy

and So on


I am able to get 'Cost Information' and 'Size Related Information' in the above format (using OVER etc).

But the challenge is the 'Other Detail' section as this comes from colum data (please note 'QUESTION and ANSWER' fields in the sample table structure above.

Also refer case no. 70492513 on IBI tech Support.

Can anyone help me with this?

Thanks

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

Have you thought about putting the Country, CAR, COST, LENGTH in a heading or subhead ?

Also please put you sample data between the code tags, as it will preserve the spaces.

Hi Waz,
Thanks for the response.
I waited for a long time for one!.
Actually I put the columns in Subhead and tried 'OVER'. But i am unable to get the above format.
The problem with this is that QUEST and ANS are columns and everything else is row data.
So OVER is not giving the right output.
The 'Other Details' Section is giving me problems.

Create a new field that holds both the question and answer value (A and B, C and D) would that be possible?

Or is there no relation between those 2 ?

Waz is correct. Use SUBHEAD and ignore OVER, unnecessary.

Something like this may work:

TABLE FILE fn
PRINT   QUESTION AS '' 
        ANSWER AS ''
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY COST NOPRINT
BY LENGTH NOPRINT
BY QUESTION NOPRINT
 
ON LENGTH SUBHEAD
" "
" Country : <COUNTRY"
" Car : <CAR"
" Cost Information"
" Cost : <COST"
"Size Related Information	"
"Length : <LENGTH"
"Other Detail"
.
.
.	

Thanks Frank and Alan.

Frank,
I can hold the data in one field.
How can I go about it after that.
Alan,
This is very close to what I want.
But the formatting is a challenge here.
How do I get a grid in the Subhead?
or do I have to manipulate?

Thanks
Djay

Manipulate. Something like:

.
.
.
ON TABLE SET STYLE *
GRID=OFF,FONT=ARIAL,SIZE=10,$                                                           
TYPE=SUBHEAD,BY=LENGTH,HEADALIGN=BODY,$
TYPE=SUBHEAD,BY=LENGTH,LINE=4,STYLE=UNDERLINE,$
TYPE=SUBHEAD,BY=LENGTH,LINE=6,STYLE=UNDERLINE,$
TYPE=SUBHEAD,BY=LENGTH,LINE=8,STYLE=UNDERLINE,$
ENDSTYLE

should give a start.

Thanks a ton Alan! This Works!