 |
|||||
|
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
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 TopicGo | Search | Notify | Tools |
| [SOLVED] Column splitting | Login/Join |
| Member |
Hi all, We have a report which has 17 columns in it. While taking printout only the first 10 columns are displayed in the printout. The remaining 10 columns are truncated from the print-out. Is there any option to display the first 10 columns in the first page and the next seven columns in the second page? Thankyou, Ajai.This message has been edited. Last edited by: Ajai, WebFOCUS 7.1.4,Linux, HTML,PDF,Excel,CSV | ||
|
| Expert |
HTML is not the best format with which to provide printable output - use PDF format instead which honours ORIENTATION and PAGESIZE from within the STYLE. Use WIDTH and WRAP with TYPE=REPORT to control column width. T
| |||||||||
|
| Member |
Hi Tony, We have a separate PDF format output for the same report, and we have controlled the width of the report using WRAP command. But our client requires a printable HTML format also. Any suggestions for that? Thankyou, Ajai. WebFOCUS 7.1.4,Linux, HTML,PDF,Excel,CSV | |||
|
| Expert |
Tell them that HTML is not suitable for reliable printing and that is why you provide a PDF output format, then get them to use PDF as supplied. And when they tell you that they really want to print from HTML, set about playing with the STYLE so that you can get the output they need. You might want to change the output to HTMTABLE and enclose in -HTMLFORM BEGIN and -HTMLFORM END, or even use SET JSURL and SET CSSURL to take advantage of any CSS or JavaScript you might like to utilise. Search the Internet for possible HTML solutions. T
| |||||||||
|
| <JG> |
Change browser to a version that allows scalable printing like IE7 | ||
|
| Member |
JG, Most of our clients are using IE6. And we cannot advise our clients to change the browsers they use  Thankyou, Ajai. WebFOCUS 7.1.4,Linux, HTML,PDF,Excel,CSV | |||
|
| Virtuoso |
If everybody always should stay to work he or she is used to, we did not have airplanes, cars, trains but only have horses (or elephants) to travel. We still should use bow and arrow to make war....that would be nice....
| |||||||
|
| Expert |
Ajai, There are several ways to do this: alternate master with a dummy sort field and the MacGyver Technique are two of these. It would be helpful to know what the formats of these 17 fields are. 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 | |||
|
| Expert |
¿¿¿ For printing an HTML page ??? Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
No, for splitting up the data on two "pages". 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 | |||
|
| Expert |
Have you tried FORMAT DHTML, it is more like PDF, just not sure about the page length. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
You want to print 17 columns on a single page printing from an HTML browser? Good luck with that one. HTML and browsers are NOT for printing pretty documents - that's why on MANY applications there is a "Printable Version" button or link. Different browser types, browser versions, window sizes, font size displays, etc., etc. make it very difficult to control how something displayed in an HTML document actually comes out when you click the print button. Back to the previous comments - the way to do that is provided by creating a PDF document. 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 | |||
|
| Member |
Ginny, Thanks for your suggestions.I checked the McGyver technique, but the examples given in IBI's techsupport site were maily related to joining two different tables and also to produce subtotals at desired positions. I am not able to apply them into our scenario. Can you please give me an example? Waz, The webfocus version which we currently use (WF 714), is not supporting DHTML format. Thankyou, Ajai. WebFOCUS 7.1.4,Linux, HTML,PDF,Excel,CSV | |||
|
| Guru |
if my clients insisted on a printable HTML version i'd just provide a 'Printable Version' hyperlink which reran the report in PDF format 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 | |||
|
| Expert |
All Things Different This is the one that should work for you. Ignore the part about subtotals. This one shows how you can print different columns based on the value of a sort field. 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 | |||
|
| Expert |
Ajai, to quote from Maxwell Smart.. 
I ran it here on 7.1.6, it worked. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Hi all, Thankyou for your suggestions. We have finally decided to go with PDF format itself. Thankyou, Ajai. WebFOCUS 7.1.4,Linux, HTML,PDF,Excel,CSV | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |