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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Printing TX50 fields
Go
New
Search
Notify
Tools
Reply
  
Printing TX50 fields
 Login/Join
 
<Cisco>
posted
Does anyone know if there are any known issues when doing this in webfocus 5.2?

No matter what way I print, I only ever get the first instance of a TX50? All other instances are blank.

Here is the code

TABLE FILE ISSUINFO
HEADING CENTER
"PSDB Reporting"
PRINT
UPDATEDETAILS ** Text file one
BY ISSUENUMBER NOPRINT PAGE-BREAK
ON ISSUENUMBER SUBHEAD
"Issue Number: "
" < EXPR2 > " text file 2
ON ISSUENUMBER SUBFOOT
"Method of Implementation: "
END


In the above code, EXPR2 display ok, but Update Details only gives me the first row

Also if I just try a normal print

TABLE FILE ISSUDETL
""
END

or

TABLE FILE ISSUINFO
""
END

All I get the first instance in the database then a long list of blanks. Yet stranfely in my first example EXPR2 will print ok.

Does anyone know of any problems with TX50 printing? Or any techniques to print TXT50 fields?

Thanks!!
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Is this a join issue, you don't show one. If so are you expecting multiple instnces if so may need a join xxx to ALL xxx.

Or you may have a key issue in your join.
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Reply With QuoteReport This Post
<Cisco>
posted
The first example is a join yes, but I'm pretty sure the join is correct.

The second two examples though

TABLE FILE ISSUDETL
" < USERDETAILS > "
END

or

TABLE FILE ISSUINFO
" < EXPR2 > "
END

don't use a join at all and I still get the same problem. They are just simple prints from an MFD.

TABLE FILE ISSUINFO
PRINT EXPR2
END

TABLE FILE ISSUDETL
PRINT USERDETAILS
END

Give the same problem
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Printing TX50 fields

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