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
  
lookup table
 Login/Join
 
<tom>
posted
I am new to Focus, so bear with me. I am using sql server as data source. I have a table with code/descrip fields. I need to display the descrip and not the code. Not sure how to accomplish this. Create a hold file to use for a DECODE? Or is there something in the LOOKUP function? Thanks in advance.
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I'm going to assume this is a report, so:
1) Join the description table to the source table.
2) Use the descr field instead of code in the final report.

e.g.
JOIN CODE IN Source TO CODE IN Description AS J1
TABLE FILE Source
SUM ....
BY CODE NOPRINT
BY DESCRIPTION
END

Hope this helps.
 
Posts: 1100 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
<tom>
posted
worked great!! Thanks
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 


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