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.
Hello, the request in format pdf doesn't detect the character CRLF's(new line).
The output generated is: line1line2
when the correct output is: line1 line2
Is there any patch for resolve this case? WF5.3.2
Is there any character that previously I can add in the field for the format pdf detects like a new line? For example: in format html I can add the tag <br> and the iexplore detects ok like a new line. Thanks in advance.
I have a table in Oracle with a varchar2(4000), in this field we usually store the content of a file txt or some text like comments introduce by user. Therefore this field usually has CRLF's (new line).
I need to build an inform in format pdf that shows this field in the data section.
Something like that: TABLE FILE PRINT FIELD_CRLF ON TABLE PCHOLD FORMAT PDF END
Thanks Francis, I'm working around and I have a new idea: I build the report1 in format PDF, I show others columns and on the last column(FIELD_CRLF) I create a link(FOCEXEC) to another report2 that only shows the FIELD_CRLF in format HTML, I previously translate CRLF with tag <br>.
It's works fine but, for a complete solution, I need that the second report can open in a new window like if I use a window.open with parameter _blank.
I had tried with the parameter TARGET in FOCEXEC, but i think it isn't supported by format PDF.
I'm thinking that I can link to new fex than only has a piece of html(HTMLFORM), in this fex I can write a javascript function that opens the second report in a new window but I have found one problem: I need change the url in report1(PDF) to call a new fex and therefore I lose the information in this window, history.back no there is a better solution. The report1 is very heavy and i don't want to re-execute the report.
Finally, Anyone Knows how I can open a report in a new window from other report in format PDF?.
The same window launch is a 'feature' of Adobe Acrobat viewer and will be the same for any language that produces a PDF format document. Basically Acrobat viewer will always launch a link in the same viewer window. So the anwser to your final question is (I think) that you can not.
I think your workaround of changing the URL in report1 (PDF) is probably too OTT and a simple link to an HTML page should still allow the back button to be used within the browser.
The following code demostrates this (copy and save it as CARTEST.fex) -
-DEFAULT &WFFMT='PDF'; TABLE FILE CAR SUM 'BODY.DEALER_COST/D10.2!L' 'BODY.RETAIL_COST/D10.2CN' 'BODY.SALES/D12.2!L' BY 'ORIGIN.COUNTRY' BY 'COMP.CAR' BY 'CARREC.MODEL' ON TABLE SET ONLINE-FMT &WFFMT ON TABLE SET STYLE * TYPE=DATA, COLUMN=N3, FONT='ARIAL', COLOR='RED', FOCEXEC=CARTEST(WFFMT='HTML'), TARGET='_blank', $ ENDSTYLE END
This message has been edited. Last edited by: <Maryellen>,
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, 2004