Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
For field problem
 Login/Join
 
<kvn>
posted
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.
 
Reply With QuoteReport This Post
<Pietro De Santis>
posted
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.
 
Reply With QuoteReport This Post
<kvn>
posted
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
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.