I'm trying to make a matrix of some data using FOR but it's not showing any tag values. I've concantenated several hold files using USE. Then from the USE hold file it's held into a ALPHA hold file. Is there a reason why it's not showing me any tag values through my hold file? Am I using the wrong type of hold file?

I've used the FOR command in other reports where I didn't need a hold file and it worked fine.

If your HOLD files are not FOCUS databases then the USE command will not work - it only works for FOCUS databases.

I image that the field names in your HOLD files are identical, you could use the MORE command. TABLE the report off the first HOLD file, write all the code except the END statement, then add
MORE
FILE holdfile2
MORE
FILE holdfile3
etc

I think you can have selection criteria for each of the HOLD files if necessary.

Ok, well am able to report off the USE. So I don't think that's the problem. When I specify a FOR field no tag values show up in the matrix tab.

I tried using MORE but I get a 'error parsing report request. >FILE< FILE Q02HOLDF'

All the hold files are saved as FOCUS format.

CODE:
TABLE FILE Q01HOLD
PRINT
Q01_Q
Q01_YTD_5
Q01_YTD_4
Q01_YTD_3
Q01_YTD_2
Q01_YTD_1
MORE
FILE Q02HOLD
MORE
FILE Q03HOLD
END

You may need a special file which has the tag values and the parent field for each tag. eg.
FIELD=ACCOUNT, ,,,,$
FIELD=PACCOUNT, ,,, PROPERTY=PARENT_OF,
REFERENCE=ACCOUNT,$
FIELD=TEXT,,,, PROPERTY=CAPTION,
REFERENCE=ACCOUNT,$

This is joined to the data file, eg
JOIN ACCOUNT IN SPECIAL to ALL ACCOUNT IN HOLD
and the Report Painter Matrix painter now has the structure of the tags.