Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Renaming an Amper field in the GUI

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Renaming an Amper field in the GUI
 Login/Join
 
Member
posted
We're running WebFocus 5.2.4 and I am trying to use the GUI more. I have a field in my report that is an amper variable. The user selects a measure from the launch page and that measure appears in the variable field in the report. My question is, how do I change the column title for the measure that comes back using the GUI? For instance if the measure coming back is GROSSPROFIT I want it to say Gross Profit (no underscore). GROSSPROFIT is also a defined field so I can't change the field alias in the master file.
I know how to do this in code - I just want to know if it can be done in the GUI?
 
Posts: 7 | Registered: June 24, 2003Report This Post
<pranas>
posted
Just one suggestion:

>"I can't change the field alias in the master file."

Your should use " AS 'Value to display'" syntax directly in FEX procedure instead of changing alias in the master file

Sample:


-SET &COLUMN_TITLE='Model,name';
-SET &COLUMN=MODEL;

TABLE FILE CAR
PRINT &COLUMN AS &COLUMN_TITLE
END
If you mean GUI is Developer Studio. I've stopped using it. Direct had written FEX coding is extremely flexible comparing to "static" reports created via Developer Studio.

This message has been edited. Last edited by: <Mabel>,
 
Report This Post
Member
posted Hide Post
Thanks, but like I said, I already know how to accomplish that using the code.

I agree the code is much more flexible but the GUI has progressed quite a bit especially in the newest release and I just wondered if it could be done that way. I guess I will have to go back to coding by hand. Anyone else had any luck with this in the GUI?
 
Posts: 7 | Registered: June 24, 2003Report This Post
Expert
posted Hide Post
well, if your're talking about Reporting Objects, and the GUI there, then you can set the TITLE attribute in the master file description for the Reporting Object, and the purpose of the TITLE field is to be the column header in the reports.
so..actually, if you enter a TITLE attribute in the MFD in devstudio, you'll get the same thing.
I, like Pranas, don't use the GUI either, but i do create RepObjs for my users.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
<Kyle>
posted
I think you simply want the default field title in the MFD to appear by default when you run the report. In DevStudio524, simply right click on amper field and choose Column Title. Click the default button and Ok. This simply removes the default "AS '&variable'" from the end of the field.

I've noticied 1 issue with this in 5.2.4, when you reopen the report the "AS '&variable'" is added back to the report.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Renaming an Amper field in the GUI

Copyright © 1996-2020 Information Builders