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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
HOLD FORMAT DOUBT??
 Login/Join
 
arvind
Platinum Member
posted
hi friends ,

Thank you for your resolutions.

In my code , I have 3 hold files h1 ,h2 , h3. ..

Each hold file contains data which is fetched using different filter conditions .. Finally at the end of the report ..I have printed the output of the three hold files using

-HTMLFORM BEGIN
<HTML>
<TABLE>
</TD></TR>
<TR><TD>
!IBI.FIL.H1;
</TD></TR>
</TABLE>
<TABLE>
</TD></TR>
<TR><TD>
!IBI.FIL.H2;
</TD></TR>
</TABLE>
<TABLE>
</TD></TR>
<TR><TD>
!IBI.FIL.H3;
</TD></TR>
</TABLE>
</HTML>
-HTMLFORM END


And i am getting the correct output in HTML Format..

But my export to EXL2K and PDF is not working..

If i add the statement

ON TABLE HOLD AS H1 FORMAT &WFFMT.(<HTML,HTML>,<PDF,PDF>,<Excel 2000,EXL2K>Wink.Select type of display output.


in my fex code so that the user can dynamically select the output format..

The EXL2K and PDF format export is not working..

Am i missing something??

Thank you for your advice..


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Tony A
Expert
posted Hide Post
Arvind,

Think about what -HTMLFORM is actually doing and then realise that if you include a hold file using !IBI.FIL.filename; in the method that you use here, you are only embedding it direct into HTML. To give you a clue, Excel and PDF are not HTML formats that can be used within instream HTML.

If you want to push an Excel or PDF file into an HTML page then make sure you use an appropriate container or method to enable it to be displayed.

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
nubi
Guru
posted Hide Post
Arvind,

For what reason are you locking down your output statement to HTML?

if its because you can't display the reports independently on the same screen try doing this

TABLE FILE HOLD1
PRINT *
ON TABLE SET STYLE
(ADD STYLING IN HERE)
END

TABLE FILE HOLD2
PRINT *
ON TABLE SET STYLE
(ADD STYLING IN HERE)
END

TABLE FILE HOLD3
PRINT *
ON TABLE SET STYLE
(ADD STYLING IN HERE)
END

This will allow you to show the three reports separately on one HTML page and it should let you send these contents to a PDF, not sure how it works with excel but the key is to get it displayed how you want in HTML without using HTML commands but using WEBFocus and CSS code


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
If you still want to put all 3 reports together and give your users the option of choosing the output format, then you will have to look into doing a compound-type report that can handle all three formats.

You might also look into the MacGyver Technique and do all 3 reports together in one table request.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
arvind
Platinum Member
posted Hide Post
hi ginny,

I tried Mcgvyer Technique for putting all the three reports together..But i was not able to achieve it. Maybe my coding was wrong..

But as suggested by nubi ..If i write 3 separate Table file Requests for 3 hold files and give three separate &WFFMT for 3 hold files. dynamic output format statements..

ON TABLE HOLD FORMAT &WFFMT.(,,,,).Select type of display output.



Then also it is not working...

Thank you..


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Tony A
Expert
posted Hide Post
Arvind,

Search for topics on compound reporting

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
PBrightwell
Master
posted Hide Post
Are you prompting the user for the output or using a parameter screen to submit the program?

You can use compound with multiple output types. You style each report separately and you don't need the HTMLFORM.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
arvind
Platinum Member
posted Hide Post
Thanks PAT for the reply ,

I am using EXCEL and PDF icons in the report . When user clicks on it , the report gets exported to the format accordingly.

Have used Onclick functions in HTML code and passed the parameter to the FEX . ...

Yes i have done it ..I have set compound = open clause , and i have added OPEN/CLOSE in the PCHOLD Format accordingly..

Styled each FEX in different output format.


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
PBrightwell
Master
posted Hide Post
I may be having a senior moment, but the only thing I can think of is to treat the icons like a drill down and rerun the report with your pchold in that format.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders