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     [SOLVED] Dynamically changing the column title

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Dynamically changing the column title
 Login/Join
 
krish
Gold member
posted
I understood that compound reporting in excel format for RC busted reports are not supported in WebFOCUS 7.6.5.(So I can’t go by Tabbed Excel report )

So at least is this possible in WebFOCUS
My satiation is like this

Define file car
Fourm1/I1 = if sales gt 12000 then 1 else 0;
End

Table file car
Print *
By Fourm1 no print
On Fourm1 page-break
On table pchold format exl2k
end

it displays two pages in it.

Well, is possible for me to change the title of the column from “sales” to “underperformed “ in the first page alone


I don’t want to use compound reporting since which will not be supported in RC Busted(Format Excel) in WebFOCUS 7.6.5

7.6.5
Windows XP
Excel

This message has been edited. Last edited by: Kerry,
 
Posts: 64 | Location: North Carolina | Registered: December 04, 2007Report This Post
<JG>
posted
Best bet is SUBHEAD
 
Report This Post
Danny-SRL
Virtuoso
posted Hide Post
JG,

I couldn't do better:
  
-* File krish3.fex
DEFINE FILE CAR
UNDER/I1=IF SALES LT 12000 THEN 0 ELSE 1;
END
TABLE FILE CAR
PRINT SALES AS ''
BY UNDER NOPRINT PAGE-BREAK
BY COUNTRY  AS ''
BY CAR  AS ''
BY MODEL AS ''
ON UNDER SUBHEAD
"COUNTRY<+0>CAR<+0>MODEL<+0>UNDERPERFORMED"
WHEN UNDER EQ 0
SUBHEAD
"COUNTRY<+0>CAR<+0>MODEL<+0>SALES"
WHEN UNDER GT 0
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=BODY, $
ENDSTYLE
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
krish
Gold member
posted Hide Post
Thanks a lot Danny and JG. i have solved the issue. by the by you people have any tricks to get a two tabbed excel report in RC busted Mode?

Krish
7.6.5
Windows
Exl2k
 
Posts: 64 | Location: North Carolina | Registered: December 04, 2007Report This Post
Darin Lee
Virtuoso
posted Hide Post
I may be mistaken, but I think that bursting of compound documents through RC was a new feature in 7.6.9.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Tony A
Expert
posted Hide Post
If Darin is correct in his assumption then that is a good move, however, the method I use is to create a compound file in a network location for each "burst" value. As I build each report I also build a VB Script file that will be run upon completion. This VB Script file opens each file in turn and saves it to the same location but as a format of "xlNormal". The VB Script file then sends the file(s) to the various email addresses using CDONTS. This is something you might be able to do as you are on a windows setup - if you were on Unix then I would ask another contributor to advise.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
<JG>
posted
I might be wrong but compound document bursting only works for DHTML, PDF, and PPT formats
even in 769
 
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     [SOLVED] Dynamically changing the column title

Copyright © 1996-2020 Information Builders