Would it be possible to have a table field with multiple rows of information display all of this information in a FOOTING?

Ex.
TABLE FILE CAR
PRINT
'CAR.MAKE'
FOOTING
"Models for ON TABLE PCHOLD FORMAT PDF
END

If I run the above code it will only return the first car model in the FOOTING but I would like it to return all models for the make.

WF 7.6.9

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

Sorry my original post example was incorrect.

Ex.
TABLE FILE CAR
PRINT
'CAR.MAKE'
FOOTING
"Models for CAR.MAKE are CAR.MODEL"
END

HEADINGS and FOOTINGS only show 1 record, as they have no relationship to the data, only the report as a whole.

You could try to build the text for the footing in a TABLE FILE / HOLD prior to this TABLE FILE and -INCLUDE it.

Effectively have FOCUS build some code for you.

You may also try using a Compound Report where all of the rows you want "at the bottom" will be displayed in the second component right after the first one.

Thanks, Waz & njsden. I'll give the hold files a shot and see how that goes.

klcc,

You have in fact asked for 2 things:
1. MODELs in the FOOTING
2. Different MODELs for each CAR.

If you use the compound report way, then you will need 2 reports for each value of CAR, the first showing the CAR data, the second the MODEL data, all that within a loop for the values of CAR.

If you go for the FOOTING way, then I suggest you create a number of DEFINE fields for the values of MODEL. You will have to find the maximum number of MODELs per CAR and load each DEFINE field with the appropriate value of MODEL depending upon the value of CAR. Then insert these DEFINE fields in the FOOTING.

Good luck!

I thought this sounded familiar

http://forums.informationbuild...617091126#7617091126