Hi

I have a HOLD file but not sure how to display it in the footing. Basically HOLD file will have 2 columns, for ex..CAR and SALES and I need to display them in the footing. How could I do this?

Thank you

This message has been edited. Last edited by: Kathleen Butler,

are they always the same field?

 FOOTING
"<CAR <SALES" 

Yes, the field names don't change.

quote:

Originally posted by Prarie:
are they always the same field?

 FOOTING
"<CAR <SALES" 

Maybe something like this:

DEFINE FILE CAR
 QUOTE/A1 = '"';
END
-*
TABLE FILE CAR
 PRINT QUOTE CAR SALES QUOTE
 ON TABLE HOLD AS CARHOLD FORMAT ALPHA
END
-RUN
-*
TABLE FILE CAR
 PRINT COUNTRY CAR MODEL
 FOOTING
-INCLUDE CARHOLD.FTM
END

Hi,

I checked with Noreen Redden and she suggested the following:

Since you already have the example of the INCLUDE from a TABLE, the other way is using Dialogue Manager.
-* IF YOU KNOW THE NUMBER OF RECORDS IN THE HOLD FILE, THEN SET THAT AS THE DEFAULT FOR &MAX
-* OTHERWISE, IT WILL GO UNTIL THERE ARE NO MORE RECORDS, &IORETURN EQ 1 AT EOF
-DEFAULT &MAX = 100
TABLE FILE CAR
the report
FOOTING
" CAR SALES "
" ------- ----------"
-REPEAT ENDLP &MAX TIMES
-READFILE holdfile
-IF &IORETURN NE 0 GOTO ENDIT
" &CAR &SALES "
-ENDLP
-ENDIT
END
-RUN


Let us know if this helps.

Have a great day.

Sincerely,

Kathleen Butler
Information Builders