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.
|<Pietro De Santis>|
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
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.
TABLE FILE Q01HOLD
You may need a special file which has the tag values and the parent field for each tag. eg.
FIELD=PACCOUNT, ,,, PROPERTY=PARENT_OF,
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.
|Powered by Social Strata|